🚀 go-pugleaf

On Tue, 1 Jun 2004 14:41:25 +0200, "Zannha" <asd> wrote:

>Argh,
>
>what is wrong with this?
>
>Form1->cmd->CommandText = "INSERT INTO mapdata ";
>Form1->cmd->CommandText += "(layer, header, description, posx, posy,
>category)";
>Form1->cmd->CommandText += " VALUES ";
>Form1->cmd->CommandText +=
>"("+IntToStr(index)+",'"+header->Text+"','"+desc->Text+"',";
>Form1->cmd->CommandText +=
>IntToStr(mousex)+","+IntToStr(mousey)+",'"+cat->Text+"')";
>Form1->cmd->Execute();
>
>layer is a number field, header a text field, description a memo field, posx
>and posy number field and category a text field.
>
>I'm getting an exception saying Syntax error in INSERT INTO...
>
>Zan
>

Not shure, but I wouldn't use += operator with properties. Rather, try to
compose the SQL statement by hand, using a temporary string, the assigning it
to the CommandText property once, only after you have built it. Doing so, you
can be able even to investigate the syntactical structure of the final
statement in order to check for the error.
Even, consider to use parameters wich are "portable" between differend DBMS
engines: beware the different dates' format and numbers' format you could meet
when you are building a SQL statement by hand.

Giuliano