Hi,
I think tiOPF does not support MySQL to execute more than 1 SQL statement.
I tried:
procedure TVisAnnouncer_Create.Init;
begin
Query.SQLText:=
'start transaction; ' +
'INSERT INTO person (PersonName, Agen) ' +
' VALUES (:PersonName, :Age); ' +
' commit;';
end;
Also got the syntax error of MySQL.
------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
tiOPF-talk mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tiopf-talk