FiveTech Software tech support forums • View topic - ADO filtering

ADO filtering

4 posts • Page 1 of 1

ADO filtering

by joseluispalma » Thu Dec 24, 2020 9:21 am

Hello friends,

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

Code: Select all Expand view: cFilter := "HIREDATE >= FW_ValToSQL(DATE())" oRs:Filter := cFilter

What am I doing wrong?

Thank you and a greeting

joseluispalma: Posts: 109; Joined: Mon Apr 30, 2012 9:10 am

Re: ADO filtering

by joseluispalma » Thu Dec 24, 2020 10:10 am

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

joseluispalma: Posts: 109; Joined: Mon Apr 30, 2012 9:10 am

Re: ADO filtering

by anserkk » Thu Dec 24, 2020 11:09 am

What about

Code: Select all Expand view: cFilter := "HIREDATE >= "+FW_ValToSQL( DATE() ) oRs:Filter := cFilter

anserkk: Posts: 1332; Joined: Fri Jun 13, 2008 11:04 am; Location: Kochi, India

Re: ADO filtering

by joseluispalma » Thu Dec 24, 2020 11:24 am

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

joseluispalma: Posts: 109; Joined: Mon Apr 30, 2012 9:10 am

4 posts • Page 1 of 1

Return to FiveWin for Harbour/xHarbour

Jump to:

Who is online

Users browsing this forum: Google [Bot] and 42 guests