Alvaro Cobo
|
| Posted: 06/15/2007, 9:54 AM |
|
Hi. I am trying to create a form using record builder, against a
database in Postgresql which is designed in several schemas to organize
diffirent kinds of information. The problem is that codecharge studio
doesn't recognizes the diferents schemas in the table (for example,
schema1.table1). It just recognizes the plain table names. The problem
is that when I select a table which is in a schema diferent than public,
it doesn't appears any field to use in the builder.
I have read a previous very old post (2004/08/29) where the problem is
solved creating similar table names in all the schemas, but it doesn't
work for me.
I am using POstgresql 8.2.2 with the Postgis extension. The latest ODBC
connector, under Windows XP SP1.
Two questions:
1. Is this a Postgresql configuration problem or CCS bug?.
2. Does anybody could be so gentle to give a tip to solve this problem
(because I wouldn't like to change the whole database design).
Thanks a lot and best regards.
Thanks a lot and best regards.
Alvaro
|
|
|
 |
Damian Hupfeld
|
| Posted: 06/15/2007, 3:43 PM |
|
I *think* I have seen a similar post and the answer was that CCS can only
use what info the ODBC can supply.... If the ODBC can supply schema info
then CCS can use it? Something like that anyway...
"Alvaro Cobo" <cobo_alvaro@yahoo.com> wrote in message
news:f4ug8v$dco$1@news.codecharge.com...
> Hi. I am trying to create a form using record builder, against a
> database in Postgresql which is designed in several schemas to organize
> diffirent kinds of information. The problem is that codecharge studio
> doesn't recognizes the diferents schemas in the table (for example,
> schema1.table1). It just recognizes the plain table names. The problem
> is that when I select a table which is in a schema diferent than public,
> it doesn't appears any field to use in the builder.
>
> I have read a previous very old post (2004/08/29) where the problem is
> solved creating similar table names in all the schemas, but it doesn't
> work for me.
>
> I am using POstgresql 8.2.2 with the Postgis extension. The latest ODBC
> connector, under Windows XP SP1.
>
> Two questions:
>
> 1. Is this a Postgresql configuration problem or CCS bug?.
> 2. Does anybody could be so gentle to give a tip to solve this problem
> (because I wouldn't like to change the whole database design).
>
> Thanks a lot and best regards.
>
> Thanks a lot and best regards.
>
> Alvaro
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 06/15/2007, 3:45 PM |
|
Alvaro Cobo
Have you contacted support ( http://support.yessoftware.com ) or the person who answered the old post?? I would definite try to contact support because they should be able to resolve your issue.
|
 |
|
Alvaro Cobo
|
| Posted: 06/16/2007, 2:33 PM |
|
Thanks guys:
I have contacted the support service, and the answer is that ant the
moment there is not support to postgresql, and the solution is to add
the schema name to the table name in the Data Source field.
Thanks a lot.
Alvaro.
Following the response from support for future references.
/*
Hello Alvaro,
Thank you for contacting us.
For the time being, CCS doesn't support PostgreSQL schema.
Developers reported that it is on our plans to add a schemas support,
but estimated time is not determined yet.
In the meantime you can try to type in the schema name before a table
name directly in Data Source field, so you’ll get fields from that table
and schema is generated in the page’s code.
Best regards,
Kate.
*/
mamboBROWN escribió:
> Alvaro Cobo
> Have you contacted support ( http://support.yessoftware.com ) or the person who
> answered the old post?? I would definite try to contact support because they
> should be able to resolve your issue.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|
Alvaro Cobo
|
| Posted: 07/27/2007, 12:22 PM |
|
Hi guys:
I think the problem with the tables and schemas in postgresql has been
solved using the following ODBC driver.
https://projects.commandprompt.com/public/odbcng/wiki/Downloads
I have not fully tested it, but at the moment it seems to work.
Best regards,
Alvaro
Alvaro Cobo escribió:
> Thanks guys:
>
> I have contacted the support service, and the answer is that ant the
> moment there is not support to postgresql, and the solution is to add
> the schema name to the table name in the Data Source field.
>
> Thanks a lot.
>
> Alvaro.
>
> Following the response from support for future references.
> /*
> Hello Alvaro,
> Thank you for contacting us.
>
> For the time being, CCS doesn't support PostgreSQL schema.
> Developers reported that it is on our plans to add a schemas support,
> but estimated time is not determined yet.
> In the meantime you can try to type in the schema name before a table
> name directly in Data Source field, so you’ll get fields from that table
> and schema is generated in the page’s code.
>
> Best regards,
> Kate.
> */
> mamboBROWN escribió:
>> Alvaro Cobo
>> Have you contacted support ( http://support.yessoftware.com ) or the person who
>> answered the old post?? I would definite try to contact support because they
>> should be able to resolve your issue.
>> ---------------------------------------
>> Sent from YesSoftware forum
>> http://forums.yessoftware.com/
>>
|
|
|
|
|
