Take variable MYSQL

Databases
1

I need take time of my server MYSQL use is command now()

mysql> set @hora_actual=now();
Query OK, 0 rows affected (0.45 sec)

mysql> select @hora_actual;
±--------------------+
| @hora_actual |
±--------------------+
| 2013-11-27 20:42:51 |
±--------------------+
1 rows in set (9.71 sec)

But,what is format correct for take is value

verloticket = db.SQLSelect("@hora_actual’)

is not work.

2

verloticket = db.SQLSelect(“select now()”)

3

Excuse, but is order is :

verloticket = db.SQLSelect(“select now()”)

Dim rs as RecordSet = db.SQLSelect(verloticket)

TextField1.Text= verloticket

is correct?

4

Sorry yes
something like

dim rs as recordset = db.SQLSelect("select now()") TextField1.Text= rs.idxField(1).StringValue

add error checks as needed

5

But fail, is error

6

“SELECT NOW() as ID”

You refer to ID in your FIELD statement but not in your SELECT statement.

7

not work,

dim verloo as String
dim rs as recordset = db.SQLSelect("select now() as id")
verloo = str(rs.idxField(1).IntegerValue)
8

[quote=49478:@Fernando Pinto]But fail, is error
[/quote]
I can see your code isn’t what I wrote :stuck_out_tongue:

I literally just wrote

[code] dim db as new MySQLCommunityServer
db.Host = “127.0.0.1”
db.DatabaseName = “*******”
db.port = 3306
db.UserName = “********”

if db.connect() then
dim rs as recordset = db.SQLSelect(“select now()”)
dim s as string = rs.idxField(1).StringValue
break
end if[/code]

and s = “2013-11-27 20:46:35”

9

Thank’s

10