Subject Re: Using Field Named DATE in Where clause From Maurizio S. <mau@mau.it> Date Wed, 14 Feb 2024 14:07:43 +0100 Newsgroups dbase.getting-started ooopps ,my fault select field1, field2 from MYDATA where mydata.DATE > :pDate order by DUEDATE, CUSTOMER Il 14/02/24 13:47, Maurizio S. ha scritto: > > > assume your table is MYDATA > > untested ! > query1.sql = 'select field1, field2 where mydata.DATE > :pDate from > MYDATA order by DUEDATE, CUSTOMER' > > query1.params['pDate'] = null > query1.active = false // keep closed > > then, when you need to get filter, just do: > > yourFilter = currentDate() - 30 > > query1.params['pDate'] = yourFilter > query1.requery() >