Using ASP to add to dbf

[MarkyMark35]

Hi all,

I'm using ASP to open, update and add to a dbf table.

I can open it, update entries but when i add an entry, the application that uses the table doesn't see it.

I do beleive that this is due to the indexs not beeing updated. I am using the following code to accomplish this

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\;Extended Properties=DBASE IV;"
If conn.errors.count = 0 Then
conn.Execute("INSERT INTO COUNTRY VALUES ('AAAA','CANADA','6/11/1998','LAMY')")
response.Write "Succeeded"
conn.Close()
else
response.Write "Failed"
end if

If i use Access to see what's in the table, the entry is there but the clipper app using this doesn't see it.
Is there something special i need to do to get the new entries in the clipper app?

Any help is apreciated

 

[Blorf]

Is there a reindex utility within the clipper app?

Using a similar set of circumstances my self, and I have to use the built in reindex of the app I am working with.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[MarkyMark35]

Maybe there is but it isn't an option.
The data must aprear without any user intervention in the clipper app.

 

[Blorf]

I understand.

You say it's there when you use access?

Access will latch the index. Maybe use access as a conduit for placing the data into the table instead of your asp app. If you create the datasource, you can automate the Access app to populate.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[MarkyMark35]

I figured it out
I'm going to be using the Ado drivers from Advantage.
They do all the work with index and stuff.
Tryied it all day yesterday and it works fine. I can use regular SQL queries to do anything (well almost)

Thanks for your replies Blorf