Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Seeking a brilliant idea to replace NextID() function
Message
From
22/01/2008 01:40:09
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
21/01/2008 12:04:58
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01283680
Message ID:
01283910
Views:
21
>>>>Check Message #1111814
>>>
>>>I checked, probably brain dead now, can't see how it helps to know the key before inserting a new record.
>>>Cetin
>>
>>I'm thinking there is no way to achieve your goal. You need to insert a record in order to get the ID. You can not get the ID without inserting.
>
>Why? I can do that with native tables and using a GUID as a key. There should be a way with int too, just not found yet:)

Convert your GUID into 4 or 8 integers ;).

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform