cancel
Showing results for 
Search instead for 
Did you mean: 

B1out - B1isql - Pass value of query to insert statement.

lucas_fischer
Active Participant
0 Kudos

Experts,

Perhaps it is because it is late and I am very tired, but I feel as though I am overlooking some obvious solution to the following scenario.

I have created a scenario that is making a SQL Call to a database, and I need to pass the values from that query to a table in a B1 DB.

I am using an outbound channel of B1, and the B1isql type.

here is my issue,

I know that I can pass the value of atom0 JDBC:JOBID to my Field tag.

However, the insert statement uses the tag attribute value="" to pass the values to the DB.

<Table id="invoicesource" keylist="jobid" task="A" del="">
     <Field id="JOBID" value="" wrapchar="False"><xsl:value-of select="jdbc:JOBID"/></Field>
</Table>

I'd like to be able to pass the <value-of select= />, into the value="" attribute instead.

Any insight would be greatly appreciated.

warmest regards,

Lucas Fischer

View Entire Topic
lucas_fischer
Active Participant
0 Kudos

I used standard SQL out instead, since it was for custom DB object, and not SAP B1 table, issue resolved.

Edited by: Lucas Fischer on Jun 28, 2011 12:01 PM