Apache OpenOffice Community Forum

Hi OpenOffice Community!

Please help, I have an *.odb file, with an ODBC connection to SQL Server.
I can create my own queries, and they run as they supposed to be, but if I want to use built-in functions, every single command gives me an error!

I have opened the error message, and it always contains something like the following:
->The SQL command leading to this error is
->SELECT * FROM "dbo.table_name"

I get this error, because the quotation marks' syntax are not correct.
It should be correctly without quotation marks, like: SELECT * FROM dbo.table_name.
Or, with the following quotation mark syntax, like: SELECT * FROM "dbo"."table_name".

Please help me to solve this issue.
Has anyone run into this?

Probably a built-in macro modification would solve it.

Best regards,
Peter

Open the query for editing and choose the menu Edit -> Run SQL Command Directly then run the query. Does it work?

I can create my own queries, and they run as they supposed to be, but if I want to use built-in functions, every single command gives me an error!

I don't see any function call in

b_peter_7 wrote: ↑Sun May 15, 2022 3:07 am SELECT * FROM "dbo"."table_name"

Simply create a simple query in design view or using the wizard in order to learn the correct Base syntax.

FJCC wrote: ↑Sun May 15, 2022 4:12 am Open the query for editing and choose the menu Edit -> Run SQL Command Directly then run the query. Does it work?

Yes, it works fine. Anyway I have changed ODBC connection types, and the select command works. Altough I still can not input any text into text field. When I create a Form with the wizard, It displays the data from a Query, but it does not display the data from a table. I get the following error, when I want to choose a db table:
"The field names from 'dbo.table1' could not be retreived".

Could you please help to figure out this issue?