Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP6 & FB: Text BLOB allows adding but not editing
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00941530
Message ID:
00941604
Vues:
8
Hi

>General field is define on FB as "blob sub_type 0"

I have changed it to Memo in the RV to use it with editbox, but then making it back to General in RV makes the form unusable as maybe the editbox can't be used with General fields.

>CompareMemo=.F.

Comfirmed .F.

>[ ] Inlcude Memo fields in Where clause

I can't find this, I have seen it somewhere but can't find it right now.

The SQL is simple as below

SELECT *;
FROM MCUSTOMSOFFICE Mcustomsoffice;
ORDER BY Mcustomsoffice.CNAME

One more thing I just tried the following
	*** EGL: 2002.2.14 13:36 -  Exclude General fields from checking
	IF TYPE(lcFld) == "G"
		LOOP
	ENDIF
	
IF TYPE(lcFld) == "M"
	LOOP
ENDIF
	IF NOT (OLDVAL(lcFld) == CURVAL(lcFld))
		lnRetVal = ERROR_UPDATE_CONFLICT
		EXIT
	ENDIF
and it starts working, though I can't keep this logic permanently got to find out a workaround.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform