Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
ReportBuilder DBISAM 4 Integration |
Mon, Dec 15 2008 8:42 AM | Permanent Link |
"Al Vas" | 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 |
Mon, Dec 15 2008 10:12 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Mon, Dec 15 2008 8:03 PM | Permanent Link |
"Al Vas" | 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 > |
Tue, Dec 16 2008 6:19 AM | Permanent Link |
"Al Vas" | 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 >> > |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |