Can someone please help me on using a macro to run some INSERT SQL statements?
I’ve trying to load a table with some data and am using the requirement to learn a bit about writing macros to manipulate BASE tables.
I’ve created a test table - Table1. This table has two fields - an ID field which has autonumbering and is the primary key and a text field “TestName”. Please see item 1 in the attached picture.
While running a macro I can the error message “Table not found in statement [INSERT INTO Table1]”. Please see item 2 in the attached picture. You can also see a couple o arrows to show that I’m using the correct database and table name.
Item 3 in the picture is to show the LO installation.
Can anyone say why the “oStatement.executeUpdate(sSQL)” statement for ssql “INSERT INTO Table1 (TestName) VALUES (‘Test One’);” produces a “Table not found” error message?
Thanks