Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CursorAdapter question
Message
 
À
08/10/2008 09:08:10
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01353620
Message ID:
01353621
Vues:
20
>I am attempting to use CursorAdapters to move the backend of an application to Postgres. Question: I want to get a blank record, populate it and then save it. What is the syntax for starting with a blank record?

Put in selectCmd:
SELECT ..... FROM ..... WHERE 1=0
that way you will have an empty cursor. Then just INSERT INTO .... VALUES () and TABLUPDATE().
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform