>I agree with Edward. Bulding a C/S app is not as simple as connecting your program to the remote source, it requires a different application philosophy that most 2.6 apps never subscribed to.
>
>The VFP docs detail a lot of what is involved, so get to reading. I wouldn't count on any magical shortcuts though.
Hi Erik,
Just wanted to throw out a wild guess.
What if you renamed all the existing tables and pre-pended them with 't_', also rename the orig. .dbc add a 't_' also. Now create a new .dbc (same name as the original, add a connection that uses ODBC to point to the original tables, and create a remote view for each table using the original table names.
so MyDbc becomes t_MyDbc
so MyTable becomes t_MyTable
then make a new MyDbc and a remote view called MyTable.
You could trick the forms into using the remote views instead of the tables. As long as the forms use tableupdate / revert it might work.
I know there will be alot of places where you could have problems, just wondering if maybe it could provide a temporary solution.
Stephane- This s a SWAG, I'm not saying it will work, and don't even know if it is completely plausible. As both Erik and Ed have said, there is probably no magical cure. I'm just throwing it out to get some input.
You may want to look at
http://msdn.microsoft.com/isapi/msdnlib.idc?theURL=/library/periodic/period99/html/ft99d1.htm for some ideas of how to architect a C/S solution that uses both VFP and SQL back-ends..
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!