Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: PANIk
  • Order by date
  1. PANIk

    CDONTS Problem

    I have read microsoft support page http://support.microsoft.com/default.aspx?scid=kb;en-us;Q214667 And what is it telling me that I have install Microsoft Exchange to send email. I read somewhere that win2k came with the right dll and that was it. Any response would be excellent
  2. PANIk

    CDONTS Problem

    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...
  3. PANIk

    Synchronizing

    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
  4. PANIk

    Design Question

    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...
  5. PANIk

    Deleting from a recordset

    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...
  6. PANIk

    Error in assigning string value to recorset field

    This applies to default values. My database design does not have default values. I can't use a server side cursor because a lot off adding and updating is done on the client side and then its batch updated. I don't think a server side cursor is wise. It is giving me error with char fields not...
  7. PANIk

    Error in assigning string value to recorset field

    Basiaclly I have this code that opens a stored procedure Set mUsersRecordset = New ADODB.Recordset With mUsersRecordset .CursorLocation = adUseClient .CursorType = adOpenDynamic .LockType = adLockBatchOptimistic .Open...

Part and Inventory Search

Back
Top