> On 2019-02-14 12:30 AM, Dan Bernard wrote:> > Is it possible to build a front end to a SQL query that would allow my users to enter variables, ie. a date range, and run a report? If so, are there examples?> > > > The short answer is yes. :-)> > In practice it probably depends on the SQL you will be using.> > If you have Firebird 2.5 installed I can give you example code.> > > I tried this using ADO in dBASE 12.3.1 but there is a bug which causes > the report to only show 1 record. Accessing the Firebird table via the > BDE with a normal query works just fine.> > It is quite possible that accessing a different SQL server using ADO > will work.> > Two screenprints are attached. The first shows a section of the report > for all records. The second shows records for date between 1990-01-01 > and 1990-12-31. I haven't ordered the records for the examples.> > Mervyn.> > >
Mervyn, thank you, this gives me some direction.