Mysql Component

[thaimann]

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]

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]

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

Terry

[matthijs]

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]

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]

Never mind I think I have it figured out.