Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Using Arrays

Author  Topic 

UnathiM
Starting Member

8 Posts

Posted - 2007-01-11 : 02:33:27
Hi Guys

I have a SQL query that returns values. I want to take the results and populate a dynamic array in a VB6 application. I want to use a dynamic array because I run this query quarteky and the number of rows in the result differs each time. Please help...

Select D.Rref From  D Where Print = 'Y' And Status = 'A' Order By D.Ref

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-11 : 02:35:36
Make use of the ADODB recordset.GetString method and SPLIT function in VB.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -