Subject Re: [IBO] Set parameter for Stored Procedure
Author Florian Hector
> Can you represent it as a logical True/False or Yes/No? If so, just use a
> regular TCheckBox, with a suitable caption, e.g. 'Gift-wrapping
> required'. Then, when applying values to parameters, read the Checked
> property and apply 0 or 1 accordingly.

The problem I have is not so much retrieving the value within the program
but to pass it to the Query/SP.

Right now the EditSQL of the query looks like this:
EXECUTE PROCEDURE KOMMUNIKATIONAENDERN(
:ChangeAll, <------------ NOT from a
table
:TABKOMMUNIKATION.KOMMID,
:TABKOMMUNIKATION.KOMARTID,
:TABKOMMUNIKATION.KOMMDETAIL,
:TABKOMMUNIKATION.KOMMREMARK,
:TABPERSONEN.PERSID)

When it comes to retrieving data with this query it get the error:
Invalid custom DML column reference: ChangeAll
Even when I hardwire it to a value, it does not seem to have an effect. When
I check the statement sent to the server using the monitor, all params but
the first one are assigned, the first one is not even listed.

I have the feeling tha t I miss something fundamental here.

Florian