Toad World® Forums

Default values for NotNull Constraint partly work


#1

Hi,

I defined the the default values to have a NotNull Constraint value defined as
NN__

but get created as
NN__

See the attached screenshots.

Can you help?

Sebastien


#2

Hi,

application variables cannot be used there. Quick hint: open the form of object for which you wish to set default value using application and click the <%> button at bottom left corner. List of application opens and at bottom you can find where the selected application variable can be used. In general, the purpose (originally) was to be able to use the application variables in SQL code of stored procedures, functions and to use them in comments. Names and captions of other database objects were not targeted. We will consider improvements in this area.

Regards,

Vaclav


#3

Yes this would be useful, so you don’t have to write a macro to generate such a name.

Thanks,
Sebastien


#4

I’d like such an improvement, too.