Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What's moving my Recno() ?
Message
De
05/01/1998 19:45:07
 
 
À
05/01/1998 19:13:28
Nancy Folsom
Pixel Dust Industries
Washington, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00069341
Message ID:
00069694
Vues:
48
I don't really understand how set skip works, I only know that that's what I need to get what I want.
Example: I have 3 tables. (1)clients (2)addresses (3)e-mail addresses
(Lot of snow birds that have a different address during winter, and also 2 e-mail addresses, but they are
obviously independant of the physical addresses).

What I want to have in my grid is:
Doe, John               Address 1               e-mail 1
**************** **************************     e-mail 2
****************        Address 2               e-mail 1
**************** **************************     e-mail 2

                    or

Doe, John               Address 1               e-mail 1
****************        Address 2           *****************
****************        Address 1               e-mail 2
****************        Address 2           *****************
depending on which order is set (which the user sets by moving the cursor into the appropriate column).

If I only set skip from table1 to table2 and from table2 to table3
instead of from table1 to table2 & table3 and also from from table2 to table 3 I get:
Doe, John               Address 1               e-mail 1
****************        Address 2               e-mail 1
This is all with relation set from table1 into table2 and from table2 into table3
If I set relations from table1 into table2 & table3 (and set skip into both) I get:
Doe, John               Address 1               e-mail 1
****************        Address 2               e-mail 2
Bill




>This is probably totally completely silly, off the mark, blah blah blah, but, ahem. Why do you set skip to table3 from table 2 AND from clients?
>
>...snip
>>The only thing I can even imagine might have something to do with it is the relations:
>>(I'm leaving out all the normal syntax, just to show you the relations)
>>
>>select table2
>>set relation into table3
>>set skip to table3
>>
>>select clients
>>set relation into table2
>>set skip to table2, table3
>>
Bill Morris
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform