>I looked at many of the suggestions and replacing the single quote with a
>doulble quote works.

I don't think anyone suggested that you replaced a single quote with a
double quote, rather they suggested that you replaced one single quote with
two single quotes.

>Is this the only time you need to use the transaction command when there are
>multiple statements that need to succeed or fail.(all or nothing situation)?

Everything happens within transactions (well, generators aren't bound by
transactions), and each transaction should be a logical unit of work. If
your logical unit of work is only one statement, it still happens within a
transaction. Some tools may not originally be designed for transactions
(e.g. the BDE) and pretend they don't exist. But the transactions are still
there, and they're normally very useful!

Set