VB 6-->Oracle 8i database Problem

i am using data form wizard to create the data form for my oracle 8i personal edition database.

the below are the steps of that, how i am doing.

In VB6,
1. from Add-in -> VB 6 data form wizard
2. step by step i am giving the following details
i have made a DSN myORA from Oracle ODBC Driver.

RECORDSOURCE=dept (with all columns)

The form gets build successfully.
It runs successfully,shows existing records correctly,
BUT avoids new insertion,updation.
for ADD NEW button i am writing folliwing code.

where, rs is recordset
for UPDATE button i am writing following code.


where rs is recordset.
when i press update button it shows the following ERROR :-

Method 'Update' of object '_Recordset' failed

i have tried 'Update', 'UpdateBatch' but vain.

Please help me................
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!