Daniel Käfer wrote:
Hello,

I use a postgres database and try to make a query with a (PLPG) SQL function in OOo Base. This query needs two parameters: begin_date and end_date.

SELECT * FROM f_termine_report( '{1010131}', :begin_date, :end_date ,true, true, true, true)

try this

With a query def in SQL view and escape processing disabled (SQL Direct) perhaps this syntax:

CALL f_termine_report( '{1010131}', :begin_date, :end_date ,true, true, true, true)


I Can't say for sure that will work, but I would not be surprised if it did.

Drew

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Reply via email to