Graham Vickrage wrote:
>
> I have tracked down the problem (but not the solution), it
> would appear that the data type 'text' is causing the problems.
> If a column of type text is included in the query then only one
> row is returned, else all rows are.
>
> Why is this, is it the ODBC driver or NT Server 4 or something else?
How are you setting *Text As LongVarChar* option ?
And how big the actual size of the text field ?
regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/