| View previous topic :: View next topic |
| Author |
Message |
Fernando D'Império
Guest
|
 Posted: Tue Aug 12, 2003 6:25 am Post subject: indexing memo filed |
 |
|
How shoul I index content of a memo field ?
Thanks for any help.
Fernando
|
|
| Back to top |
|
 |
Viatcheslav V. Vassiliev
Guest
|
| Posted: Tue Aug 12, 2003 9:01 am Post subject: Re: indexing memo filed |
|
|
Most DBMS do not support indexing BLOB columns including MEMO columns.
----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.
"Fernando D'Império" <fdimperio (AT) rogers (DOT) com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:3f388852 (AT) newsgroups (DOT) borland.com...
| Quote: | How shoul I index content of a memo field ?
Thanks for any help.
Fernando
|
|
|
| Back to top |
|
|
Craig Stuntz [TeamB]
Guest
|
| Posted: Tue Aug 12, 2003 1:31 pm Post subject: Re: indexing memo filed |
|
|
Viatcheslav V. Vassiliev wrote:
| Quote: | Most DBMS do not support indexing BLOB columns including MEMO columns.
|
You can use a full text / word list technique if you need to do this.
There are off-the-shelf products which do this, or you can write your
own. It's hard to give specific advice without knowing more about the
person's needs, however.
-Craig
--
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Performance Monitor -- Analyze and control your IB7
server: http://delphi.weblogs.com/IBPerformanceMonitor
|
|
| Back to top |
|
|
Fernando D'Imperio
Guest
|
| Posted: Tue Aug 12, 2003 7:27 pm Post subject: Re: indexing memo filed |
|
|
My memo field is used to give free space to users make their comments about
products avaiable in my store.
I need something to classify them.
I should say that i am upgrading the software so I have thousands of those
comments and I need to keep them, I can not replace them with specific
forms.
Thanks
"Craig Stuntz [TeamB]" <cstuntz (AT) vertexsoftware (DOT) com> escreveu na mensagem
news:3f38ec1f$1 (AT) newsgroups (DOT) borland.com...
| Quote: | Viatcheslav V. Vassiliev wrote:
Most DBMS do not support indexing BLOB columns including MEMO columns.
You can use a full text / word list technique if you need to do this.
There are off-the-shelf products which do this, or you can write your
own. It's hard to give specific advice without knowing more about the
person's needs, however.
-Craig
--
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Performance Monitor -- Analyze and control your IB7
server: http://delphi.weblogs.com/IBPerformanceMonitor
|
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
