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

>4) I tried setting the statement's param's and field's .Trimming to
>ctNone after a prepare and before a .First or .ExecSQL, but this did
>not stop the trimming--I had to go to the connection and set the
>DefaultNoTrimming := True. (Version 4.6a). Am I doing something wrong?

Yes. After the prepare is too late. A dataset's behaviour is conditioned totally by what happens during Prepare.

Helen