Hi, I am using libo BASE to connect to Postgresql.
The code must be sent directly and not be interpreted by Libo Base.
But, postgresql can not understand passing parameters with either ? or : syntax
eg: select * from agenda where name= ?
In this case the code fails with postgresql server.
What are solutions ? cant libo catch one part part of the code just to ask me parameters and bypass other parts?
Hello,
Since you bypass the interpreter and the SQL is direct to the database, there is not prompt unless the database provides one.
An alternative is to process a prepared statement in a macro. An example can be found here → Prepared Statement Question Mark within WHERE LIKE ‘%?%’. The answer refers to MySQL DB but just tested PostgreSQL with a different SQL statement (form my table/fields) and had no problem. Can add input box so user can enter a value to be selected.
There are possibly other ways to accomplish something but you have not specified how this is to be used.
Thank you. I am learning this macro now
I posted 2 other questions if you could make answer:
BASE table list, How to display only tables, no other structures
BASE importation error, How to cancel all process without asking user
Please use a comment or edit your question.