MySQL error in MySQL.au3 l

[Meszaros Csaba]

Hi,

I've created a database in MyQL called 'plebania' with a table 'szemelyek'. It has 3 columns: keresztnev, szuletes and lakcim. I'm testing a frontend written in AutoIt:

#include <MySQL.au3>

$knev=InputBox("Keresztnev","Irj")

$dtum=InputBox("Datum","YYYY -MM-DD ")

$cim=InputBox("Cim","Irj")

dim $values[4]

$values[0] = Chr(34)&$knev&Chr(34)

$values[1] = Chr(34)&$dtum&Chr(34)

$values[2] = Chr(34)&$cim&Chr(34)

$values[3] = ""

$sql = _MySQLConnect("root","csaba","plebania","localhost")

_AddRecord($sql, 'szemelyek', $values, $values)

_MySQLEnd($sql)

Something must be wrong, cos I'm getting error message:

Line 132 (File "Program Files\AutoIt\Include\MySQL.au3"):

$oconnectionobj.execute(@query)

$oconnectionobj.execute(@query)^Error!

Error: The requested action with this object has failed

What's wrong ?

Edited November 11, 2006 by Meszaros Csaba