Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Dataset Params problem
Fri, Mar 14 2014 4:38 AMPermanent Link

David Darlison

I have a default dataset query set on my remote DBISAM table as:
SELECT * FROM orders
where orderno = {orderno = 9000}

I then call the table in EWB with:
SalesOrders.Params.Clear;
SalesOrders.Params.Add('OrderNo='''+sqlorderno+'''');
Database.Load(SalesOrders);

where sqlorderno is a string such as '1234'.
The problem is the default row is always loaded, can anyone see why?
Fri, Mar 14 2014 5:16 AMPermanent Link

Matthew Jones

I can't answer, but there is a message from johnmuller54@gmail.com a few days ago
that shows a working example. Looks like you should miss out the value in the
original?

/Matthew Jones/
Fri, Mar 14 2014 5:57 AMPermanent Link

Uli Becker

David,

> where orderno = {orderno = 9000}

Try to change that in

where orderno={orderno=9000}

The blanks could be the problem.

Uli
Fri, Mar 14 2014 6:49 AMPermanent Link

David Darlison

Uli Becker wrote:

<<David,

> where orderno = {orderno = 9000}

Try to change that in

where orderno={orderno=9000}

The blanks could be the problem.

Uli>>

Brilliant thanks Uli, won't forget that again now!

Dave
Wed, Mar 19 2014 11:35 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Uli,

<< The blanks could be the problem. >>

I thought that I fixed that, but if not, I'll make sure to fix it in the
next build.

Tim Young
Elevate Software
www.elevatesoft.com
Image