General information
Title:
Update conflict from combo in grid, grid's valid
I have a ProcessSpeed view of: id, sizeid, processid, slowspeed, fastspeed all integers.
This is recordsource, type 1 (alias) to a grid of three columns, size, slow, fast.
The size column has a combobox populated by a SELECT of size.description and size.id from a Size view.
The Controlsource of the cbo is the ProcessSpeed.sizeid integer, boundto=.t., boundcolumn=2 of my cbo. sparse=.f.
Run the form, existing values in the view show the lookup of size description, and the slow and fast speeds fine.
eg: 8 1/2 x 11 [v] 100 200 Where [v] is dropdown combo
I want to add a record to the ProcessSpeed updatable view.
I insert a row in the grid, select a size from the dropdown, enter speeds.
All appears OK.
Now, when I leave the grid in any fashion, and grid valid() fires and I get an error complaining of:
"Update conflict in cursor 'VISIBLE'", or "Update conflict in cursor'GLCALCULATORON'" or even "Update conflict in cursor ', '", of course there are no such cursors.
Stepping the valid(), these errors occur when I execute any record pointer movement on the view, eg: GO TOP, RECNO and so on.
I then have to go to the task manager and stop the session.
Does anyone have any suggestions on the problem or its source?
Thanks
Al Allison
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