Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OneToMany Relation
Message
From
28/10/1999 06:02:01
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
28/10/1999 04:50:04
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00282854
Message ID:
00282870
Views:
19
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform