Query builder & domain fields
I 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.
Thakns
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
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.
Thakns
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
This discussion has been closed.
Comments
Please do not cross post.
This question has been answered in the End-User newsgroup, although the DADE
newsgroup would be more appropriate.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com