Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grid Problem Again~
Message
De
15/12/1999 00:12:48
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00303844
Message ID:
00303896
Vues:
18
cause my eng. is not so good, so i think i should provide more detail info about my problem:
i hv two tables: "sohead.dbf" and "sodetail.dbf" and both of the table hv the same field "so_no", it is a one-to-many relationship, that one record inside sohead, will find a number of records inside "sodetail" with the common field "so_no". Then inside the DE of the form that contain the grid, i hv add two table, one is "sohead", and the other is "sodetail"

* inside form.init
With Thisform.GRID
.recordsourcetype = 4
.recordsource = "SELECT SODETAIL.SO_NO FROM SODETAIL WHERE SODETAIL.SO_NO = SONO INTO CURSOR RESULT
.REFRESH()
EndWith

i'm sorry that i hvn't provide detail info. , hope u can hlp my problem ~
THX

p.s. sorry i don't understand how to use parameterized view, can u more specify.
thx again, i think i cause u inconvience, sorry......
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform