Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursor Passing
Message
De
30/05/2001 18:38:10
 
 
À
25/05/2001 10:20:32
Information générale
Forum:
Visual FoxPro
Catégorie:
FoxWeb
Titre:
Divers
Thread ID:
00511502
Message ID:
00512950
Vues:
13
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform