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
Default

you need a lot of changes .. if you want to open a table and then use it you can use (in ADODB connection) -
Code:
Dim rec_item As New adodb.Recordset
...
rec_item.open ("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
Code:
db.Execute "UPDATE item_main SET item_quan = item_quan   _
+ " & added_item & " WHERE item_no = " & cur_ino
you can ,however, use -
Code:
recordsetname.Add
recordsetname.Update
if you are using recordset ..
(NOTE : _ (underscore) is used to change line in VB)


Reply With Quote