On Mon, 2006-10-09 at 14:05 +0300, Adrian Maier wrote:
> I have a form that includes: a TdbGrid and a TdbNavigator. I want to
> use the same
> form to acces any of three different tables, by specifying one sql
> query or another.
> - deleting rows doesn't work for any of the tables. The user is asked
> to confirm, but
> the row is not deleted.
> - updating works , for the tables that have a simple primary key
> - for the table that has a 3-column primary key, i have been able to
> specify a custom
> sql command . The update reaches the database, but the transaction
> is no longer
> committed. The same "save" button commits the data for the other
> tables, though.
Are you sure all queries has the same transaction?
> I'm not sure whether the problem is only my lack of knowledge, or the
> support for
> PostgreSQL is simply not mature enough.
I would guess it's both.
> I suspect that working with Firebird is
> better supported, because i have noticed that people around here tend
> to use firebird.
The problem that you encountered so far, weren't postgres-related. So
switching to fb won't help much.
> So, i have several questions:
> a. Are there Lazarus users who have positive experience with
> developing data-aware
> applications using sqldb to access PostgreSQL?
>
> b. Are there any better solutions (except sqldb) to access PostgreSQL?
> It is hard to
> find documentation about sqldb, except from the source code and a set
> of examples.
>
> c. What is the approach that I should follow : should I consider
> dealing with the database
> manually? Simply associating a TdbGrid with a TsqlQuery is far from
> working out-of-the-box
> (at least with sqldb and postgres) .
Just submit bug-reports. There are so many things you can do with the
database-utils, it's impossible to check them all. For some it will work
out-of-the-box, for others it oculd be somewhat more difficult.
Multiple-fields-primary keys, for example, I consider as a bad design.
(I can imagine some exceptions, but those are really rare) Must db-
programmers won't use them, so for them it works 'out-of-the-box'...
Just submit bug reports if you found them, and ask here for help. That's
probably the best you can do, and the best for fpc/lazarus.
Joost
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
