PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → Salesforce query result
Salesforce query result
Iniciado por jorge.s.costa, 07,feb. 2020 20:14 - No hay respuesta
Publicado el 07,febrero 2020 - 20:14
Hi all.
I need to obtain the result of a SOQL query using 2 salesforce objects.
Using the salesforce query editor, the results are ok.
But when I to obtain the results into Windev, only the itens related to the first object are ok, the other error.
Below a part of the code:

gsQryTxt = StringBuild(gsQry,EDT_Pedido)
SFRes is sfExecuteQueryResult
SFRes = SFExecuteQuery(SFCnt,gsQryTxt)
ARec is sfObject

FOR EACH ARec OF SFRes
IF HReadSeekFirst(Pedidos,IDPed,ARec.IDPED__c) = True THEN
Trace("Produto = " + ARec.Produto__c)
Trace("Pedido " + ARec.OrderNumber + "já cadastrado")
CONTINUE
END
END

"Produto" is a field of the first object, and is OK.
"Pedido" is a field of the seconf object, and ERROR - not in ARec ...

There are anybody knows how to resolve that?

TIA