Hi Martin, I'm not sure, I don't use VB that often, I just need to use it for my Uni project at the moment. I just know this was worked when I need to create an array of all tables in the database, I just did a select count statement on the master table and added that number to the size of the array then filled the array using a while loop till i reached the max array size, so i thought i could amend it slightly for the field names, but without the count of fields the array wont fill as the while loop doesnt end.
Many thanks John. On 13/07/06, Martin Jenkins <[EMAIL PROTECTED]> wrote:
John Newby wrote: > Yeah I can get the names, but I need to put them in an array, and to put > them in an array I need to know the size of the array to store them in, > so I > need to get a count first, then store this number as the size of the array > before I store the values into the array. Are you sure there no dynamic container objects in VB that support an "append" method? Lists? If not (and I find that hard to believe) you could hack around it by appending the names to a string, then parsing the string and then dimensioning your array, or you could build a linked list but ... surely VB has more intelligent containers than statically sized arrays? Martin
