BDE TQuery reading a SQL Server VarChar(500)
Posted on 2004-11-22
I previously posted this same question in the wrong section so I apologize if you read this post twice.
I have a Table on SQL Server having a VarChar(500) field. When I query this table using a TQuery component, it only returns the first 255 characters from the 500 char field.
I tried the same thing with TADOQuery object and it worked fine, all 500 char were returned.
I HAVE to use a TQuery object (I cannot switch to a TADOQuery).
Can anyone help me with this ?