[SOLVED] Lazarus 0.9.30.2 MySQL 5.5.13 GRANT and REVOKE

[lazguy]

Hi All, here again !!!!!!

Is it possible to use the MySQL  SQL commands GRANT and REVOKE directly from my code ?

Please, how to do this ?

[BigChimp]

I suspect so. What have you tried up to now? What did go wrong and what error messages appeared?

There's a difference between SQL statements returning data (e.g. SELECT statements) and statements that do something (INSERT, UPDATE, calling some stored procedures, GRANT, REVOKE).

For the latter you use, IIRC, the Execute method of the query object. See the wiki on databases (e.g. SQLDB Tutorial1) for more details...

Edit: seems you're fairly new here. Some tips: it helps to search through the wiki and forum for things... Also, in general, the FPC documentation is excellent.

I know I had big troubles getting database access to work, not having a Delphi background.
It helps if you tell us what you tried (or tried searching for) and what failed, what Lazarus version, what operating system you're using... this way guessing games will hopefully be limited.

Good luck,
BigChimp

[ludob]

Use TMysqlxxConnection.ExecuteDirect. Replace xx with the MySQL version you are using.

[lazguy]

Thank You very Much, BigChimp and ludob.

It is possible.

Problem Solved.