Further to the previous messages. I`ve now got it working fine with SQLEXEC, but the next problem is the following and has to do with inserting records.

It doesn`t like it when I try to insert fields or use a macro substitution, variable or something, e.g.

=SQL(myconnhandle,"INSERT INTO tabletoupdate (id) VALUES (mytable.id)")

doesn`t work.

However, when I do this, e.g.:

=SQL(myconnhandle,"INSERT INTO tabletoupdate (id) VALUES (2)")

it works fine.

Any ideas? Thanks.