>Thanks Bill
>I will be looking into these options.
>
>Another question.
>I can see where you have a database for a corporation with a number of branch offices using MySQL d/b on the Web server, but
>I am looking to have an Application on the Web Server and MySql D/B installed on each clients work station. I would be using VFP7 (w/o WestWind) or maybe PHP for the application on the server. The idea would be, when the client subscribes to the application, to install the d/b on the client work station & also install an Icon containing the URL of the application.
>I would appreciate any input you have on this.
>Bill Wright
---
Heya Bill -
I had looked at this a few years back for a paradigm of info subscribing.

if you can bind [theo-rhetically] the concept of 'subscriber' to 'domain space' then you should be ok. I would suggest a basic Primary Key -- Foreign Key Relationship - but I'm glossing over quite a lot here.

the branch office would have to have access to what? from a domain space standpoint ? answer that one, and thats about 80 percent of your design.

--
a mySql DB installed at each clients work station ? WHY ?? seems overkill, at least in me small wee heid.

I don't think the 'D/B' needs to be installed at the workstation level - but instead - some how think of a subset o data that relates back to the branch office that resides back at the server level. Could be a seperate DB with some linkage back to a MASTER, or not - depends on the design. You could get into a lot of replication issues, of course.

There are branch office constraints, of course, that could be stored back in the VFP domain, but to make a sub-domain at a branch office in EACH WORKSTATION for mySQl ? seems to me the design is flawed.

mySql is really a server-based DB - so if you ain't doing server level DB-slinging - why bother ? [big oversimplification, I Know, but I have to ram it home somehow] ..

let me know your thoughts? no personal attacks intended - my apologies if it seemed that way. I'm a fan o CJ Date and his theories o SQL and DB design.


gufen mySQL [Bill]