Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The horse before the cart (SCAN problem)
Message
 
To
11/10/2006 12:42:39
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:
01161274
Views:
26
This message has been marked as the solution to the initial question of the thread.
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
Next
Reply
Map
View

Click here to load this message in the networking platform