Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
OneToMany Relation
Message
De
28/10/1999 06:02:01
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
28/10/1999 04:50:04
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00282854
Message ID:
00282870
Vues:
17
>I have set the a Relation property of "OneToMany" to .T.
>in order to print a Header & Detail report in the
>Report's dataenviornment.
>
>After the report has printed and it goes back to the main
>application, which has 2 grids that display Header and
>Details, the Header Grid got hay-wire with a few lines
>of record displaying ******* in the fields.
>
>But if I set the "OneToMany" Relation to .F., then there
>isn't any problem. But the Report would only print one
>line of the Detail record. Any suggestions? Thanks.


Alvin,
OneToMany property correspond to "set skip" command. It's readonly at runtime but "set skip" is not. You could have OneToMany in its default (.f.) and before report you could set skip to (cAliaslist) and "set skip to" when you're done.
OTOH I suggest doing reports with cursors. When you select the data you need into a cursor before the report you wouldn't worry about relations at all.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform