speeding up loading lists from dbase IV file 
Author Message
 speeding up loading lists from dbase IV file

I have to read a 6 fields into 6 listboxes for searches. No updating of
the database is needed. I am reading a dbase IV file. I've tried sql
sql="SELECT [field1],[field2],[field3]...FROM database Where

set rs.openrecordset(sql,...)

or data control to list boxes, but I always end up doing the ol':
while not rs.eof
        if not isnull(rs![field])
                lstSomething.additem rs![field]
        end if
wend 'if I live that long

When I set up a data control and use DBList box, it autofills quickly,
but does not support looping thru the list. Is there a way to get a
listbox to autofill? I can live with searching in memory-got lots of

Tue, 30 Jun 1998 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Dbase IV : listing of fields in a combo/listbox

2. Dbase IV : listing of fields in a combo/listbox

3. dBASE IV Files <> BSIC

4. Open a dBase IV file

5. Reading fields from a dbase IV file

6. How to delete a recordset of dBASE IV DBF file use VB4

7. dBASE III/IV & FoxPro Index files

8. Accessing the memo field of a DBase IV file

9. Crystal Reports choking on dBASE IV files

10. How to update dBASE IV files in VB3Pro ?

11. VB/Access and dBASE IV mdx files?

12. Read DBase IV files with VB 3.0 Prof.


Powered by phpBB® Forum Software