ADO filtering

Post Reply
joseluispalma
Posts: 93
Joined: Mon Apr 30, 2012 9:10 am

ADO filtering

Post by joseluispalma »

Hello friends,

I need to perform a filter in ADO using a date, and it gives me an error:

Code: Select all


   cFilter := "HIREDATE >= FW_ValToSQL(DATE())"
   oRs:Filter := cFilter


 
What am I doing wrong?

Thank you and a greeting
joseluispalma
Posts: 93
Joined: Mon Apr 30, 2012 9:10 am

Re: ADO filtering

Post by joseluispalma »

I save the filter expresion in a field of the report´s table.
User avatar
anserkk
Posts: 1280
Joined: Fri Jun 13, 2008 11:04 am
Location: Kochi, India

Re: ADO filtering

Post by anserkk »

What about

Code: Select all

cFilter := "HIREDATE >= "+FW_ValToSQL( DATE() )
oRs:Filter := cFilter
joseluispalma
Posts: 93
Joined: Mon Apr 30, 2012 9:10 am

Re: ADO filtering

Post by joseluispalma »

Thank you, that works, but I need to store the full filter in a database.
Post Reply