Re: adCriteriaAllCols and text columns

From: John Faris (johnfaris_at_nospam.hotmail.com)
Date: 04/21/04 

Date: Wed, 21 Apr 2004 10:40:13 +0100

"Vitali Kalinin" <vitkalinin@yahoo.com> wrote in message
news:40851a46@newsgroups.borland.com...
> The text, ntext, and image data types cannot be compared or sorted, except
> when using IS NULL or LIKE operator (assuming that we are talking about MS
> SQL). To address this problem you can add TIMESTAMP column into table.
>
>

Hi Vitali.

That seems to solve the problem. However, I have a couple of questions that
maybe you can answer. I added a TIMESTAMP column to one of my tables and
when I went to save the change in SQL Enterprise Manager it prompted me that
it was going to save several other tables too. Any idea why? Secondly,
after I added the column I tried to use the Delphi Fields Editor to add the
colum to a TQuery and it complained that columns of type TEXT or IMAGE
cannot be compared against unless LIKE is used (or something very similar).
This was weird as the query in question had one parameter which was of type
string. I changed the query so that it used LIKE instead of equals and I
was then able to add the column using the fields editor. The even more
bizarre thing is that I was then able to set the query so that it used
equals not LIKE as it was before and it worked fine, including the fields
editor. Is this normal?

Thanks.

John.