Hello !
Has anyone succeed in using the ExecProcedure with DB_PARAMETR_ARRAY method ? How i can use this parametr ?? What is this and what i must insert ?
simple code
Redim tablica(2)
tablica(0) = “hej”
tablica(1) = “ho!”
status = res.ExecProcedur(“TableSQL”, DB_PARAM_ARRAY - what i must insert here???, tablica)
I was trying size of table, number, string etc etc…always DB_PARAM_ARRAY is argument !
Best regard’s
Help :
Call odbcResultSet.ExecProcedure( procedureName$, DB_PARAM_ARRAY, argArray )
To enter more than 30 arguments, you can use the alternate syntax and pass the arguments in an array. In the alternate syntax, the second argument must contain the constant DB_PARAM_ARRAY. The third argument can be an array of any size or type.