Subject RE: [IBO] conversion error from string "2002-02-14".
Author Helen Borrie (TeamIBO)
At 09:35 AM 02-02-02 -0800, you wrote:
>Hi Helen,
>What is the most economical way of getting some small screenshops to you. I
>have cut and pasted 3 small images into the message, but the size jumps to
>889k. Should I send it?

No thanks. What's needed are the following:

1. The source DDL for the stored procedure that isn't working.
2. The DDL source for the table that is being inserted to.
3. The Delphi code where you assign values to the parameters for the stored procedure, e.g. your BeforeInsert BeforePost code.
4. The output from the SQL monitor, starting at where you initiate an insert (clear the output window of the monitor just before you click the Insert button).
5. The SQL for the dataset.
6. The SQL for the InsertSQL property.

Please gather these pieces into one text file, adding comments to indicate the classes of the components. If it's compact enough, post it to the list as a message. If not, upload it to the Files area ( with a title on it like "Dion's Date Conversion Problem".

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at