>hi all,
>
>is there a way to convert it to vfp code
>
>for i= thisform.text1.value to thisform.text12.value
> if (i)any text <>space""
> REPLACE (thisform.text2.Value) WITH NEWNAME
> REPLACE (thisform.text3.Value) WITH NEWNAME
> REPLACE (thisform.text4.Value) WITH NEWNAME
> REPLACE (thisform.text5.Value) WITH NEWNAME
>..
>..
>..
>..
>..
> REPLACE (thisform.text11.Value) WITH NEWNAME
> REPLACE (thisform.text12.Value) WITH NEWNAME
> ENDIF
>ENDFOR
>
>thanks.
I am not sure exactly what you want to do.
To loop through the textboxes, you might use something like this:
for i = 1 to 12
loTextBox = eval("ThisForm.Text" + trans(i))
loTextBox.Value = ...
loTextBox.Visible = ...
loTextBox.Top = ...
next
REPLACE is used for fields in a table. To change the TextBox, just use the .Value property.
If you want to REPLACE table fields, where do you have the name of the fields, and the values?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)