...
Codeblock | ||
---|---|---|
| ||
const RQ = ccFactory.CreateDatabaseRemoteQuery("lwyRzgyLEe-vV0qTCulcew","SELECT COUNT(IBAN) AS IBAN FROM Customers where IBAN = :IBAN", {"IBAN" : ccFields.GetValue("h_creditoriban")} );
RQ.ExecAsync().subscribe((result)=>{
if(result){
const row = RQ.Response.Rows[0]
const IBANCount = row["IBAN"];
if(IBANCount > 0)
ccFields.SetState("h_creditoriban", "ccFS_Okay");
else
ccFields.SetState("h_creditoriban", "ccFS_Error", "IBAN nicht vorhanden in Stammdaten");
}
} |