Hello,
I am in the process of learning how to build applications with
Lazarus. The goal is to
rewrite some text-mode applications in Lazarus, so that they have a GUI .
Unfortunately, building data-aware forms proved to be quite difficult so far.
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.
As you can see, there are many problems that frustrating and not easy
to be solved by
a newbie.
I'm not sure whether the problem is only my lack of knowledge, or the
support for
PostgreSQL is simply not mature enough. I suspect that working with Firebird is
better supported, because i have noticed that people around here tend
to use firebird.
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) .
I'm not sure at all that the problem is sqldb ; maybe the
combination postgres+sqldb+lcl
is not tested enough yet. What is its exact status?
Or maybe there are small tricks that are evident for the experienced
developers.
Best wishes,
Adrian Maier
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
