Hello gentlemen, I have the following scenario I have a variable of type List, in which both the "Values" and the "Key" with a column of type string, in the data source the query was like this as in the print:
AT.TP_ATENDIMENTO IN ('{V_TP_ATENDIME_AUX}')
I understand that with the quotes it doesn't work correctly, but when I remove the single quotes and run the report, there is an invalid identifier error in the String values.
So I would like to know in the List variable the "KEY" field only accepts values of the integer type so that it works normally?
Or does the "KEY" field accept String values?
Attached the report.
Variable List of type String
-
- Posts: 72
- Joined: Thu Sep 24, 2020 2:40 pm
- Location: Brazil
Variable List of type String
- Attachments
-
- Capturar1.JPG (107.64 KiB) Viewed 2045 times
-
- Capturar.JPG (83.22 KiB) Viewed 2045 times
-
- ATENDIMENTO VS MOVDOC (1).mrt
- (28.41 KiB) Downloaded 194 times
-
- Posts: 6265
- Joined: Tue Mar 20, 2018 5:34 am
Re: Variable List of type String
Hello,
Please check the sample report in the attachment.
Thank you.
Please check the sample report in the attachment.
Thank you.
- Attachments
-
- ListInQueryStringMySQL.mrt
- (7.26 KiB) Downloaded 228 times
-
- Posts: 72
- Joined: Thu Sep 24, 2020 2:40 pm
- Location: Brazil
Re: Variable List of type String
Hi Lech, sorry for the delay in returning, so I was recently validating the sample report you sent me and I came across this error:
" class com.stimulsoft.base.exception.StiException java.sql.SQLException: IN or OUT parameter missing from index:: 1"
Can you guide me on this?
" class com.stimulsoft.base.exception.StiException java.sql.SQLException: IN or OUT parameter missing from index:: 1"
Can you guide me on this?
- Attachments
-
- lista string.mrt
- (7.93 KiB) Downloaded 193 times
-
- LIST.JPG (67.03 KiB) Viewed 1859 times
-
- Posts: 6265
- Joined: Tue Mar 20, 2018 5:34 am
Re: Variable List of type String
Hello,
Please check the modified report.
Thank you.
Please check the modified report.
Thank you.
- Attachments
-
- lista string.mrt
- (8.27 KiB) Downloaded 232 times