Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Seek function LIES!
Message
From
16/12/2003 13:43:05
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
16/12/2003 12:04:28
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00859505
Message ID:
00859586
Views:
19
>I agree that table buffering should be used, but indexseek will not by itself prevent duplicates. There is still a (small) chance that 2 users enter the same data at the same time.
>
>>With making it a primary key you might let VFP raise the error but still beware you might find yourself trapped.
>
>How?

Sylvain,
Saying trapping I meant in the sense of code I saw. seek() trying to move the pointer causing an implicit tableupdate attempt.
I tend to get values and do an unbuffered insert with error check.
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
Previous
Reply
Map
View

Click here to load this message in the networking platform