Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CursorAdapter quesiton
Message
De
16/08/2008 10:17:37
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01339047
Message ID:
01339281
Vues:
9
This message has been marked as a message which has helped to the initial question of the thread.
>Hi everybody,
>
>I've just spoken with my former colleague.
>
>Here is a problem. The business object can autogenerate an ID field. With the local view this autogenerated value then saved into the database.
>
>With the CursorAdapter the autogenerated key seems to be ignored and the different key is put into the database when the record is saved.
>
>I'm thinking that there has to be the native property of the CA that is responsible for generating ID (or taking them from the cursor).
>
>Do you know what the name of the property is if this property exists? We're using GUID for our PKs.
>
>Thanks a lot in advance.

Naomi,
I insert generated key into CA cursor and have key field as updatable. ie:

insert into myCA (myPK) values (newguid())
* do whatever with other fields
tableupdate(,,,)

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform