Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update conflict from combo in grid, grid's valid
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Update conflict from combo in grid, grid's valid
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01286684
Message ID:
01286684
Views:
95
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
Map
View

Click here to load this message in the networking platform