Hi,

I am using the end-user facility to link ReportBuilder with DBISAM V4.  I
have simply copied the ed-user setup all available in th ReportBuilder demo.
It is however falling over on the qryItemUpdate SQL component.  If I try and
open it at dsign time I get the message:

'SQL Parsing Error - expected NULL, Boolean,SmallInt.........BCD expression
but instead found  ? in SELECT SQL statement at line 10,column 16.'

That line says:

where ItemID = :ItemID

This error also displays at runtime.

Any ideas.

Thanks

Alex

Alex,

<< I am using the end-user facility to link ReportBuilder with DBISAM V4.  I
have simply copied the ed-user setup all available in th ReportBuilder demo.
It is however falling over on the qryItemUpdate SQL component.  If I try and
open it at dsign time I get the message:

'SQL Parsing Error - expected NULL, Boolean,SmallInt.........BCD expression
but instead found  ? in SELECT SQL statement at line 10,column 16.'

That line says:

where ItemID = :ItemID

This error also displays at runtime. >>

Is this independent of ReportBuilder ?  IOW, if you put the same query in a
TDBISAMQuery component and try to execute it, do you get the error ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

Yes correct.  ReportBuilder uses a TDBISAMQuery component and if I just try
to open the query it displays that message.  Seeems to be something to do
with the parameter statement.

Alex

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:4ED4E2F1-F94F-4DF8-A362-5860D6971F1F@news.elevatesoft.com...
> Alex,
>
> << I am using the end-user facility to link ReportBuilder with DBISAM V4.
> I have simply copied the ed-user setup all available in th ReportBuilder
> demo. It is however falling over on the qryItemUpdate SQL component.  If I
> try and
> open it at dsign time I get the message:
>
> 'SQL Parsing Error - expected NULL, Boolean,SmallInt.........BCD
> expression but instead found  ? in SELECT SQL statement at line 10,column
> 16.'
>
> That line says:
>
> where ItemID = :ItemID
>
> This error also displays at runtime. >>
>
> Is this independent of ReportBuilder ?  IOW, if you put the same query in
> a TDBISAMQuery component and try to execute it, do you get the error ?
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Thanks, I have worked it out. It was a bad parameter definition.

Alex

"Al Vas" <noreply@noreply.com> wrote in message
news:125A2178-23C8-4BF5-947D-97151991A1DF@news.elevatesoft.com...
> Hi Tim,
>
> Yes correct.  ReportBuilder uses a TDBISAMQuery component and if I just
> try to open the query it displays that message.  Seeems to be something to
> do with the parameter statement.
>
> Alex
>
> "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
> news:4ED4E2F1-F94F-4DF8-A362-5860D6971F1F@news.elevatesoft.com...
>> Alex,
>>
>> << I am using the end-user facility to link ReportBuilder with DBISAM V4.
>> I have simply copied the ed-user setup all available in th ReportBuilder
>> demo. It is however falling over on the qryItemUpdate SQL component.  If
>> I try and
>> open it at dsign time I get the message:
>>
>> 'SQL Parsing Error - expected NULL, Boolean,SmallInt.........BCD
>> expression but instead found  ? in SELECT SQL statement at line 10,column
>> 16.'
>>
>> That line says:
>>
>> where ItemID = :ItemID
>>
>> This error also displays at runtime. >>
>>
>> Is this independent of ReportBuilder ?  IOW, if you put the same query in
>> a TDBISAMQuery component and try to execute it, do you get the error ?
>>
>> --
>> Tim Young
>> Elevate Software
>> www.elevatesoft.com
>>
>