
Problem writing to a Dbase III table and updating the indexes
Quote:
> different that the header of the original
> NDX file , so the legacy application ( SBT serie 7 ) does not understand
it.
Yep, this was why I was wondering about the legacy application.
I rebuilt your index to create *.MDX instead of *.NDX and was able to get
things to work. The problem would be wether your legacy app would handle
*.MDX index files. MDX indexes are referred to as maintained Indexes and I
think are better supported across diferent applications - but not 100%
sure...
Here are my notes:
Ignacio, received your table & index..
==============================================
Files were readonly!
SQL Explorer / Database Desktop:
Existing index *.ndx not recognised as index for table !
Version reported as dBASEIV 2.0
Defined Unique index on SONO field {Maintained!}
Defined Index on CustNo field {Maintained!}
Saved as SOMAST01_MIKE .DBF
Index extensions *.MDX instead of *.NDX
Edited Mike Version in SQL Explorer OK, index recognised
Edited Mike Version in AdoAnywhere Browser in BDE Mode OK
Edited Mike version in AdoAnywhere Browser ADO Mode, results follow:
1) Connection String: Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\DBase\files.zip;Extended Properties=dBase IV
2) Server side cursor, SQL Text, ignored index values
3) Client side cursor, SQL Text, failed to locate record after update,
tried modifying recordset update criteria (1,2,3) Didn't work.
4) ** Table Direct with server side & keyset cursor worked OK. **
It looks as though your existing index files are not recognised by any tools
(excpet perhaps by Dbase itself). You will have to resoilve that issue
yourself.
If you create a new index on your tables with 'Maintained' option then they
are recognised in BDE and ADO tools.
I was only able to operate on the table properly using Server Side Keyset
Cursors with Table Direct option.
==============================================
--
Mike Collier BSc(Hons) Comp Sci
www.adoanywhere.com