Subject RE: [IBO] conversion error from string "2002-02-14".
Author Helen Borrie (TeamIBO)
At 01:47 PM 02-02-02 -0800, you wrote:
>Hi Helen,
>Wil do. But before I do, maybe a misunderstanding of IBO on my part could
>solve the problem.
>>3. The Delphi code where you assign values to the parameters for the
>stored procedure, e.g. >your BeforeInsert BeforePost code.
>I dont do this. I thought the params are automatically assigned their values
>through the InsertSQL property(automatically bound).

If everything matches exactly (input parameter names match column names, data types match, etc.) then they will bind automatically. Somewhere in the equation, there's a dataype that won't bind, so I don't think you are going to get this working properly until you get all of these ducks lined up. So far you have given us no clue as where the error is being thrown. Maybe the answer will be found in the secret code of your stored procedure - one input parameter out of sequence, maybe...have you double- and triple-checked this?

If you don't have any Delphi code related to the parameter binding, then don't try to send it. :)) It's just a duck to line up, if it's there.

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