Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The horse before the cart (SCAN problem)
Message
From
13/10/2006 05:54:07
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01161244
Message ID:
01161668
Views:
18
Thanks Jim! You took what I thought was a complex issue and made it seem embarassingly simple. It took some time, but I was finally able to implement the logic and it works well.

>
>Cursor: crsDisclaimers
>
>DisclaimerID     DisclaimerText
>
>
>Cursor: crsFunds
>
>FundTypeID     FundName     FundID     DisclaimerID
>
>
>SELECT crsFunds (ORDERed by FundTypeID)
>SCAN
>   lcFundTypeID = FundTypeID
>   * Make the results do this:
>	
>   Top Disclaimer (SQL from crsDisclaimers for the FundType)
>
>   SCAN REST WHILE FundTypeID = lcFundTypeID
>      DISPLAY individual fund records for the FundTypeID
>   ENDSCAN
>   SKIP -1
>
>   Bottom Disclaimer (SQL from crsDisclaimers for the FundType) *
>   Footnotes (SQL from crsDisclaimers for the FundType)
>
>ENDSCAN
>
Previous
Reply
Map
View

Click here to load this message in the networking platform