odbc & char-fields

[Maurice]

Hello,

When making a query through odbc the char-fields only display the amount of char that fits the DB-format.
So if the field is defined as "X(30)" the odbc-query shows 30 chars max, in spite of the fact that there are more characters stored in the field.
Is there a solution (except making the format in de db bigger)?

Maurice
mstassen@datamex.nl

 

[phirst]

Hi,
If you are using v9 there is a new field "SQL-WIDTH" which defines the size of the field in SQL-92, it is usually defined twice as big as the normal format.
If not, you will have to increase the FORMAT, this does not change the CRC of the table, so you will not have to recompile, though it could mess your screens up when you do.
Perhaps someone else knows of a workaround?
Cheers,
Paul.