General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>This problem seems to be re-occuring with some regularity with different people. I am having a very similar problem with a remote view still. If I take the trigger off from the table on the back end that is being inserted into all of the records append fine, but with the trigger on, a small percentage of the records seem to disappear during the tableupdate. The view has all of the records, but the back end table doesn't get them all. No errors are returned either.
>
>This may just be that a number of us are doing the same stupid thing wrong, or maybe there is a real issue with VFP.
Is it related to a datetime data type or index? I've got the same problem. Updatable view with 2 key fields one numeric one datetime. For 80-90% of the data sets, the update goes through without a hitch. For the rest, 1 or 2 out of 10 records get the update.
I can duplicate it from the command window. The view works because 80% of the time it goes through. When it doesn't no error message is returned. With set deleted off, displaying and editing the view, when I issue table update, the failing records get the delete mark?!?
BTW I'm working in VFP5.0a
Changing the seconds to 00 in the datetime record usually makes it so the update goes through. I don't know if the index is fragmented and this puts the updated block back together or what.
TIA, Glad to know it's not just me losing my mind ;-)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only