Maximum length of SQL statement

Posted by Vincent on July 20, 2004

Hi everyone. Does anyone know of a way to overcome the 4095 character (4K) limit of a SQL statement? I need to code a very long SQL statement, using a TQuery component, adding lines by means of query1.SQL.Add(). I am thinking that this may be a BDE limitation. Any suggestions would be appreciated.