As I was fighting with form filter this saturday half a day maybe it could be
helpfull for someone else who work with PostgreSQL SDBC driver and OpenOffice
base.
I tried everything possible but without succes. At the end I found it.
If I want to filter data in Form according to field date_of_sample in my table
I can use only PostgreSQL to_char(date) function.
REM Get the day you want to see
sDate = InputBox("Day - DDMMYYYY")
oForm.ApplyFilter=true
oForm.Filter="to_char(`date_of_sample`,'DDMMYYYY') = "+"'"+sDate+"'"
oForm.reload
juraj
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
