Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Getting #700 on find
Thu, Jun 29 2017 9:59 PMPermanent 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 PMPermanent 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 PMPermanent 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 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PMPermanent Link

KimHJ

Comca Systems, Inc

Tim Young [Elevate Software] wrote:

>>So you're all set ?

Yes, Thanks.
Kim
Image