Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: delphi exception with ADQuery1.SQL.Text long
delphi exception with ADQuery1.SQL.Text long
Posted: 2007/09/07 09:54
 
yes I am getting a repeatable EAccessViolation exception trying to assign an INSERT statement to the SQL.Text property of your component.

The INSERT is using a Memo field that is 1334 bytes long, plus other data that is making the overall INSERT string around 1500 characters long.

Is there a limit on how large the SQL.Text property can handle?

Thanks
- mark
Re:delphi exception with ADQuery1.SQL.Text long
Posted: 2007/09/07 11:19
 
Hello

No, there is no limit. Could you please provide info about yours:
- SQL text;
- DBMS;
- parameter values.

Regards,
Dmitry