Subject Re: [IBO] Set parameter for Stored Procedure
Author Helen Borrie
At 02:24 PM 8/09/2003 +0200, you wrote:
>I have an IBO_Query which spans over a few tables, for inserting, editing
>and deleting records I wrote some stored procedures.
>Using the function Generate for procedure of IBO_Query, I can easily assign
>the different parameters from the various tables.
>So far OK, but now I have one parameter which has no reference to any field
>of any table, the user has to make the choice between 0 and 1.
>
>How can I make this value known to the query/SP.

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.

Helen