Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Getting slower!
Message
De
31/07/2001 11:55:27
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
31/07/2001 11:48:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00537775
Message ID:
00537791
Vues:
17
>....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)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform