>>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.
CREATE CURSOR
whateverAPPEND FROM ARRAY thisform.aValuesFromArray
and a nice, simple IN clause that's supported regardless of the backend.