Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Duplicate primary key values in table
Message
From
05/03/2002 18:24:15
 
 
To
05/03/2002 18:15:13
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00628704
Message ID:
00628773
Views:
25
>Any changes in the network? Server? Client stations? Network drivers?

I'm sure there may have been at least some changes like that, but nothing jumps out at me that would coincide with this problem... The servers haven't changed. They may have upgraded their NT version, some client stations may have been swapped upgraded at some point in time. Is there something in particular I should look for with regard to a specific workstation? I DO know that the rows in question were created by different users at different workstations.

If only I could find a way to cause this problem at will. I could then see how my auditting reacts to this. I'm not sure if this is happening upon insert of the records, or if the index/table is getting updated later on. If I could duplicate this problem and check my auditting files, that'd be a big clue. I'm guessing that it has something to do with buffered writable views. (all my forms insert/update/delete rows from updatable views, some row buffered, others table buffered.) This view is most likely row buffered. I also use TRANSACTION processing, so that has to be thrown into the equation too...umph....
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform