Member Avatar for jemz

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 because: n/a
  • 2 Contributors
  • 1 Reply
  • 125 Views
  • 16 Hours Discussion Span
  • Latest Post Latest Post by vb5prgrmr
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.