Hi

I've had problems before with unwanted data trimming by the IB_Query and this was fixed by the FieldsTrimming property
( I still think the default should NOT trimmed ;-))

I now am discovering problems with IB_Cursor.

'Insert into mytable values(1,' ')' will store an empty string in the second field

'Insert into mytable values(1,:text)'
parambyname('text').AsString=' ' and
FieldTrimming of TEXT=FALSE will store correctly

Then reading the data using a select statement always seems to right trim the result regardless of FieldsTrimming

There seems to be an undue bias towards trimming and there appears to be a bug in IB_Cursor with regards to the FieldsTrimming property.

Regards
Paul


[Non-text portions of this message have been removed]