Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » Elevate Web Builder Technical Support » Support Forums » Elevate Web Builder General » View Thread |
Messages 1 to 5 of 5 total |
Getting #700 on find |
Thu, Jun 29 2017 9:59 PM | Permanent Link |
KimHJ Comca Systems, Inc | Using EWB with EDB I'm getting:
Dataset load response error (ElevateDB Error #700 An error was found in the statement at line 3 and column 1 (Missing expression)) Here is the Dataset Query SELECT * FROM PickupRequest WHERE CUSTOMERID={CUSTOMERID=1023} If I add the following line I get: Expected end of expression but instead found BY ORDER BY REQDATE, REQTIME Here is what I'm calling: PickReqTbl.Params.Clear; PickReqTbl.Params.Add('CustomerID=' + CusTbl.Columns['ID'].AsString); LoadRows(PickReqTbl); It use to work and I look at the examples online, did anything change that I'm missing? Thanks for any help. Kim |
Thu, Jun 29 2017 10:17 PM | Permanent Link |
KimHJ Comca Systems, Inc | Just to add to it, it works fine in preview in the Dataset.
It also works fine on a page where I have TEdit and a DataSetToolBar i can hit next with no problems. It is only when I use find and show a grid with all customers. after selecting I get the problem. Here is find function. function TDataAll.FindCustomer(const CID: String): Boolean; begin with CusTbl do begin DisableControls; try InitFind; Columns['ID'].AsString:=CID; Result:=Find; finally EnableControls; end; end; end; |
Thu, Jul 6 2017 6:55 PM | Permanent Link |
KimHJ Comca Systems, Inc | I noticed that it was called three times so I added.
if Length(CusTbl.Columns['ID'].AsString) > 0 then begin PickReqTbl.Params.Clear; PickReqTbl.Params.Add('CustomerID=' + CusTbl.Columns['ID'].AsString); LoadRows(PickReqTbl); end; That worked. |
Fri, Jul 7 2017 9:55 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Kim,
<< I noticed that it was called three times so I added. if Length(CusTbl.Columns['ID'].AsString) > 0 then begin PickReqTbl.Params.Clear; PickReqTbl.Params.Add('CustomerID=' + CusTbl.Columns['ID'].AsString); LoadRows(PickReqTbl); end; That worked. >> So you're all set ? Tim Young Elevate Software www.elevatesoft.com |
Fri, Jul 7 2017 4:02 PM | Permanent Link |
KimHJ Comca Systems, Inc | Tim Young [Elevate Software] wrote:
>>So you're all set ? Yes, Thanks. Kim |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |