I have the following code
Dim objNewMail As New CDONTS.NewMail
objNewMail.To = "afalkows@hotmail.com"
objNewMail.From = "afalkows@hotmail.com"
objNewMail.Subject = "test"
objNewMail.Body = "test"
objNewMail.BodyFormat = CdoBodyFormatText...
Is there a way to have a stored procedure synchronized?
What I mean is that there are multiple applications that are going to be calling this stored procedure, is there a way to tell SQL server to synchronize it so that only one app can call it at a time.
Kind of like threads
Regards
Alex
Basically I have a tab which contains a listbox and next to that some textfields. When a value in the listbox is clicked these textfields are filled with their corresponding values form the database.
The listbox has an add and del button. The client is allowed to make as many changes to any of...
I have two tables Category and Locator. Locator references Category through Category_ID.
Now to get from the Locator table I do a simple select
SELECT * FROM [Locator] JOIN [Category] ON [Category].[Category_ID] = [Locator].[Category_ID]
Now through ADO When I use the find method Locator_ID...
Basiaclly I have this code that opens a stored procedure
Set mUsersRecordset = New ADODB.Recordset
With mUsersRecordset
.CursorLocation = adUseClient
.CursorType = adOpenDynamic
.LockType = adLockBatchOptimistic
.Open...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.