Using indexes

vger
09-25-2000, 05:53 AM
Hi all ..
I've got this problem with dBase database files.
I'm using the Foxpro drivers to connect to an dBase database and when I adds records to a table in that database the indexes is not updated.
There is a external program that uses this database and i wanna add records so that this program may see this newly added records. This program uses CDX files to read the database-tables and when I add some records the program cant see it.

I hope someone out there have seen this problem.

Regards Christer

whelanp
09-25-2000, 06:35 AM
a) What it the exact source of your data files?

b) What driver are you using?

Some dbase formats such as those used by Goldmine (a Contact Manager) do not allow you to update the indexes unless you buy specific drivers (which are quite expensive).

vger
09-25-2000, 06:44 AM
this is how i do.
I'm using ADO and connects like this.
Set dbs_s = wrk.OpenDatabase(path_s, False, False, "FoxPro 3.0;")
as u may se i'm using the FoxPro 3.0 driver.
The exact source hmm .. dont know ,, but i think that they usined somekind of foxpro driver to make this tables. I may se and count the indexes, but then the database is in readonly state and that is not what i want ..
thanx.. christer

whelanp
09-25-2000, 09:59 AM
You could try using the "Visual FoxPro x.x" driver, I believe there is a difference (although I don't know what)

also I think you may be using DAO.

What is the variable wrk (a workspace object??).

vger
09-26-2000, 11:05 AM
wrk is an workspace .. .. i will try the visaul foxpro driver .. thanx for your help ..
i will comeback here for more help if it doesn't work..

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum