Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get ODBC fields in a report
Message
 
To
13/01/2005 08:11:07
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Miscellaneous
Thread ID:
00976680
Message ID:
00976721
Views:
9
This message has been marked as the solution to the initial question of the thread.
>>But why IN report? You said You have no DataEnvironment & no Private DataSession for report. Just add it before REPORT FORM...
>
>I'm sorry, I didn't explain very well, but for certains reasons, I need that the cursor get created and destroyed in the report.
>In the main code I only have REPORT FORM... with no table or cursor opened.
>So I need a DataEnvironment ?
>
>Thanks Borislav.

I just test it with VFP 9 beta.
View DataEnvironment in report. Select Properties
In Init event of the DE put SQLCOLUMNS(....)
In Destroy event of the DE put USE IN ...

***** UPDATE

But If Your sqlhandler (connection with SQL Server is broken) is invalid during the initialization of report I don't know what to do :o)))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform