Subject Re: [IBO] TIBOQuery Invalid custom DML column referenced
Author Helen Borrie
At 09:23 PM 23/01/2004 +0000, you wrote:
>I was successfully able to retrieve a dataset using TIBOQuery. Since, I have
>expanded to allow INSERTs to be done on a table.
>The following sql was added to the InsertSQL property
>execute procedure SP_INSERT_PROJECT(:wwwCON_ID, :wwwDESC_TEXT)
>I have defined 2 parameters, wwwCON_ID and wwwDESC_TEXT.
>The 1st parameter I use in both the SQL and InsertSQL query.
>The 2nd parameter I only use for the insert.
>In TIBOQuery BeforeOpen I am setting the param value for wwwCONID.
>For some reason I am getting the error
>Invalid custom DML column referenced: WWWCON_ID

You need to set it in the BeforeInsert. Use BeforeOpen for SELECT params
(in this case, for the input params for your SELECT procedure).

If WWWCON_ID is generated, then use GeneratorLinks for it and don't assign
it yourself. OTOH, if your SP is actually setting it then it should not be
an input param of the exec SP.

Best you show the ddl for the insert procedure...