Subject | Re: [IBO] Checking Parameters Value |
---|---|
Author | Svein Erling Tysvær |
Post date | 2001-03-29T13:45:38Z |
Yagi,
I get the opposite results of you (albeit trying on an IB_Cursor, not
IB_Query) - it is always false. To me it seems like a preparing sets the
parameter to an empty string (for strings, I didn't check other types),
i.e. check for if(ibqRaport->Params[i]->AsString = '') (no responsibility
for correct C syntax accepted).
Set
At 15:22 29.03.2001 +0200, you wrote:
I get the opposite results of you (albeit trying on an IB_Cursor, not
IB_Query) - it is always false. To me it seems like a preparing sets the
parameter to an empty string (for strings, I didn't check other types),
i.e. check for if(ibqRaport->Params[i]->AsString = '') (no responsibility
for correct C syntax accepted).
Set
At 15:22 29.03.2001 +0200, you wrote:
>Hi,
>
>How to check if Params for Query have values?
>
>I did something like this
>
> for(int i = 0; i < ibqRaport->Params->ColumnCount; i++)
> {
> if(ibqRaport->Params->Columns[i]->IsNull)
> {
> Application->MessageBox(AnsiString("Give me value of param " +
> ibqRaport->Params->Columns[i]->FieldName + ".").c_str(),
> Application->Title.c_str(), MB_OK | MB_ICONEXCLAMATION);
> Abort();
> }
> }
>
>but ibqRaport->Params->Columns[i]->IsNull is always true.
>(Query is prepared).
>
>What's wrong with this?
>
>Regards
>
>Yagi