Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT-SQL & Appending...?
Message
From
18/04/2002 14:43:13
 
 
To
18/04/2002 14:33:34
N. Lea
Nic Cross Enterprises
Valencia, California, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00646513
Message ID:
00646522
Views:
12
USE DBF(mysqlcursor) AGAIN ALIAS updateable IN 0
>I was wondering if anyone would be able to help me out with my coding problem. I have created a SELECT-SQL statement and placed it into a cursor. Now I am trying to get that data moved into a temp file so that the user will have the ability to edit the table. Since Fox 6 cannot allow the cursor to be editable, I could see no other way. An array would eventually blow "not enough memory" error. I tried to have it inputed into the table directly, but it would overwrite the structure. Moving it from a cursor to a table is my only thought. Any suggetions or hints? Thanks!!
>
>

>*-- DUPLICATE ALL DATA INTO A SQL-STATEMENT FOR TRANSFER --*
>SELECT a.inv_no,a.part_code,a.part_desc,b.mold_code,b.mat_code,a.part_qty,a.part_cost ;
> FROM order_items a, part_file b ;
> WHERE a.inv_no = cInvoiceNumber AND a.part_code=b.part_code ;
> INTO CURSOR MySqlCursor
>
>SELECT MySqlCursor
>BROWSE
>
>SELECT schedule_temp
>
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform