Query Error

  
Hello everyone.
I have a problem in advanced query.
I passed this text for parameter: 100,101,102 and i make IN (PARAMETER) but i get one error and i don't understanding why.
I attached the print with query and error for simplify the understanding.

Best Regards, Paulo Torres
Have you set the input parameter to be "Expand Inline"?
Or maybe the issue is not on the where clause or even on the parameter, but in the struct you set for the result set of the query... maybe one of the returned field is a varchar (text) and you are considering it an int on the structure.

Regards.
Pedro Ávila



wrote
:
Hello everyone.
I have a problem in advanced query.
I passed this text for parameter: 100,101,102 and i make IN (PARAMETER) but i get one error and i don't understanding why.
I attached the print with query and error for simplify the understanding.

Best Regards, Paulo Torres
 
 

Hi Pedro.
Yes, the input parameter it's "Expand Inline".
In my
structure i have two fields is a Text...
I attached my espace.

Best Regards

SOLVED...
Problem with SQL :/

Thanks