I connected an odb file to mariadb server via ODBC.
now I need to run some action queries via macro.
When I create a query in designview the following SQL is created:
SELECT ID, img_blob FROM table.lnk_img AS lnk_img
Query works fine, but when I want to run the SELECT statement in Tools > SQL… Base will crash with unexpected error… probable something wrong with syntax I guess.
I also tried this format
SELECT “ID”, “img_blob” FROM “table”." lnk_img" AS “lnk_img” which causes a crash.
how to format SQL statements in a query?