Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting slower!
Message
From
31/07/2001 11:55:27
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
31/07/2001 11:48:13
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00537775
Message ID:
00537791
Views:
16
>....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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform