[Gambas-user] Can't access PostreSQL schemas

[José Luis Castro]

Hi Benoît. Thanks for your kind answer.

I must say, however, the database was created and it's maintained using the
application "PGAdmin", so I can say with absolute security that the table
I'm trying to acces has been created, in fact, with a primary key. Also I
ran a lot of queries from PGAdmin and everything works just fine; so a
priori I think the database and tables are well designed.
On the other hand, I tried to access from Gambas 2.16, another table of the
same database, but a one that is not into the schema (for instance, has the
same sctructure, keys and indexes) and works fine when using the Edit()
method. That's the reason I think this is a problem with schemas.

Regards,

José Luis



2009/9/25 Benoît Minisini <gambas at ...1...>

> > Hi. I've created a schema in a PostreSQL database. The sintax for
> accessing
> > data from the schema is: schema.tableName
> > That works fine when trying with .exec method (i.e. "SELECT * FROM
> > schema.tableName" or "INSERT INTO schema.tableName VALUES..."), but it
> > doesn't work when I try to use the .edit method
> >
> > I'm using Gambas 2.16 and PostreSQL 8.5
> >
> > If anyone can help me with this (maybe just telling me where to get the
> > answer for this question, probably already answered) i'll apreciatte it.
> >
> > JOSÉ L. CASTRO
>
> You can only use the Edit() on tables having a primary index. In that case,
> you should better create your database with the database manager, to be
> sure
> things work as expected.
>
> See: http://gambasdoc.org/help/comp/gb.db
>
> Regards,
>
> --
> Benoît Minisini
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry® Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9-12, 2009. Register now!
> http://p.sf.net/sfu/devconf
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>