Subject Re: [IBO] How to move info from a CheckListBox into SQL statement?
Author Helen Borrie
At 04:14 AM 21-05-01 -0700, you wrote:

>But just for future understanding the main application is primarily a desktop app only. There are very few doctors using the medical device on a network and even then a simple file sharing scheme would probably work (there is very little chance of file contention, because a patient can not be in two locations at the same time<s>).The number of records are miniscule at this time, too.

Just to improve your day (!) there is no such thing as "simple file sharing" with a client/server database. The database inside the "file" which stores it has a life of its own and it's this that the IB server controls (with help from the OS and the network).

Clients access the database but they never touch the file. Don't even think of "local" interbase server as being just like Paradox or Access. LIBS is a "fudge" created for the convenience of programmers and isn't intended for deployment. If there's the least chance that your app will have multiple users, go TCP/IP right now, using LOCALHOST as your server on a single machine.

On IB, you don't get "file contention", you get row contention.


All for Open and Open for All
InterBase Developer Initiative ยท