In case the parameter ':A' is not inserted, this code,
Code: Select all
SELECT * FROM "Mytable" WHERE ( "Age" = :A OR :A IS NULL )
- in LO it shows all the records
- in OO it shows one record empty
With what can I replace IS NULL in OO?
Thank you.
Code: Select all
SELECT * FROM "Mytable" WHERE ( "Age" = :A OR :A IS NULL )
Code: Select all
SELECT * FROM "Mytable" WHERE "Age" = :A OR :A is null
Code: Select all
SELECT * FROM "Mytable" WHERE "Age" = :A OR :A = ''
Code: Select all
SELECT * FROM "Mytable" WHERE "Age" = :A OR :A is null
Code: Select all
SELECT * FROM "Mytable" WHERE "Age" = :A OR :A is null
SELECT * FROM "Mytable" WHERE "Age" = :A OR :A =''
Code: Select all
SELECT * FROM "Mytable" WHERE "Age" = :A OR :A = ''
Code: Select all
SELECT * FROM "Mytable" WHERE "Age" = :A OR :A = 0
Code: Select all
SELECT * FROM "Mytable" WHERE "Age" = :A OR :A = 0
Code: Select all
=''
Code: Select all
WHERE "Date" = :A
Code: Select all
SELECT * FROM "Mytable" WHERE to_char("MyDateField", 'dd MM YY') = :DD_MM_YY or :DD_MM_YY = ''
Code: Select all
SELECT * FROM "Mytable" WHERE ("Day" >= :From OR :From IS NULL ) AND "Day" <= :To OR :To IS NULL)
Code: Select all
SELECT * FROM "Mytable" WHERE ("Day" >= :From OR :From ='' ) AND "Day" <= :To OR :To ='')
Code: Select all
select * from "Mytable"
where
(
to_char( "Day", 'YY MM dd' ) = :DateFrom_YY_MM_DD or :DateFrom_YY_MM_DD = ''
or
to_char( "Day", 'YY MM dd' ) = :DateTo_YY_MM_DD or :DateTo_YY_MM_DD = ''
)
or
to_char( "Day", 'YY MM dd' ) between :DateFrom_YY_MM_DD and :DateTo_YY_MM_DD
order by "Day"
Code: Select all
WHERE ( CAST( "Some_Field" AS CHAR ) = :x OR IFNULL( :x, '' ) = '' )
Code: Select all
WHERE ( CAST( "data" AS CHAR )between :DateFrom and :DateTo OR IFNULL(:DateFrom, '' ) = '' OR IFNULL(:DateTo, '' ) = '' )
Code: Select all
WHERE ("DateField" >= :FromDate OR :FromDate IS NULL)
AND ("DateField" >= :UntilDate OR :UntilDate IS NULL)
thanks for your help but your code seems doesn't work well after some tests .@chrisb
This is the solution that I looking for, thank you. It works well with my tests .kifaR wrote:for dates between certain values:Remember to enter the date parameters (:DateFrom and : DateTo) in the format 'YYYY-MM-DD'Code: Select all
WHERE ( CAST( "data" AS CHAR )between :DateFrom and :DateTo OR IFNULL(:DateFrom, '' ) = '' OR IFNULL(:DateTo, '' ) = '' )
I already used that code in LO, it works well, but not in OO. (A friend of mine asked me to use OO).@Villeroy