Basically!
I have a database with around 100 columns and when i go:
It fails after i edit the table, giving me an error:Code:Me.Validate() Adapter.Update(Table)
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,




Reply With Quote