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

Click here to load this message in the networking platform