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