hi,
in the script you have
" CONSTRAINT `0_132` FOREIGN KEY ( `SCode` ) REFERENCES
`statesarticles` ( `SCode` ) ON UPDATE CASCADE "
and this code it's a definition of the foreign key.
run the script without this part of the code.
Citando David Blomstrom <[EMAIL PROTECTED]>:
> When I was first
Hi,
before you start to make inserts/updates to the database you can put
$db->query("begin;") -> this is to begin a transaction, in the end of the script
you put commit ($db->query("commit;") if all goes ok, otherwise rollback
($db->query("rollback;").
andré brás
Citando Andy Hall <[EMAIL PROTEC
hi there,
i'm using two different database objects, for each connection.
i still haven't tried with save points, but i will, to see what append.
regards,
andré
Citando Heikki Tuuri <[EMAIL PROTECTED]>:
> Andre,
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> Newsgroups: mailing.d
Hello there.
i'm working with transactions, and i have one situtation where i start a
transaction and execute the insert/update statement, then i execute another
start transaction for another db and execute the insert/update, and if this
return a error i do the rollback, and then i do the rollback
