Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor Passing
Message
From
30/05/2001 18:38:10
 
 
General information
Forum:
Visual FoxPro
Category:
FoxWeb
Title:
Miscellaneous
Thread ID:
00511502
Message ID:
00512950
Views:
12
>What is the best way to pass or reference a cursor
>from script to script in FoxWeb 2.0? Is there a programmatic
>way to temporarily turn off/on the "Close Tables" that is
>set in the main configuration for the current session?

Bryan,

I'm not familiar with FoxWeb but I can hazard a guess; cursors are "temporary" entities (the analogue is 'temporary table') that "close" when you a) open another file in the work area that you opened the cursor in, b) issue USE in that work space, c) issue CLOSE [ALL | TABLES | DATABASES], d) issue CLEAR [RESOURCES cursor_name | ALL], or e) exit Foxpro. If FoxWeb is acting in a CGI mode (my guess) then impicitly every script will close all tables when it exits (as it should).

My advice would be to use COPY TO [temp_file_name] when the cursor work area is active. The temp_file_name could be a user SessionID or a sys(2015) unique file name. You could then send a cookie to the user's browser containing that table name for reading by the next script and destroy the table after the session is done or expired.

Hope that helps.

-Arne
arne@synercom-edi.com "There are no absolutes but this one."
President, synercom/edi - Event Ticketing Solutions
Previous
Reply
Map
View

Click here to load this message in the networking platform