/
TccRemoteQueryDatabase.SourceId
TccRemoteQueryDatabase.SourceId
Eigenschaft
TccRemoteQueryDatabase.SourceId : string
Beschreibung
Die ID des Datenbankprofils, welches in der Infinity-Applikation angelegt werden muss.
Beispiel
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");
}
})
, multiple selections available,
Related content
TccRemoteQueryDatabase.QueryFields
TccRemoteQueryDatabase.QueryFields
More like this
TccRemoteQueryRepository.Response
TccRemoteQueryRepository.Response
More like this
TccRemoteQueryRepository.Query
TccRemoteQueryRepository.Query
More like this
TccRemoteQueryRepository.SourceId
TccRemoteQueryRepository.SourceId
More like this
TccRemoteQueryRepository.Reset
TccRemoteQueryRepository.Reset
More like this
ccFactory.CreateDatabaseRemoteQuery
ccFactory.CreateDatabaseRemoteQuery
More like this