¿saber si una fecha o mas estan dentro de un rango de fechas?

[[Caral]]

Hola
Que es el Firebird Maestro?.
Saludos

[JXJ]

http://www.sqlmaestro.com/products/firebird/maestro/

es como el ibmanager.

Firebird Maestro is the premier Firebird admin tool for database management, control and development. Key features include:

* Support for all Firebird versions from 1.0 to 2.5
* Easy database object management
* Database Designer
* Data management: editing, grouping, sorting and filtering abilities
* Comfortable access to Firebird security features
* Handy SQL Editor with code folding and multi-threading
* Visual Query Builder with support for subqueries and UNIONS
* Working with remote Firebird servers via SSH tunnel
* Data export/import to/from the most popular formats
* Powerful BLOB Viewer/Editor

The application also provides you with a powerful set of tools to manage Firebird users and roles, edit and execute SQL scripts, build visual diagrams for numeric data, compose OLAP cubes, and much more.

With all these features our software will be an everyday assistant in your work with Firebird database server.

[[Caral]]

Hola
Ahh, creo que lo he visto.
El que uso es IBExpert que me parece muy sencillo y bueno para firebird.
Saludos
PD: Ademas es el que me recomendó mi Maestro Casimiro Notevi

[JXJ]

puese un query

Código Delphi [-]

var
fechadevueltaS :String;

with SQLQuery1 do
begin
close;
 SQL.Clear;
            SQL.Add('Select  TABLA.FECHA,  TABLA.TIPO FROM TABLA WHERE TIPO = 'X' AND  Fecha  BETWEEN  '07/10/2010' and '08/07/2010' ');
Open;
 while (not Eof) do
         begin

             fechadevueltaS :=(fieldbyname('fecha').AsString);
            Next;
         end;
   end;

[[Caral]]

Hola
No entiendo para que tanta cosa?.
Saludos

[[Caral]]

Hola
Me explico:
1-Una variable string para sacar un dato date.
2-Unas fechas especificas sin poder cambiarlas.
3-Recorrer la tabla, para que?.
4-Uso de Add (me molesta).
Saludos

[[Caral]]

Hola
Yo lo haría así:

Código Delphi [-]
var
fechadevueltaS ate;
with SQLQuery1 do
begin
SQL.Text:= 'Select  TABLA.FECHA, TABLA.TIPO FROM TABLA WHERE TIPO = :a AND  Fecha >= :Fech1 AND Fecha <= :fech2 ';
Params[0].Value:= 'X';
Params[1].Value:= DateToStr(DTP1.Date);
Params[2].Value:= DateToStr(DTP2.Date);
Open;
fechadevueltaS := fieldbyname('fecha').AsDate;

end;
end;

Saludos

[JXJ]

hoooo..

nunca se me hubiera ocurrido hacerlo asi caral