the query designer is looking pretty good.... but I have some problems with it
there seems to be a 16 char limit on some of the strings... for instance... this code is generated by the query builder
SELECT
COMPANYMASTER."COMPANYCODE" AS COMPANYMASTER_CO,
COMPANYMASTER."COMPANY_NAME" AS COMPANYMASTER_CO
FROM
"my-db"."COMPANYMASTER" COMPANYMASTER
so that code doesnt work because of the identical aliases... i guess it should look like this
SELECT
COMPANYMASTER."COMPANYCODE" AS COMPANYMASTER_COMPANYCODE,
COMPANYMASTER."COMPANY_NAME" AS COMPANYMASTER_COMPANY_NAME
FROM
"my-db"."COMPANYMASTER" COMPANYMASTER
and ideally ( the root of my question actually ) i would like to be able to configure the querybuilder so that it does not prefix everything with the schemaname.tablename except in those cases where it is needed to prevent ambiguity... actually i would like the above query to just come out like this:
SELECT
COMPANYCODE,
COMPANY_NAME
FROM
COMPANYMASTER
maybe there are already some configuration options for this?
thanks
Steve Nell
