Mysql Component
lazarus / 16-Databases

----------------------------------------------------------------------
thaimann · 2005-05-11 02:44

I haven't been able to find any documentation on using this
library($LazDir/components/mysql.)  All I really need at this point is
the parmlist (for ExecSQL) and any requirements for its use(variable
declarationand setup.)  An example would be real nice to.

Terry

----------------------------------------------------------------------
matthijs · 2005-05-11 06:10

ExecSQL does not have a parmlist. Just make sure your Query-component
is connected to a connection and has a SQL-property which contains an
executable SQL command. The example I gave in the mailinglist by using
slqdb-components should work equally well with MySQL component.

----------------------------------------------------------------------
thaimann · 2005-05-11 23:50

I don't think I have a query component.  What do I have to install
inorder to create one?

Terry

----------------------------------------------------------------------
matthijs · 2005-05-12 06:19

Have a look at the sample projects on the wiki and read the database
and the Install Packages tutorial.

[edit]Or rather the other way around, first read the tutorials then
look at the samples.

----------------------------------------------------------------------
thaimann · 2005-05-12 16:40

OK, I  have installed the sqldb package.  Now I have placed a
TSQLQuery component on my form.  But when I try to point it to my
database component, I get the following error message:

Invalid Type Cast

Terry

----------------------------------------------------------------------
thaimann · 2005-05-12 20:08

Never mind I think I have it figured out.