cancel
Showing results for 
Search instead for 
Did you mean: 

Variable from a previos SQL Call always comes blank despite it has a value

Former Member
0 Kudos
162

Hi Everyone.

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:

/vpf:Msg/vpf:Body/vpf:Payload[./@id='atom20']/vDocFROMSAPCardCode2

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?

BTW.

atom9 Is the original query that it's working fine

atom20 is the XSL transformation after the query is executed.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Manuel,

Probably problem is in variable - application cannot use variable if you put it directly in Call SQL Atom. I would suggest to use construction like one below (make a statement in XSL atom and call it in SQL atom):

        <SQLStatement xmlns="">
            <xsl:variable name="CardName" select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='X']/xx/Code"></xsl:variable>             <Statement1>
                select * from "CRD1" Adr inner join "OCRD" BP
on Adr."CardCode"=BP."CardCode" where Adr."U_NN" =  '<xsl:value-of select="$CardName"></xsl:value-of>' order by Adr."AdresType";
         </Statement1>
        </SQLStatement>

It will help you to see what query exactly was used.

Hope it will help you!

Former Member
0 Kudos

Thanks a lot.

This solved my problem.

Answers (0)