dBase III Index and VB4 
Author Message
 dBase III Index and VB4

We've run across a bit of a snag in trying to Seek on a dBase III from a VB4
subroutine.

The dBase file consists of a Schedule date, Contract number, etc. etc.  We're
trying to seek  the first occurance of a particular schedule date using an
existing dBase index.  Once found, we will loop through all records that have
this schedule date.

That's the scenario, standard table navigation.  The dbase schedule date field
is a character field of the form "01/01/96".  The index we're using converts
the value being sought from a date to a character type using the dbase
function DTOC().  We think the problem lies somwhere therin. If we seek a
String value as noted above we get a "Data Too Long For Field" error on the
line of code containing  the Seek !!!???.  Any other form of the value being
sought results in the Seek finding the first record of the file.  

We hesitate to define another index on this file (i.e. without using the DTOC
function) because the file averages around 3000-4000 records and takes eons to
reindex.  This data is used in a manufacturing facility and cannot be held up
for any length of time. If the users cannot access this data, the plant shuts
down.  Please, any insight to this dilemma would be greatly appreciated.

Thanks,
Mike Smith
Dayton, Ohio



Tue, 15 Sep 1998 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. VB4.0 16-bit using dBase III Indexes

2. Using DBase III index in VB5

3. Question on dBASE III and indexes

4. dBASE III indexes

5. dBASE III/IV & FoxPro Index files

6. Indexing atached dBase III tables

7. Using indexes with dBase III

8. dBASE III indexes

9. Problem writing to a Dbase III table and updating the indexes

10. Rebuild dBase III indexes from VB

11. Please Help!!!! Trouble creating/using dbase III indexes

12. Dbase III database with indexes

 

 
Powered by phpBB® Forum Software