I'm quite new on B1IF and I have this strange problem that I'm sure that you guys could help me on this:
I'm working on a Scenario step where I need to do SQL Call and then put that result into a variable to use it in another SQL Call. When I do a XSL transformation this is working and printing the correct value:
<vDocFROMSAPCardCode> <xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@id='atom9']/jdbc:ResultSet/jdbc:Row/jdbc:CardCode"></xsl:value-of> </vDocFROMSAPCardCode2>
This will print the value, However if I try to assign this to a Local Variable called vFROMSAPCardCode:
Always comes empty. I need to use the result of that query in another query but always comes blank, despite the logic seams to be OK.
# SELECT T0."DocNum", T0."DocEntry", T0."CardCode", T0."NumAtCard" FROM ORDR T0 WHERE T0."CardCode" = '$vFROMSAPCardCode'
Does anyone know what am I missing here? Or how to use the result of a previous query into antoher one?
atom9 Is the original query that it's working fine
atom20 is the XSL transformation after the query is executed.