BASE macro using INSERT SQL fails to find table

[salisbury150]

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

[elmau]

sql = "INSERT INTO ""Table1"" (""TestName"") VALUES('Test One');" 

[salisbury150]

@elmau, That seems to have worked. Thank you very much.