Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Error "Blob field 'mymemo' not allowed in locate or lookup"
Sun, Oct 11 2009 8:37 AMPermanent Link

"Alessandra"
I got this error with 4.29 using something like:

mytable.locate('mymemo',searchkey,[])

where mymemo in a memo field.

In 3.30 the located worked fine. Is this a (undocumented?) change from v3 to
v4 ?
Is there any workaround? Thanks.
Sun, Oct 11 2009 9:54 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Alessandra,

<< I got this error with 4.29 using something like:

mytable.locate('mymemo',searchkey,[])

where mymemo in a memo field.

In 3.30 the located worked fine. Is this a (undocumented?) change from v3
to v4 ? >>

Yes, you can't locate on memo fields.  If it worked in 3.x, it was
completely by accident.

If you want to search on a memo field, use a filter instead.

--
Tim Young
Elevate Software
www.elevatesoft.com

Sun, Oct 11 2009 10:40 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Alessandra

I never used that in any version of DBISAM, and didn't know it was ever allowed.


You could probably use a filter or sql to get the record key and then use that to reposition the counter.

Roy Lambert [Team Elevate]
Mon, Oct 12 2009 3:37 AMPermanent Link

"Alessandra"
Thanks Tim & Roy for your kind answers!
Image