>....code after tables have been opened
>
>SELECT Table1
>SCAN
>REPLACE Field1 WITH FieldValue IN Table1
> IF SEEK(Field2, "Table2", 2)
> IF Table2.Field1 = .T.
> INSERT INTO Table3 blah blah blah.....
> ENDIF
> ENDIF
>ENDSCAN
I don't know the answer to your question. But I do have two suggestions:
1) IF Table2.Field1 = .T. can be simplified to: IF Table2.Field
2) Use PRE tags, or otherwise the web page omits spaces. Like this (press REPLY to see the source code):
SELECT Table1
SCAN
REPLACE Field1 WITH FieldValue IN Table1
IF SEEK(Field2, "Table2", 2)
IF Table2.Field1 = .T.
INSERT INTO Table3 blah blah blah.....
ENDIF
ENDIF
ENDSCAN
Regards, Hilmar.
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)