ADO.Net bug

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Gani Pola
    #1

    ADO.Net bug

    I try to update a table with 106 fields using the Dataset and get an error
    on "Expression too complex....".

    If I try insert, it works, only update fails. This happens in my ASP.NET
    app. using ADO.NET. The same update using VB6 and ADO works.

    Can someone please help? It appears there's a bug in ADO.NET when updating a
    table with a lot of fields.

    TIA
    GP


    Tags: None
    • William Ryan
      #2
      Re: ADO.Net bug

      Can you show the update command? Does it work with say 50 records?
      "Gani Pola" <ganipola@pcida ta.net> wrote in message
      news:Twwcb.1221 75$bo1.47991@ne ws-server.bigpond. net.au...[color=blue]
      > I try to update a table with 106 fields using the Dataset and get an error
      > on "Expression too complex....".
      >
      > If I try insert, it works, only update fails. This happens in my ASP.NET
      > app. using ADO.NET. The same update using VB6 and ADO works.
      >
      > Can someone please help? It appears there's a bug in ADO.NET when updating[/color]
      a[color=blue]
      > table with a lot of fields.
      >
      > TIA
      > GP
      >
      >[/color]


        Comment

        • Gani Pola
          #3
          Re: ADO.Net bug

          Hi William,

          Thanks for your reply.

          It does not even work with 1 record - it is not the number of record but
          cause by the table containing over 100 fields.

          Rgds
          GP


          "William Ryan" <dotnetguru@com cast.nospam.net > wrote in message
          news:Ogi44L3gDH A.2300@TK2MSFTN GP10.phx.gbl...[color=blue]
          > Can you show the update command? Does it work with say 50 records?
          > "Gani Pola" <ganipola@pcida ta.net> wrote in message
          > news:Twwcb.1221 75$bo1.47991@ne ws-server.bigpond. net.au...[color=green]
          > > I try to update a table with 106 fields using the Dataset and get an[/color][/color]
          error[color=blue][color=green]
          > > on "Expression too complex....".
          > >
          > > If I try insert, it works, only update fails. This happens in my ASP.NET
          > > app. using ADO.NET. The same update using VB6 and ADO works.
          > >
          > > Can someone please help? It appears there's a bug in ADO.NET when[/color][/color]
          updating[color=blue]
          > a[color=green]
          > > table with a lot of fields.
          > >
          > > TIA
          > > GP
          > >
          > >[/color]
          >
          >[/color]


            Comment

            Previous template Next
            Working...