Create temp table after locking a table row (vb6)

• carlo.puglisi

  Valued Member

  Points: 50

  More actions

  January 28, 2010 at 4:13 am

  #137618

  Hi to everybody,

  I've a problem that come out after changed ADODB provider from MSDASQL to SQLOLEDB.

  I need to lock one row of ORDERS table to avoid other users access into the modify form.

  I use a lock in this way:

  SQL = "SELECT codice_ente, numero_ordine_emesso " _

  & "FROM FODCORDI_TESTATA_ORDINI_ACQ " _

  & "WITH (ROWLOCK) " _

  & "WHERE Numero_Ordine_Emesso=" & NumOrdine & " AND " _

  & "Codice_Ente='" & idEnte & "'"

  Set rsADO_Blocco = New ADODB.Recordset

  rsADO_Blocco.Open SeQeL, frmLogin.cnnAdo, adOpenStatic, adLockPessimistic

  After some code, I need to create a temp table using:

  frmlogin.cnnAdo.execute "select * into #CICCIO from div_enti", ret

  but the table is not created! The execute method does'nt raise error and RET variable return the correct record number value.

  If I skip the lock code, the creation of temp table working successfull!

  How can I solve this problem?

  TIA,

  Carlo P.

  PS: sorry for my english!

• carlo.puglisi

  Valued Member

  Points: 50

  More actions

  January 28, 2010 at 9:02 am

  #1110131

  I solved opening a new ADODB.Connection only to manage the lock sql.

  Thank you,

  Carlo