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

Reply via email to