We made a VFP program to keep in sync an SQLDATABASE and some free tables. They whay we have done this is with remote views and trying to do a sqlprepare(select * from ...} but both take a long time to run. We made the remote views from the database [right click and select new remote view]. The SQL Database is for a web server for ordering on line and the free tables are for an accounting system. We need to keep the two separted but we need more speed. Any suggestions? Can sql keep tables sync or is this the only way.
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers