Originally Posted by
Jim Mulenos
How do I best use an array as my list for the IN clause in a select statement? I believe it goes something like this:
SELECT * FROM {file} WERE {field} IN (myFunction(MyArray))
Code:
Move ("'" + StrJoinFromArray(asGattung, "','") + "'") to sGattungList
Add ("where Gattung in (" + sGattungList + ')') to sSQl
Something like the above should work.