MySQL include (cdkid) error

[PanStefan]

Hello, it's me again.
This time I have problem with MySQL plugin.

Here is my code

#include <MySQL.au3>
#include <Date.au3>
#include <MsgBoxConstants.au3>

$User=""
$Password=""
$Database=""
$Serwer=""
;I guess you guys know, why those variables are empty :)


$Column = _NowDate()

$BazaDanych = _MySQLConnect($User, $Password, $Database, $Serwer)

$Variable1 = InputBox("", "Enter a value: ")

$Query = "UPDATE autoit SET '" & $Column & "' = '" & $Variable1 & "'"

MsgBox(0, "MySQL Query Preview", $Query)

_Query($BazaDanych, $Query)

_MySQLEnd($BazaDanych)

 

[PanStefan]

Help? Anyone?

[Melba23]

PanStefan,

Please do not bump your own threads within 24 hours.

Remember this is not a 24/7 support forum - those who answer are only here because they like helping others and have some time to spare.  You just have to wait until someone who knows something about your particular problem, and is willing to help, comes online.  Be patient and someone will answer eventually.

M23

[mLipok]

@PanStefan

You should use COM error handler

use 

ObjEvent()

 

[PanStefan]

How/where should I use it? Can you give me an example?

[mLipok]

Click in link (function Name) which I mention in my previouse post.
There is an example.

[kylomas]

PanStefan,

Check that you have a connection like this

$BazaDanych = _MySQLConnect($User, $Password, $Database, $Serwer)
if @error then exit msgbox(17, 'Connect Error', '@ERROR = ' & @ERROR)

Also,

Do you really have a table with a column name equal to the result of _NowDate()?

Do you really want to update all rows with whatever the user is inputing?

kylomas

edit: What OS do you have?

Edited October 15, 2015 by kylomas
additional info

[PanStefan]

Yes, I have this table
It's just for an example.
Windows 8.

MsgBox displays ERROR = 2

Topic can be closed, I changed the plugin (ProgAndy's plugin) and everything works.

Edited October 15, 2015 by PanStefan