Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cannot update the cursor
Message
De
08/10/2008 05:46:22
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Cannot update the cursor
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01353585
Message ID:
01353585
Vues:
60
Hi Guys

A customer has a few times now got the system error handler message "ERROR: (111) Cannot update the cursor CPX_PRODUCTS, since it is read-only." on the following replace command:
IF TYPE("cPX_PRODUCTS.Reference") = "C"
	REPLACE cPX_PRODUCTS.REFERENCE WITH ALIAS.REFERENCE
ENDIF
Now this cursor is ALWAYS created ReadWrite, and, unfortunately, in several places, in several sets of circumstances and slightly differently, in the form code, typically
SELECT cPX_PRODUCTS.*,;
	IIF(!EMPTY(cPX_PRODUCTS.CatID),cPX_PRODUCTS.CatSellPrice,0000000000.0000) as SellPrice, ;
	!EMPTY(cPX_PRODUCTS.CatID)as SellCalculated,;
	IIF(EMPTY(cPX_PRODUCTS.CatID),ThisFOrmset.SellingPriceLstInclusive,cPX_PRODUCTS.CatInclusive) as SellInclusive ;
	FROM cPX_PRODUCTS ;
	INTO CURSOR cPX_PRODUCTS READWRITE
and I can't be sure without exhaustive tracking which is used in these cases, as it's hard to predict exactly what the cust did just prior to this error.

The cust has confirmed that there is plenty of disk space.

Not my code, of course. I've rarely come across the replace construct:
Replace TableName.FieldName with ...
as used above (and frequently throughout the system).

Note also that cPX_PRODUCTS is selected from to produce the cursor cPX_PRODUCTS

Any ideas why this may happen?

'ppreciate it

Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform