Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT-SQL & Appending...?
Message
From
18/04/2002 14:33:34
N. Lea
Nic Cross Enterprises
Valencia, California, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SELECT-SQL & Appending...?
Miscellaneous
Thread ID:
00646513
Message ID:
00646513
Views:
33
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

Next
Reply
Map
View

Click here to load this message in the networking platform