Post reply

What cursor would you use?

  • October 1, 2003 at 6:58 am

    #81217

    I have a web application with serveral users who could

    be updating the same table at the same time. Some users are

    saying they are losing data.

    Currently I am using the addnew and update ADO functions to update the table.

    I open the table with adOpenDynamic,adLockPessimistic. Do you think these are

    the correct cursors to update the table?

    Also do you think it would be safer to use the SQL update and insert statements instead

    of the ADO functions?

    Thanks so much. If this is not the correct forum to post my question - I apologize.

  • October 1, 2003 at 3:24 pm

    #476641

    Personally I always use stored procedures to do inserts, updates, and deletes. You have a lot more control over how the data is modified and can check for errors before returning to the front end. You also have better transaction control that way and can roll back the transaction if needed.

    Gary Johnson

    Microsoft Natural Language Group

    DBA, Sr. DB Engineer




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply