Stored procedures and multiusers

First Question:
I am using interbase 6 with delphi 5. Now i want to create stored procedures for duplication checking and refrential integrity. I want to make some common stored procedure so that i can use one procedure for all the table. Is it possible? How?

Second Question:
With delphi 5 i am using sql server. To make my application multi uses what should i do. Any sites addresses or tips

answer asap :)
Rajni
rajniyadavAsked:
Who is Participating?
 
kretzschmarConnect With a Mentor Commented:
one user may have no luck and will get an exception thrown by the server forwarded through the connection-protocol to your application

SQL server takes care of multiusers,
doesn't matter if there are more users and/or applications accesses the same record, SQL server knows this, because all must go through the server

well there is a transaction issue,
depending on how you connect to the server (ado,bde,..).
but the default settings are normally useable.

meikl ;-)



0
 
kretzschmarCommented:
1. common is not possible, because the tables must be known at compile-time by the server, but you can do a stored-procedure for each table anbd change the name of the storedprocedure in your tstoredproc-object (if you use this)

2. the sql-server takes care of multiuser-access, no need to do something special (excepts your grants and userlogins)

meikl ;-)
0
 
MotazCommented:
Instead of stored procedure you can use Query and you can build it at run time such as:

ibQuery1.SQL.Text:= 'select * from ' + Edit1.Text;

Motaz
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
rajniyadavAuthor Commented:
kretzschmar

SQL server takes care of multiusers
but when we are running two application and two users are trying to modify the same record or when one user is modifying a record while some other user is deleting that record. Those kind of errors how to handle those.
0
 
VSFCommented:
Second question about common store procedures this week!

VSF
www.victory.hpg.com.br
www.boatoda.hpg.com.br
0
 
pnh73Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept answer from kretzschmar

Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
Paul (pnh73)
EE Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.