I have a strange problem with the method TDatabase.Execute.
When I pass a string constant, it works:
sql := 'INSERT INTO table (field1,field2) VALUES (1,'Test')';
But as soon as I build the string out of other strings, it crashes:
sql := 'INSERT INTO table (field1,field2) VALUES (' + sf1 + ',''' + sf2 +
I get an exception:
access violation in module IDAPI32.DLL, reading from 0000000B.
What can I do about this?
Thank you very much,
PS: the database system is PostgreSQL