Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary Keys from MS Access
Message
 
To
22/05/2013 06:22:24
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Jet/Access Engine
Application:
Desktop
Miscellaneous
Thread ID:
01574288
Message ID:
01574455
Views:
45
Ah ... sorry no.... whjat that does is return the autonumbered primary key when you execute it just after an insert


>Will this really return list of primary key fields of a table?
>
>>
>>You can try
>>
>>select @@identity
>>
>>
>>You should get the Autonumber field of the record you just inserted.
>>
>>It works for me in Vb.net using ado.net. I connect via oledb, not sure how relevant that is.

If things have the tendency to go your way, do not worry. It won't last. Jules Renard.
Previous
Reply
Map
View

Click here to load this message in the networking platform