Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replace cursor
Message
From
05/02/2003 08:58:08
Gerry Schmitz
GHS Automation Inc.
Calgary, Alberta, Canada
 
 
To
05/02/2003 05:19:34
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00748127
Message ID:
00749318
Views:
24
In that case, you should run AUSED() twice, with 2 different arrays; Once AFTER all tables are opened, but BEFORE opening any cursors; then AFTER opening all cursors.

Now you have 2 arrays: 1 containing only "tables"; the other containing "tables" and "cursors".

Any entry in the second array that is not in the first array is a "cursor".

>I will explain:
>For example, if you ave table name 'Prodact'.
>When you ran the following command you will get a cursor name prodactS.
>
select * from prodact where item in ('BOX','CAR') into cursor prodactS nofilter
>In the init of the form the prodact table availiable and the prodactS cursor not created yet.
>On that point you can create cursor with all the tables (ONLY) by using with the array Adir.
>In the first time that you will press on the command button I dont have any cursor yet (only the cursor with the tables) and I don have any problem..
>My problem is when I press again on the command button, on this point I have 25 cursors and when the tryng to save data in cursor who existed I get messagebox that the cursor in use (Not in all the cursors, I dont know why).
>So I want to create cursor in the first line of the command buttom that will collect all the cursors\tables that wasnt in the fist array (adir, you remember?) and by 'scan' command I will make 'Use in' - only to this line.
>Thank you for answer.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform