Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SELECT-SQL & Appending...?
Message
De
18/04/2002 14:33:34
N. Lea
Nic Cross Enterprises
Valencia, Californie, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
SELECT-SQL & Appending...?
Divers
Thread ID:
00646513
Message ID:
00646513
Vues:
34
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

Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform