Subject | Re: [IBO] Set parameter for Stored Procedure |
---|---|
Author | Florian Hector |
Post date | 2003-09-08T19:57:21Z |
> Can you represent it as a logical True/False or Yes/No? If so, just use aThe problem I have is not so much retrieving the value within the program
> 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.
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