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 |
Dataset Params problem |
Fri, Mar 14 2014 4:38 AM | Permanent 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 AM | Permanent 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 AM | Permanent 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 AM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |