Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Adding a new record to a cursor from SQL staetment
Message
De
10/02/2016 17:00:28
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
10/02/2016 16:45:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 7
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01631205
Message ID:
01631206
Vues:
65
>I need to know how to add a record to a cursor created by a SQL Select statement:
>
>SELECT add1, recno() from cust WHERE custno=mcustno INTO CURSOR TempStore
>
>What I am trying to do is add a record saying 'Add another Property' at the bottom of a list of properties, so if they click on that in a list/grid, it can be the trigger to append a blank for a new property in the real data file...
>
>Any suggestions? I have tried to append blank in the cursor, but it doesn't like it...
>
>Thanks!
SELECT add1, recno() from cust WHERE custno=mcustno INTO CURSOR TempStore READWRITE
proceed with APPEND or INSERT as on any other cursor.

Update:
That was close. I missed the VFP 7 - but then READWRITE was introduced on VFP7
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform