If you're using VB.NET 2002, then look at the following classes: System.Collections.ArrayList System.Collections.SortedList System.Collections.Hashtable
These are all dynamic container classes. Mike -----Ursprüngliche Nachricht----- Von: John Newby [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 13. Juli 2006 18:21 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] How do you find out the names of the fields within a table? Hi Fred, yes I am using vb.net. I have searched online for vb.net dynamic arrays, and one site I came accross states the new features of the 2.0framework allows for dynamic arrays but sadly I am using the 1.1 version. http://www.ondotnet.com/pub/a/dotnet/2004/05/25/whidbey_vbnet_pt2.html I am going to try and give it a go though. Many thanks John On 13/07/06, Fred Williams <[EMAIL PROTECTED]> wrote: > > Did not realize he was using VB when I sent my last message. I'd bet > VB still can't do anything dynamic. That's only one of the reasons I > walked away from VB's "Daddy" (Quick Basic) years ago. > > > -----Original Message----- > > From: Martin Jenkins [mailto:[EMAIL PROTECTED] > > Sent: Thursday, July 13, 2006 8:08 AM > > To: sqlite-users@sqlite.org > > Subject: Re: [sqlite] How do you find out the names of the fields > > within a table? > > > > > > 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 > >