VB always had dynamic containers. Starting with Arrays things such as ReDim helped. Later Collection(s) (actually a Dictionary/Hashtable) were introduced. In VB.NET you of course have all containers, which the .NET framework supplies. In fact there are classes for Lists (ArrayList, LinkedList and template/generic versions...)
Mike -----Ursprüngliche Nachricht----- Von: Fred Williams [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 13. Juli 2006 18:03 An: sqlite-users@sqlite.org Betreff: RE: [sqlite] How do you find out the names of the fields within a table? 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