Logic Editor "Write File" question

[Former Member]

Hi,

I am new to BL and am having an issue with Write File

I created a mssql query and it tests ok. In BL I have 3 sequences.

1.Open mssql Query

2. Create file to folder

3. Append data to created file.

My issue is that when I execute these sequences, I end up with a created file with no data. Has anyone had this problem before?

Thanks

Mike

[Former Member · Accepted solution]

Hi M Hamel

To write a file from SQL Query , u need only two sequences

1. Get SQL Query with proper parameters passed to this Query

2a) Use 'WriteFile' Action by configuring the File Path such like this E:
Lighthammer
Illuminator
Templates
UserTemplates
example.txt

(Please note the double slash)

and use the mode 'APPEND'

2b) In the Link Editor for same action WriteFile, assign the property 'Text' with such expression as u like

<b>

" Material = " & IllumSQLQuery_0.Results{/Rowsets/Rowset/Row/Material} & crlf &

" LSL = " & IllumSQLQuery_0.Results{/Rowsets/Rowset/Row/LSL} & crlf &

" USL = " & IllumSQLQuery_0.Results{/Rowsets/Rowset/Row/USL} & crlf & crlf

</b>

Regards

Som

Message was edited by:

Som Sarkar

[Former Member]

Thanks Som and Udayan for the linking help, I had not linked the incoming query to the outgoing text.

Thanks Rick for the tip on elimating a sequence.

[Former Member]

You don't need to create the file - that happens automatically in the WriteFile action.

[Former Member]

Looks like you are not writing any data to that file.

I hope you did link the 'Text' attribute of the 'Write File' action to some data?

Assuming you did link the output of the SQL action then can you confirm that your query returns some data?