Re: [libreoffice-users] Basic Macros with Base

2023-01-25 Thread Robert Großkopf
Hi Harvey, how would this work for me, where I only want to create a SQL statement as a string and execute it. Mcro works with SQL-code, which has been saved in a field of a table. Field in the table is called "SQL-Code". Table is datasource of a form. A button in this form will start the

Re: [libreoffice-users] Basic Macros with Base

2023-01-25 Thread Harvey Nimmo
Hi Robert, how would this work for me, where I only want to create a SQL statement as a string and execute it. Can it be that the string is not recognised as SQL? (In my MSAccess days it worked). Here the run-time error indicates that the "Object variable is not set" although it is valid SQL text