500+ points - How do should i handle multi-user access to a sql-server 2k/ado/delphi program?
Posted on 2003-12-07
I've asked around a few times, and have read a couple of books on ado, and one on sql-server 2k.
I still can't get around on how to implement a scalable, multi-user program, using client side cursors.
At the moment, i'm using SQL Queries in order to read the data from the database.
I want to use Client side cursors because its more scalable, and will be running on > 30 machines.
Do i have to create a 3-tier software?
If a 3-tier CAN be avoided, then how should i go about it?
I've gone from Server-side cursors, to filters/locates with client side, then used sql queries, tried stored procedures, so i have some experience on how to work with all these, but...
what i need is when user 1 is on a record, and user 2 changes the record details, when user 1 scrolls off and on the record again, i want him to see the changes. Even more, when user 2 is changing the data, i want user 1 to be blocked from editing the details BUT with Client-Side cursors...
Any example code is greatly appreciated (either in sql or delphi/ado)...
This is verrrryyy urgent to me, so i would provide even more points if answer is right on....