Simple select flow

Flow Connect
1

I am new to flow connect and I am getting an error when I run a simple app in web designer. I am doing a simple select statemen; displaying a requisitioner code in a Labelled static text box.

It’s the beta version of the web designer I am using, I don’t think that is the cause of the error though.

I have attached screen caps of the flow, including the error message. No.1 is the step with the select statement, No.2 is the step with the label. The intellisense detects the requisitioner code in the Label, but it still gives the error.

Any assistance would be appreciated, thank you.

pic 1
pic 11904×643 23.1 KB

pic 2
pic 21897×833 56.4 KB

pic 3
pic 31902×727 60.8 KB

2

The easiest thing to do would be str(REQ_CODE).

But, if you RIght Click on your User Step, and Show Variables, it will show you what you should expect to get from your database query.

3

Thank you for your reply. It’s showing me the value in the diagnostics panel (RBALL; that is correct)

image
image1670×739 47.4 KB

4

Then you would retrive it with {REQ_CODE.value}.