Spot on Helen,

I had two swopped around. By the way, I have got my
multi-join-edit-in-a-grid working, I could, if Jason(and the Team) are
interested, make my app(or part thereof) available as an example for any
newbies struggling with this.

Many thanks,
Dion.


-----Original Message-----
From: Helen Borrie (TeamIBO) [mailto:helebor@...]
Sent: Saturday, February 02, 2002 5:00 AM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] conversion error from string "2002-02-14".


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.


regards,
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
www.ibobjects.com



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.314 / Virus Database: 175 - Release Date: 01/11/2002

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.314 / Virus Database: 175 - Release Date: 01/11/2002