...
TccRemoteQueryDatabase.SourceId : string
Beschreibung
Id Die ID des Datenbankprofils, dieses muss welches in der Infinityapplikation Infinity-Applikation angelegt werden muss.
Beispiel
| Codeblock | ||
|---|---|---|
| ||
const db = ccFactory.CreateDatabaseRemoteQuery("ZuF-mV7_wk6sLIRYrYawXQ",`"SELECT * FROM Customers Where City = :Feldname"`,{"Feldname": "Berlin"});
db.ExecAsync().pipe(mergeMap(success=>{
if(success){
db.Reset();
db.SourceId = "lwyRzgyLEe-vV0qTCulcew";
db.Query = `"SELECT * FROM Inventory Where Customer = :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;
if(rowcount > 0)
ccFields.SetState("h_inventory", "ccFS_Okay");
else
ccFields.SetState("h_inventory", "ccFS_Error", "No inventory found");
}
}) |
...