>Without knowing what the backend is, that's impossible to say. Essentially, you have to use whatever the server's DDL is to create a cursor and then insert the values into it.

Ed,
The backend is VFP. I can create cursor with CREATE CURSOR SQL but it's still the problem to insert values from local array. It's easy for me to create a string expression for whereclause and use it through macrosubstitution in SELECT statement.
Thank you,
Ed