Scott Price
> Sent: 07 August 2006 17:14
> To: Moderated discussion list about database programming with Borland's
> Delphi
> Subject: Re: Multiple query
>
> Hi Chris,
>
>
> Yes, normally most Relational Databases which are things like Interbase,
> Firebird, SQL,
t: 07 August 2006 17:14
To: Moderated discussion list about database programming with Borland's
Delphi
Subject: Re: Multiple query
Hi Chris,
Yes, normally most Relational Databases which are things like Interbase,
Firebird, SQL, MySQL, etc call this type of thing a View. It isn't
somethi
similarly (but different), mysql lets you do:
(Select * from (Select * from openday where opendate > 21/06/06) where
day = 'mon')
there is a similar feature in postgre, but i forget the exact syntax.
the various engines differ in how the optimizers take advantage of the
available indexes to ma
> Date: Mon, 7 Aug 2006 13:36:11 +0100
> From: "Chris Moore" <[EMAIL PROTECTED]>
> Subject: Multiple query
> To: "DelphiDB List"
> Message-ID:
> <[EMAIL PROTECTED]>
> Content-Type: text/plain;charset="us-ascii"
>
> Hi Group
>
> In any RDBMS it is possible to build a query, and then use
> tha
Hi Chris,
Yes, normally most Relational Databases which are things like Interbase,
Firebird, SQL, MySQL, etc call this type of thing a View. It isn't
something you normally do in Delphi itself, although you may find you
are able to create the view from Delphi in one command, and then use
ano
You can do this simply using views in Sybase and MS SQL, probably others
too.
Create View open_d as Select * from openday where opendate > 21/06/06
go
select * from open_d where day = 'mon'
Within D7 you could do similar using datasets or ClientDataSets, then
filtering the results by setting Fil
