speeding up loading lists from dbase IV file

speeding up loading lists from dbase IV file

Post by brad koce » Sat, 13 Jan 1996 04:00:00

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


1. Exporting dBASE IV memo field to ASCII file without using dbase IV

I need to export dbase IV files, which contain memo fields, to ASCII files,
without using the dbase IV database engine.  I have a Clipper program that
will do this for a .dbf that does not contain a memo field.  Is there a way
to do this for a .dbf that does contain a memo field?

Thanks in advance for any suggestions.

Todd Owers

2. OCI and Unicode support

3. How to convert FoxPro 6.0 to DBASE IV and DBASE IV to MSSQL

4. bcp on HP Sybase 11.9.2 gives bus error....

5. Converting dbase IV files to dbase 3+

6. set a field that stores a boolean (true/false)

7. Dbase IV Speed Problem.

8. 23366-FL-W. Palm or Miami-PowerBuilder-SYBASE-ORACLE-Programmer/Analyst

9. Can I speed up my dBase IV application?

10. Using ADO to open cdb files (these are actually dbf dbase IV files)

11. Load Dbase IV Tables ?

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

13. DBASE IV error codes listing