AddNew Fails when too many fields are added

From: baskar (cbaskara_at_yahoo.co.in)
Date: 10/29/04

  • Next message: NIL: "RE: How to Write into Excel" 
    Date: 28 Oct 2004 17:45:46 -0700

    Hi,

    I have a table with 90 fields. When I try to use the recordset with
    addnew and set all the 90 fields and then update the record set it
    fails the following error seen in the log,

    [IBM][CLI Driver][DB2] SQL0117N The number of values assigned is not
    the same as the number of specified or implied columns.
    SQLSTATE=42802

    But I'm able to set 40 fields and insert the record successfully. But
    I'm able to update the table with all the 90 fields.

    Is there any restriction with the recordset to insert maximum number
    of fields or problem with the database (Using DB2 on Mainframes)

    Can some one help me?

    Thanks in Advance !

    -Baskar

  • Next message: NIL: "RE: How to Write into Excel"

    Relevant Pages

    • Re: Add records to tdfNew as TableDef
      ... but I have yet to see how to add data to that table from a recordset. ... selected fields, and have created tdfNew, appended to the database, and added ... I have manually created the temporary table in the database ... The problem is that as soon as I type the period where the AddNew should be ...
      (microsoft.public.access.modulesdaovba)
    • AddNew()
      ... How can I get the ID of a new row in my MSDE? ... I used the AddNew() - Method of the ... RecordSet. ... Prev by Date: ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Timeouts (80040E31) on AddNew
      ... > combination of LockType, CursorType and CursorLocation (and believe me, I've ... to guarantee that an empty recordset will be returned. ... using AddNew isn't generally as quick and clean ... as using SQL INSERT, but it is fairly straightforward and avoids certain ...
      (microsoft.public.inetserver.asp.db)
    • Re: The current recordset does not support updating.
      ... RAHokie wrote: ... I get run time error 3251: ... > is the problem in the use of AddNew? ... What kind of RecordSet did you create? ...
      (microsoft.public.access.modulesdaovba)
    • Re: Is it possible to determine the record ID when using INSERT INTO?
      ... AutoNumber of a newly inserted record: AddNew, set the value of each of the ... Recordset. ... Recordset to read the value of the AutoNumber column. ...
      (comp.databases.ms-access)