DB recordsets and arrays

[rick207]

Hi All.

I've tried to find solution for my problem in the archives but without a luck. I'd like to perform a Sqlite DB query in function. The return from func should be an array where every element is a dataset (as an array) returned by query. I try with passing an one dimensional array by reference and with every new element I redim this array to get it bigger by one. After return from func the size of array reflects the count of items returned by query, but I can't read the content. Trying the way my_array[x][y] fails. _ArrayDisplay( my_array[x], '' ) displays proper data from array.

Thank you for your helps

Rick