Subject Re: SQL Query Front End
From Dan Bernard <dbernard@dicarlofood.com>
Date Thu, 14 Feb 2019 10:08:59 -0500
Newsgroups dbase.getting-started

Mervyn Bick Wrote:

> 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.

Dan