The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Clarification about using Locktype in recordset
Posted: 26 Jun 08 10:23 AM
|
hi slx users,
This is my code...My question is ,Do i have to set Lock types for the Recordset...? or Slx takes care of it.
i am worried about SQl conflict that takes place..When Multiple users simultaneously execute the below Script..
set objSLXDB = Application.GetNewConnection
set recorset = CreateObject("ADODB.Recordset")
recorset.Open "update account_misc set slx_cluster='20',Account_clusterid=null where Accountid ='AOD9EA000WAS'", objSLXDB
recorset.close
set recorset =nothing
Please clarify my doubt ..thanx in Advance..
|
|
|
|
Re: Clarification about using Locktype in recordset
Posted: 27 Jun 08 2:35 AM
|
| SLX will definitely not take care of it - that function is devolved to the database manager e.g. SQL/Oracle. As you are only updating one col/row here - it's extremely unlikely that you will get a lock. There's no need to worry about this code. |
|
|
|
Re: Clarification about using Locktype in recordset
Posted: 30 Jun 08 2:10 AM
|
thanx Mike for your suggestion...
So do i need to set Lock types in my script when i update mutiple Rows/Columns in Database.
if YEs, how to set and which Lock and cursor types i have to use for My script...Advice me ...thanks. |
|
|
|
Re: Clarification about using Locktype in recordset
Posted: 30 Jun 08 3:27 AM
|
No, you should avoid over reacting to something that the DBServer will handle by itself. There are occasions where you would use the WITH keyword (but none of your examples exhibit the need to do that).
In other words - don't worry about it at all - just get on with your coding and let SQL server deal with it. |
|
|
| |
|