Very Computer

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')';
db.Execute(sql);

But as soon as I build the string out of other strings, it crashes:

sql := 'INSERT INTO table (field1,field2) VALUES (' + sf1 + ',''' + sf2 +
''')';
db.Execute(sql);

I get an exception:

access violation in module IDAPI32.DLL, reading from 0000000B.

What can I do about this?

Thank you very much,

Markus

Quote:> But as soon as I build the string out of other strings, it crashes:

> sql := 'INSERT INTO table (field1,field2) VALUES (' + sf1 + ',''' + sf2 +
> ''')';
> db.Execute(sql);

Hi

This is the way I solve the problem.
Since the TDatabase.Execute method expects a constant,
I did :

dc.Execute(sql+' ',Nil,False,Nil);   {  add an empty string }

Hope It works for you.