At 11:09 AM 1/02/2008, you wrote:

>> Yes. After the prepare is too late.
>
>Okay--but how to I get a TIB_Cursor to have params & fields before a
>prepare?

TIB_Statement has params (input parameters) and fields (SELECTed fields or output parameters, depending on the type of statement) at design time. If you want the application to recognise what you want to happen with respect to a specific column/parameter unconditionally, e.g. for an ad hoc query that's created at run-time, then define the trimming rule you want in the FieldsTrimming structure of the connection and the statement object will work it out.

Helen