| Subject | Re: [ib-support] Works in IBConsole but not IBX?? |
|---|---|
| Author | Doug Chamberlin |
| Post date | 2001-09-30T19:11:54Z |
At 9/30/2001 02:45 PM (Sunday), Wayne wrote:
you. However, if you want a work around, there is nothing wrong with coding
the above two lines as
ViewQry.SQL.Add(
Format('where shift_date >
''%s''',[FormatDateTime('mm/dd/yyyy',StartDate - 10)]));
This eliminates the used of parameters in the query. It should work if the
problem lies in how the param is being handled by IBX.
>[snipped code example] includingI have never used IBX so I cannot help figuring out how it is failing for
>>
>> ViewQry.SQL.Add('where shift_date > :HisDate');
>> ViewQry.ParamByName('HisDate').AsDate := StartDate - 10;
>In IBConsole it works Fine, but in IBX I get the following error
>message...
you. However, if you want a work around, there is nothing wrong with coding
the above two lines as
ViewQry.SQL.Add(
Format('where shift_date >
''%s''',[FormatDateTime('mm/dd/yyyy',StartDate - 10)]));
This eliminates the used of parameters in the query. It should work if the
problem lies in how the param is being handled by IBX.