Use a DTS process on the SQL server side to update the VFP database. An update trigger could launch the DTS process.
Fairly simple. V/R //SIGNED// Stephen S. Wolfe, GS-11, DAF Data Services Manager Comm (813) 827-9994 DSN 651-9994 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan Bourke Sent: Tuesday, August 29, 2006 7:59 AM To: [email protected] Subject: Advice needed on web interface. We have a client with an existing networked membership application written in VFP8. They want to add a web interface to this. It would basically replicate a couple of forms and put them online, writing back to the VFP database. If the web hosting was done offsite, I would envisage using an ASP.NET setup writing to a local SQL database for the web part. What I need to do is have the web side update the VFP database at the customer's office in realtime or near as dammit. What would be the best way to do that? -- Alan Bourke [EMAIL PROTECTED] -- http://www.fastmail.fm - Send your email first class [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
