ResetDb: { OnSelect: () => {
const RQdb = ccFactory.CreateDatabaseRemoteQuery("ZuF-mV7_wk6sLIRYrYawXQ",`"SELECT * FROM Customers Where City = :Feldname"`,{"Feldname": "Berlin"});
RQ.SourceId db.ExecAsync().pipe(mergeMap(success=>{
if(success){
db.Reset();
db.SourceId = "GHCjrA0BEelwyRzgyLEe-NxIo6m1CQ0AvV0qTCulcew";
RQ.Query db.Query = `"SelectSELECT * FromFROM OrdersInventory Where MandtCustomer = :Client And BUKRS = :Companycode And EBELN = :Ordernumber";
RQ.QueryFields = '{"Client" : "001", "Companycode" : "2000", "Ordernumber" : "45666555"}';
Customer"`;
db.QueryFields = {"Customer":db.Response.Rows[0]["Id"]};
return db.ExecAsync();
}
return of(false);
})).subscribe(success=>{
if(success)
{
const rowcount = db.Response.Rows.length;
console.log(db.Response.Columns);
if(rowcount > 0)
ccFields.SetState("h_inventory", "ccFS_Okay");
else
ccFields.SetState("h_inventory", "ccFS_Error", "No inventory found");
}
})
} }, |