Could you tell me the TClientDataSet in Bcb Filter properties limited length? I am in the process of using xe2/xe6 to assignment of the Filter of memory table, and then Filtered=true, when the Filter string length is more than about 8000 bytes, a memory error, what is this excuse me? Why seek along while data are not met?

Please don't ask me why want to filter such conditions for long, I know that by modifying the program can avoid this problem, but I just want to know why wrong, Embarcadero website also did not give a statement?

CodePudding user response:

Sometimes the driver have restrictions on length

CodePudding user response:

This related to database, Microsoft's remarks field has 8000 characters limit, more than part of the screen will go wrong, because the note field with ole content caused this phenomenon,

Binary field instead of note fields, the solution is to use binary field no ole inside,