Results 1 to 7 of 7

Thread: [RESOLVED] Does Adapter.fill have a query length restriction?

Threaded View

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Mar 2007
    Posts
    200

    Resolved [RESOLVED] Does Adapter.fill have a query length restriction?

    Basically!

    I have a database with around 100 columns and when i go:

    Code:
    Me.Validate()
    Adapter.Update(Table)
    It fails after i edit the table, giving me an error:

    Syntax error (missing operator) in query expression '((ID = ?) AND ((? = 1 AND Record IS NULL) OR (Record = ?)) AND ((? = 1 AND Details_FileCreated IS NULL) OR (Details_FileCreated = ?)) AND ((? = 1 AND Details_Particulars IS NULL) OR (Details_Particulars = ?)) AND ((? = 1 AND Details_Date IS NULL) OR (Deta'.

    The code works fine with a smaller database, so i was just wondering the problem is that the database is too big and the adapter isn't able to handle such a long query.

    I was just wondering if anyone knows what kind of limits there are?

    Thanks,
    Last edited by Zapper; Apr 10th, 2010 at 04:20 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width