View Single Post
  #2 (permalink)  
Old May 8th, 2006, 02:01 PM
manudutt manudutt is offline
Authorized User
Join Date: May 2006
Location: Bangalore, , India.
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to manudutt

you need a lot of changes .. if you want to open a table and then use it you can use (in ADODB connection) -
Dim rec_item As New adodb.Recordset
... ("SELECT * FROM item_main "), _
 connect, adOpenDynamic, adLockOptimistic
here connect is ADOBB connection.

if you want to update , delete any thing from table you can directly use SQL queries for that ,like
db.Execute "UPDATE item_main SET item_quan = item_quan   _
+ " & added_item & " WHERE item_no = " & cur_ino
you can ,however, use -
if you are using recordset ..
(NOTE : _ (underscore) is used to change line in VB)

Reply With Quote