I wan to make a select query with more than 255 characters but i get error.
Error: Constant strings can't be longer than 255 chars
How can solve this?
I'm running Windows 7 Ultimate 32-bit, Lazarus 0.9.30, FPC 2.4.4, Zeoslib 6.6.6, Firebird 2.1.3.
Here is a part from my code:
Code: Select all
frmsetting.qryList.SQL.Add('select n_client as "Client Name", phone_no as "Phone No.", address as "Address", ...... , from tb_client where ID_CLIENT='''+select_idM+''' ');