> Hello! I have a simple SP with something like this: > > select my_field > from some_table > where id in (1,3,56,100) > > How can I do to pass "(1,3,56,100)" a an input parameter?
You can pass the IN list as a string, build the SQL statement <sql_text> dynamically and execute the SQL with: [FOR] EXECUTE STATEMENT <sql_text>; -- With regards, Thomas Steinmaurer (^TS^) Firebird Technology Evangelist http://www.upscene.com/ Do you care about the future of Firebird? Join the Firebird Foundation: http://www.firebirdsql.org/en/firebird-foundation/
