topic-39783

Posts: 109

Joined: Mon Apr 30, 2012 09:10 AM

ADO filtering
Posted: Thu Dec 24, 2020 09:21 AM

Hello friends,

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

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

What am I doing wrong?

Thank you and a greeting

Posts: 109

Joined: Mon Apr 30, 2012 09:10 AM

Re: ADO filtering
Posted: Thu Dec 24, 2020 10:10 AM

I save the filter expresion in a field of the report´s table.

Posts: 1335

Joined: Fri Jun 13, 2008 11:04 AM

Re: ADO filtering
Posted: Thu Dec 24, 2020 11:09 AM

What about

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

Posts: 109

Joined: Mon Apr 30, 2012 09:10 AM

Re: ADO filtering
Posted: Thu Dec 24, 2020 11:24 AM

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

FiveTech Support Forums