How to set array parameter in sql statement?
Posted: Tue 30 Jul 2013 21:29
I can't figure out how to populate an array into my statement, I have googled and searched this forum with no results.
example: "insert into mytable(someArray) values (:myArray);" //myArray is integer[10]
qry->ParamByName("myArray")->Value = ?????
I've tried various ways of setting this and get different errors each time. Help! Thanks!
example: "insert into mytable(someArray) values (:myArray);" //myArray is integer[10]
qry->ParamByName("myArray")->Value = ?????
I've tried various ways of setting this and get different errors each time. Help! Thanks!