>I dind't think that was the case. The IT folks blaim everything on Foxpro around here. If a PC blows up, they say it's foxpro. I don't see that as the case. I have worked and consulted in many places and never have I seen the computers and servers blow up as much as they do here. They keep telling me to switch to Oracle dbf's but that is out of the question right now. Wht's the difference in table created in Foxpro and the one's created in Oracle?
In reality, the difference is where the data is stored and manipulated. Under Oracle, a backend (or backends) performsn all physical data operations on the database; only one system (or set of interlinked systems) called backend servers, performs the physical I/O. These same systems perform queries submitted to them by client systems; they return a dataset to the client based on the request they process. When a client needs to update the common data table, it passes a transaction to the backend; it's the backend's responsibility to perform the actual updates to the central data store. Individual client systems never work directly against the live data; the requests are passed to the server, which can apply rules implemented at the server, and then either processes the request as sent by the client, partially implements the request, informing the client what if any portions failed to process, often offering an option to disllow all interrelated changes, and enforcing rules concerning secuirty, reliability and validity.