Riskmanager
Posts: 4
|
| Posted: 08/27/2004, 3:27 AM |
|
Dear All,
Brand new user of CodeCharge Studio in conjunction with PostgreSQL, I am currently experiencing a few problems for which a little help would be appreciated.
1. the use of uppercase in table /field names triggers a relation xxx not found problem. The problem is not related to Codecharge but apparently to PostgreSQL as I experience the same problem using the SQL order in PGADMIN. Solution consist in encapsulating the table or field names in quotes but I do not know how to get it done automatically by CodeCharge Studio.
2. my tables are organised in various schema. Although defining the schema in the connection, the code generated does not include the schema name as a prefix to the table, with the same result than in (1). Problem is the same using the generated SQL in PGADMIN.
Should anybody have a detailed howto procedure to use PostgreSQL with CodeCharge Studio, or a workable solution, his/her help would be greatly appreciated.
Best regards.
Constant Depièreux
_________________
Constant Depièreux
Managing Director
Applied Quality Technologies Europe sprl
http://www.aqte.be
|
 |
 |
Riskmanager
Posts: 4
|
| Posted: 08/29/2004, 9:17 PM |
|
I worked around the problems :
1. by avoiding any uppercase in table or field name. Surely not the best solution, but it works.
2. by creating the same tables in two differents schema. Codecharge resolves the potential conflict by providing the schema reference in front of the table name. Not elegant at all, but it works.
Best regards.
_________________
Constant Depièreux
Managing Director
Applied Quality Technologies Europe sprl
http://www.aqte.be
|
|
|
|
|
