...
TccRemoteQueryDatabase.SourceId : string
Beschreibung
Id Die ID des Datenbankprofils, dieses muss welches in der Infinityapplikation Infinity-Applikation angelegt werden muss.
Beispiel
Codeblock | ||
---|---|---|
| ||
const RQdb = 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 Orders" ); RQ.SourceID = "GHCjrA0BEe-NxIo6m1CQ0A"; 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"); } }) |