-1

hello please help me on this i am confuse, if i will use this

sql = "select * from item_table where itmno = '" & m_item & "'" 
Set item_rs = con.Execute(sql)


'do i still need to  use this

With cmd

 .ActiveConnection = con
 .CommandText = "item_table"
 .CommandType = adCmdTable
 
 End With
 
 
With mch_rs

  .CursorLocation = adUseClient
  .CursorType = adOpenDynamic
  .LockType = adLockPessimistic
  .Open cmd
  
End With

hoping for your positive responds...thanks in advance

Edited by jemz: n/a

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by vb5prgrmr
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.