Search results

  1. J

    How to return an array (VB) and use it in a querry?

    I use an array becasue the data stored in is temporary..anyway I resolved the problem :D :D I just made my own In() function. Now in query I have WHERE (((isIn([Tab].[field]))=1)); yeaa :>
  2. J

    How to return an array (VB) and use it in a querry?

    Thanks for your quick reply. This is one dimensin array of Integers. Every time I add new element into my array I use: ReDim Preserve ar(cnt) ar(cnt) = newValue cnt= cnt+ 1 I have no idea how to chagne it into horizontal version. If this wouldn't work do you have an idea how to replace...
  3. J

    How to return an array (VB) and use it in a querry?

    Hello everybody. It's my first post :) I have a function which returns an array: Dim myArray(5) Public Function getMyArray() getMyArray = myArray End Function And now I'd like to do some query..something like this Select * From MyTable where MyTable.id IN (getMyArray()); When I use it...
Back
Top Bottom