On Friday 14 April 2006 23:08, Jon Foster wrote:
> Are the SQL DB components supposed to be functional? I've tried using
> TMySQLConnection and TPQConnection with the associated TSQLTransaction
> and TSQLQuery attached through a datasource to a data grid.
>
> The TMySQLConnection always says, "Server connect failed" when I try to
> make a query active. When I set the connection's "Active" property to
> true in the designer everything is fine. The message only shows when I
> try to make a query, connected to the "active" connection, active.
>
> The TPQConnection almost works. It appeared I could add things by
> entering data in the columns and tabbing down. Then when I tried to move
> back up a row it dies with an "access violation". None of the records I
> entered ever hit the database.
>
> I've updated my Lazarus install via SVN today. The problems persist. I
> really would like to ditch Kylix/Delphi but I need functional DB access
> to either MySQL or PostgreSQL. I would prefer MySQL. Are there other
> components that would allow me to create data driven applications?
>
> THX - Jon
Yes it works.
First I suggest that you look at the FPC examples for how you should program
the SQLdb. You will notice that the components require a set order and
setup. Since all my programs require a login screen I set the required
fields in the "OnCreate" method of the form.
with pqconnection1 do
begin
UserName:=dbuser;
password:=dbpassword;
hostname:=dbserver;
databasename:=dbname;
connected:=True;
end;
Then you have to set the other controls as required. I have a some what long
blog "adventures of a newbie" on the wiki that might be of more help. Also
there is a MySQL tutorial.
John
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
