Home > Archive > Clarion > July 2006 > Searching a memo field
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Searching a memo field
|
|
| C.Joseph Drayton 2006-07-06, 6:55 pm |
| Hi All,
I have a table that has a memo field in it. I want to be able to
scan the memo field for a partial string match.
In other words, I want to be able to do what can be done with the
instring command for strings and cstrings with a memo field.
Right now, I am converting the memo field to a cstring then doing
the search. I would like a faster way to do it.
Thanks,
C.Joseph
| |
| Earl R Coker 2006-07-06, 6:55 pm |
| HI C,Joseph,
Have a look at the BoTpl Free templates here...
http://www.comsoft7.com/Products.htm I'm pretty sure the BrowseSearch
control template will do what you want.
--
Best Regards,
Earl R Coker
ksasales AT machlink DOT com
earl AT kwiksystems DOT net
www.kwiksystems.net
www.kwiksystems.com
www.kwiksystems.net/appshell/index.htm
www.kwiksystems.com/clarion.htm (BigTamer(tm) Templates)
"C.Joseph Drayton" <csdcs@tlerma.com> wrote in message
news:44ad365b$0$15791$14726298@news.sunsite.dk...
> Hi All,
>
> I have a table that has a memo field in it. I want to be able to
> scan the memo field for a partial string match.
>
> In other words, I want to be able to do what can be done with the
> instring command for strings and cstrings with a memo field.
>
> Right now, I am converting the memo field to a cstring then doing
> the search. I would like a faster way to do it.
>
> Thanks,
> C.Joseph
| |
| C.Joseph Drayton 2006-07-06, 6:55 pm |
| Earl R Coker wrote:
> HI C,Joseph,
>
> Have a look at the BoTpl Free templates here...
> http://www.comsoft7.com/Products.htm I'm pretty sure the BrowseSearch
> control template will do what you want.
>
Hi Earl,
According to the HLP file, it is doing exactly what I am doing
except it is changing the whole record to a string rather than just
the memo.
Any other ideas welcome.
Sincerely,
C.Joseph
| |
| Robert Peros 2006-07-07, 3:55 am |
| "C.Joseph Drayton" <csdcs@tlerma.com> wrote in message
> I have a table that has a memo field in it. I want to be able to
> scan the memo field for a partial string match.
> In other words, I want to be able to do what can be done with the
> instring command for strings and cstrings with a memo field.
> Right now, I am converting the memo field to a cstring then doing
> the search. I would like a faster way to do it.
You don't need convert memo(if not have binary attribute)
Search direct through memo field or string reference.
R.
| |
| sandinzz@yahoo.com 2006-07-07, 7:55 am |
| If you want to display records which contains "search string" (?) - use
QBEList filter. Sandin
|
|
|
|
|