Hi Team,
I modified a constraint, no problem, and the SQL generated under Explorer|SQL History was..
{sql}
ALTER TABLE "Albums"
ALTER CONSTRAINT "BarCodeNo_PriceCode" AS UNIQUE ("BarcodeNoPriceCode") ERROR CODE 20001 MESSAGE 'Duplicate Barcode # Price Code is not permitted.'
{sql}

When I put this into a script..

{sql}
Execute Immediate 'ALTER TABLE "Albums"
ALTER CONSTRAINT "BarCodeNo_PriceCode" AS UNIQUE ("BarcodeNoPriceCode") ERROR CODE 20001 MESSAGE 'Duplicate Barcode # Price Code is not permitted.'';
{sql}

It falls over.  Doesn't like the MESSAGE text.
What do I do about the Message pls?

Regards & TIA,
Ian

Ian Branch wrote:

> {sql}
> Execute Immediate 'ALTER TABLE "Albums"
> ALTER CONSTRAINT "BarCodeNo_PriceCode" AS UNIQUE
> ("BarcodeNoPriceCode") ERROR CODE 20001 MESSAGE 'Duplicate Barcode #
> Price Code is not permitted.''; {sql}
>
Hi Ian,

check your MESSAGE ... only one ' written, but you have to "escape"
that ' and make '' like this:

Execute Immediate 'ALTER TABLE "Albums"
ALTER CONSTRAINT "BarCodeNo_PriceCode" AS UNIQUE
("BarcodeNoPriceCode") ERROR CODE 20001 MESSAGE ''Duplicate Barcode
Price Code is not permitted.'';

--
--
Yusuf Zorlu | MicrotronX

Tks Yusuf,
Double single quotes.  Duly noted.
Regards,
Ian