Toad World® Forums

Tables & Columns comments


#1

– Table & Columns comments section

Hi All, i’ve been a pretty avid user of TDM v2. Just upgraded to 3.1.7.36.

When i generate DDL for my model, there is a section for each table which has a comment in front of it like so:

**

when i attempt to execute the code, TOAD stops on every one and asks me to fill in the value for :Columns (because of the ampersand in the comment).

any way to get rid of the Ampersand?

thanks in advance!

David S - Tampa, Fl


#2

Hi David,

to turn this off issue;
SET DEFINE OFF

you could put this in you Model Before Script.

Note to Vladka - it would be better to change this to “and” sometime

kind regards
Malcolm


#3

Hello,

it would be better to change this to “and” sometime.

Done. :slight_smile:
It will be available in next TDM version (Beta and full).

Thanks for your great co-operation!

Regards,

Vladka + Mario


#4

Hey guys. thanks much. that (of course) gave me a perfect and simple work around.

also, thanks for modifying it for the future code…

David S.