Query builder & domain fields

rbuser

use ReportExplorer and ReportDesigner with ZeosLib components to build
end-users reports in a PostgreSQL database.

When I try to build a query in Data Tab from ReportDesigner, the list of
available fields from a table not include fields of data type associated to
custom domain.

Example:

CREATE DOMAIN zip_code_type AS VARCHAR(6) NOT NULL;
CREATE TABLE states (id INT4, name VARCHAR(100), zip_code ZIP_CODE_TYPE);

Only fields id and name are listed as available fields to be included in
query results.
Thanks


Fernando L. Garetto
Desarrollo
FULFILL TECHNOLOGY S. A.
27 de Abril 424 3ro. A
X5000AEJ - C?RDOBA - RA
TE: 54 351 4283419
http://www.fulfill-tech.com

nardmoseley

Try using the Delphi debugger to trace the source code to the DADE plug-in
that you are using for ZeosLib. Trace the methods for SetDataName ,
GetFieldsForSQL and GetFieldNamesForSQL.



--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com