[Solved] Base Mysql get username + hostname

[ponlerd]

Hi, is there a way that i can get the username and hostname in a macro?
I want to stamp the user@hostname on some records.
For the username i can get it from
Form.ActiveConnection.Parent.User (if i remember it right.)

But for the hostname , i couldn't find it anywhere on the xRay.
Thanks!

[rudolfo]

You use MySQL in your title and the format user@hostname sounds like MySQL as well.
So my advice is: "Ask the database for this information:"

Code: Select all

mysql> select user();
+----------------+
| user()         |
+----------------+
| rolf@localhost |
+----------------+

If I do the same inside a query in Base on my Windows machine connected to a MySQL database on a Linux Box I get: rolf@grappa.ristaurante.local as the resulting record.
Actually this is information about the client side of the connection. But as you say you need to stamp it, the client machine makes much more sense than the host name with the mysql server.

update this_table set changed_by = user() where ....

And see the Mysql manual in case you need other types of session data.

[ponlerd]

Thanks , works great!