#1 2018-01-10 03:59:11

cbsistem
Member
Registered: 2016-05-29
Posts: 1

One request and Multiple Array distinct Objects

procedure Test(Props: TSQLDBConnectionProperties);
var
   Customer , City , Vendor : Variant;
begin
  with Props.Execute( ['select * from Customers where AccountNumber like ?',    ['AW000001%'],@Customer ],   
   ['select * from City where Name like ?',    ['CHIGAGO%'],@City ], 
   ['select * from Vendor where ID = ?',   ['1000'],@Vendor ], 
    ) do
    while Step do
      assert(Copy(Customer.AccountNumber,1,8)='AW000001');

    while Step do
      assert(Copy(City.Name,1,8)='CHICAGO');

   while Step do
      assert(Copy(Vender.ID,1,8)='1000');

end;



---------------------------- OR   ------------------------------------


JSONToClientDataSets(self,Client(['select * from Customers','select * from City','select * from Vendor'], [ds1.DataSet ,ds2.DataSet ,ds3.DataSet ]);




Is possible ?



Tanks

Cristiano Barbosa

Offline

#2 2018-01-10 10:08:35

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,604
Website

Re: One request and Multiple Array distinct Objects

I don't think so, but I'm a little confused by your code.

Online

Board footer

Powered by FluxBB