ADO help required

[apbarshikar]

Hi,
I am facing a small problem with ADO
I have created the following recordset

SELECT empid_em as EmpID,divcode_em,wrkshpcode_em,wrkcntrcode_em,actualcode_em,ticketno_em as TicketNo, empname_em as EmpName, 1 as AvailMins,2 as IsActAlloted FROM EMPMASTER WHERE 1=2 rsEmployee.Open strQuery, dbConn, adOpenStatic, adLockBatchOptimistic

in the above recordset AvailMins and IsActAlloted columns are not available in the database, but I required them so i created Dummy Columns.

Now in a loop I assign values to AvailMins and IsActAlloted fields, using Addnew and Update method. With Oracle 8i everything works fine, but when I use the same thing with MS Access or Personal Oracle it gives an error saying
"Multiple-step operation generated errors. Check each status value."

Why is this error comming and I am not able to solve the problem.
If possible explain the problem.


Amol

[goatsucker]

Are you trying to add new fields to the table? If so you may be better using creating a table object in ADOX and adding a column to it. There is an example here

[apbarshikar]

i am creating a disconnected recordset. no columns are ben been added to the table.

[vbcodec]

Hi mite
have you named the column 1 and 2 ? I don't think thats right to name it like that , you should start by alphabetical words

hope it helps.
S. Mohammad Najafi