Update DBF based on a Trigger

[davidy]

Hello,

I have the following question.
We started with our migration we now use FoxPro with dbf’s.
The end goal would be web and SQL server.
But in this process all old FoxPro programs still need to be up and running.

We now have made a program and its database is SQL server but some of the data we insert there needs also be inserted into the dbf’s.
The question is now is it possible that we can update our dbf’s with a trigger?
I have searched the web but the only thing I could find for updating the dbf’s was using the DTS package.
But the problem then is that the data is scheduled and not updated instantly.

If someone has a bright idee I would be a happy man.

 

[JohnDTampaBay]

Check out OPENROWSET in Books Online. You should be able to use it to connect to the FoxPro DBF just like any other SQL Server table. Use OPENROWSET in an UPDATE statement. Good luck!

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)