Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SCAN Problem
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00461246
Message ID:
00461267
Vues:
18
First, thanks (No alltrim! DUH!) But even though I removed the ALLTRIM()'s, I'm still getting all records in the child table.

Second, I'm using IDX's cause legacy code is looking for IDX files.
Bummer, but for now it'll work.

Third, I have a typical one to many, and all fields from table1 and
table2 need to become a record in table3. So the second SCAN scatters
each record to a memvar:


SELECT Table1
SCAN

   ** Get's all of the first table's fields on the current record
   SCATTER MEMVAR

   ** Now loop through all child records and scatter each value to
   ** memvars

   SELECT Table2
   SCAN
     SCATTER MEMVAR
   ENDSCAN

ENDSCAN

** Table3 has only matching fields from tables 1 & 2 that I want
INSERT INTO Table3 FROM MEMVAR


See?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform