| View previous topic :: View next topic |
| Author |
Message |
Guest
|
 Posted: Sat Oct 28, 2006 7:46 pm Post subject: What makes a delphi Database Application Multi-User?? |
 |
|
Hi All,
I have a delphi 7 ado access 2000 database application running on my
workstation. The database is on a server. Other users want to be able
to use it. Do I need to do something special code wise ?
What makes a delphi Database Application Multi-User??
thanks
John |
|
| Back to top |
|
 |
Brian Bushay TeamB
Guest
|
| Posted: Sun Oct 29, 2006 12:20 am Post subject: Re: What makes a delphi Database Application Multi-User?? |
|
|
| Quote: | Hi All,
I have a delphi 7 ado access 2000 database application running on my
workstation. The database is on a server. Other users want to be able
to use it. Do I need to do something special code wise ?
You have to write your code with an awareness that it will be multi user. |
If you are just using Delphi data controls you don't have to do anything
special.
But when you start writing code that changes records then you need to trap for
errors situations that would result if there is a contention editing a record.
One thing you don't want to do in a multi user application is use a Transaction
while a user has control of the application. Transactions should only be used
when your code has complete control.
| Quote: | What makes a delphi Database Application Multi-User??
The database you are using needs to be capable of mu lit user access. |
After that it is a matter of not writing any code that would compromise that mu
lit user access.
--
Brian Bushay (TeamB)
Bbushay (AT) NMPLS (DOT) com |
|
| Back to top |
|
|
Chester and the water hos
Guest
|
| Posted: Sun Oct 29, 2006 11:29 pm Post subject: Re: What makes a delphi Database Application Multi-User?? |
|
|
Do I need to do something special code wise ?
Use SQL |
|
| Back to top |
|
|
Brian Bushay TeamB
Guest
|
| Posted: Mon Oct 30, 2006 6:21 am Post subject: Re: What makes a delphi Database Application Multi-User?? |
|
|
| Quote: | Do I need to do something special code wise ?
Use SQL
|
If you are asking if the SQL is specific for multi user applications that answer
is No
--
Brian Bushay (TeamB)
Bbushay (AT) NMPLS (DOT) com |
|
| Back to top |
|
|
John Herbster
Guest
|
| Posted: Mon Oct 30, 2006 6:44 am Post subject: Re: What makes a delphi Database Application Multi-User?? |
|
|
<johnkathome (AT) gmail (DOT) com> wrote
| Quote: | [...]
What makes a ... database application multi-user?
|
In the common usage of phrase, I would say that a
"multi-user database application", must have the
ability to allow multiple instances of the application
to write and access the data in such a way that
each will see a complete, if dated, view of data and
not see data from partially completed transaction
being made by another instances.
In other words if two instances of the application
are selling the last seat on the airplane, one must
be allowed to fail and be backed out -- gracefully.
--JohnH |
|
| Back to top |
|
|
Dave Keighan
Guest
|
| Posted: Mon Oct 30, 2006 6:47 am Post subject: Re: What makes a delphi Database Application Multi-User?? |
|
|
John,
| Quote: | In other words if two instances of the application
are selling the last seat on the airplane, one must
be allowed to fail and be backed out -- gracefully.
|
You make it sound /sooooo/ simple.
The OP mentioned an access 2000 database ;-)
--
Dave
Delphi Hobbyists and Occupational Developers
Member Since 1998 |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
