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");  
        }
      })