Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update conflict from combo in grid, grid's valid
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
Update conflict from combo in grid, grid's valid
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
01286684
Message ID:
01286684
Vues:
96
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform