General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only