Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP6 & FB: Text BLOB allows adding but not editing
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00941530
Message ID:
00941604
Views:
9
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
___________________________________________
Previous
Reply
Map
View

Click here to load this message in the networking platform