-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathReemplazar.frm
226 lines (195 loc) · 6.29 KB
/
Reemplazar.frm
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
VERSION 5.00
Begin VB.Form frmReemplazar
BorderStyle = 3 'Fixed Dialog
Caption = "Reemplazar ...."
ClientHeight = 1515
ClientLeft = 2445
ClientTop = 4215
ClientWidth = 7230
Icon = "Reemplazar.frx":0000
LinkTopic = "Form1"
LockControls = -1 'True
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 1515
ScaleWidth = 7230
ShowInTaskbar = 0 'False
Begin VB.CommandButton cmd
Caption = "&Salir"
BeginProperty Font
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 405
Index = 2
Left = 5730
TabIndex = 4
Top = 990
Width = 1425
End
Begin VB.CommandButton cmd
Caption = "&Reemplazar Todo"
BeginProperty Font
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 405
Index = 1
Left = 5730
TabIndex = 3
Top = 540
Width = 1425
End
Begin VB.CommandButton cmd
Caption = "&Reemplazar"
BeginProperty Font
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 405
Index = 0
Left = 5730
TabIndex = 2
Top = 90
Width = 1425
End
Begin VB.Frame Frame1
Caption = "Reemplazar"
BeginProperty Font
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 1275
Left = 120
TabIndex = 5
Top = 60
Width = 5535
Begin VB.TextBox txtReemplazar
Height = 285
Left = 1350
TabIndex = 1
Top = 720
Width = 4035
End
Begin VB.TextBox txtBuscar
Height = 285
Left = 1350
TabIndex = 0
Top = 360
Width = 4035
End
Begin VB.Label Label2
AutoSize = -1 'True
Caption = "Reemplazar por"
Height = 195
Left = 120
TabIndex = 7
Top = 720
Width = 1110
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "Buscar"
Height = 195
Left = 120
TabIndex = 6
Top = 390
Width = 495
End
End
End
Attribute VB_Name = "frmReemplazar"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private frm As New frmQuery
Private Sub Reemplazar(ByVal Tipo As Integer)
On Local Error GoTo ErrorReemplazar
Dim sBuscar As String
Dim sReemplazar As String
Dim lPos As Integer
sBuscar = Trim$(txtBuscar.Text)
sReemplazar = Trim$(txtReemplazar.Text)
If sBuscar = "" Then Exit Sub
gsFindText = sBuscar
If Tipo = 1 Then
If gbLastPos = 0 Or gbLastPos > Len(gsBuffer) Then
lPos = 1
Else
lPos = gbLastPos
End If
Else
lPos = 1
gsBuffer = frmMain.ActiveForm!txtQuery.Text
End If
If Tipo = 1 Then
lPos = InStr(lPos, UCase$(gsBuffer), UCase$(sBuscar))
If lPos <> 0 Then
gbLastPos = lPos
Mid(gsBuffer, lPos, Len(sReemplazar)) = sReemplazar
Else
gbLastPos = 0
End If
Else
gsBuffer = Replace(gsBuffer, sBuscar, sReemplazar)
gbLastPos = 0
End If
frmMain.ActiveForm!txtQuery.Text = ""
frmMain.ActiveForm!txtQuery.SelStart = 1
frmMain.ActiveForm!txtQuery.SelColor = glbColorSql
frmMain.ActiveForm!txtQuery.SelLength = Len(gsBuffer)
frmMain.ActiveForm!txtQuery.Text = gsBuffer
frmMain.ActiveForm.HayCambios = True
'frm.txtQuery.Visible = False
Call frmMain.ActiveForm.FormateaSentencias
'frm.txtQuery.Visible = True
Exit Sub
ErrorReemplazar:
Err = 0
gbLastPos = 0
End Sub
Private Sub cmd_Click(Index As Integer)
Select Case Index
Case 0 'R
Call Reemplazar(1)
Case 1 'R.t
Call Reemplazar(2)
Case 2 'Salir
Unload Me
End Select
End Sub
Private Sub Form_Load()
CenterWindow hwnd
Call SetWindowPos(Me.hwnd, HWND_TOPMOST, Me.Left, Me.Top, Me.Width, Me.Height, SWP_NOMOVE + SWP_NOSIZE + SWP_NOACTIVATE)
txtBuscar.Text = gsFindText
gsBuffer = UCase$(frmMain.ActiveForm!txtQuery.Text)
gbLastPos = 0
End Sub
Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
Call SetWindowPos(Me.hwnd, HWND_NOTOPMOST, Me.Left, Me.Top, Me.Width, Me.Height, SWP_NOMOVE + SWP_NOSIZE + SWP_NOACTIVATE)
End Sub
Private Sub Form_Unload(Cancel As Integer)
Set frmReemplazar = Nothing
End Sub