inserting into oracle from vb
Posted on 2003-10-31
Please help, i am having a problem in execting some queries of Oracle
actually i have connected with an Oracle 8 table via DSN. the
connection gets established and i can succefully execute Select query.
i can move into record set object also.
BUT i can execute Insert Into.. , Delete from..., Update... commands. i
think those queris which do not retun any recordset are not running i
was trying to run it using :-
set cmd=new adodb.command
cmd.execute "Insert into login values('a','b')"
msgbox("Recrod Inserted !!")
my program displyas the msgbox but when i enquire from Oracle, it does
not show the newly inserted record.
Is there any need to set any particular properties of conn object or of
cmd object for this.
Please help and oblige