>Is it possible to have an application where some tables would be on the web and the rest would be on local computers?

If you're talking about a pure Web Browser hosted application then the answer is no.

If you're talking about a FoxPro application running on the local system and communicating with the server to exchange data, then yes that is possible.

Web Connection includes a host of features to make remote communication over HTTP easy and we provide both the client and server tools to make that work. One built in piece is a remote SQL engine (wwHttpSql) that's built into the framework, that allows you to issue remote SQL commands and retrieve the data to the client app and vice versa. It basically has an interface similar to Sql Passthrough commands, but they can be 'executed' remotely. The framework handles all the encoding of queries and decoding of result data to and from xml.

Web Connection (and just about any Web framework for that matter) also allows you to easily communicate with data you send over HTTP. You don't necessarily need a 'REST' framework for this as you can simply push data back and forth. For VFP often the easiest way is to pass cursors back and forth using XmlAdapter or CursorToXml().

The big issue when you have local and remote data though is synchronization - making sure that data updated on the client updates properly on the server and telling what's changed and what's left the same.

+++ Rick ---


>For examples tables about customers would be on the web and distant computer could share those informations. Other tables would reside on all the workstations.
>
>Would it be possible to do that with a web framework list West-Wind or another framework?