Search results

Friends , I got my answer format of insert statement should be : con.Execute "insert into employee(no,join_date) values(424,'2004/9/12')" ie date should be given as 'yyyy/mm/dd' thanks DukeNukem for trying to help me

i use ADO in VB6 to connect to my Oracle database i made a connection object 'con' and opened the database using it when i executed the statement con.Execute "insert into employee(no,join_date) values(424,'12-SEP-2004')" i found that he new record was inserted into the database(i checked...