Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Ability to call ALTER only mentioning "DESCRIPTION"
Wed, Sep 27 2017 11:56 AMPermanent Link

Adam Brett

Orixa Systems

In my systems I use the Column, Table, Function and Procedure DESCRIPTION Configuration meta-data. I store IniFile-Like data in it.

It would be really useful for me if I could call:

ALTER PROCEDURE <SomeProcedureName>
DESCRIPTION
'[Properties]
LinkTable=
Type=System
Title=Backup Database
CheckBefore=false
UserMessage=Backup database. NOTES: "Include Published Updates" will add replication data to the backup file, this is not normally needed. "Backup System DB" will create a separate backup file for the SystemDB, this is not normally needed.'
VERSION 2.00!

This call would make no change to the Procedure (or Function, Table, or Column) definition, but would just overwrite the DESCRIPTION
Fri, Sep 29 2017 3:51 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Adam,

<< This call would make no change to the Procedure (or Function, Table, or Column) definition, but would just overwrite the DESCRIPTION >>

Improvements like this to the ALTER operations are definitely on the short list.  I think I tried to squeeze them in earlier this year and ran out of time.

Tim Young
Elevate Software
www.elevatesoft.com
Mon, Oct 2 2017 4:47 AMPermanent Link

Adam Brett

Orixa Systems

Thanks Tim. Including it will make a really useful difference to me.
Wed, Oct 4 2017 9:49 AMPermanent Link

Adam Brett

Orixa Systems

Tim, Sorry, I should obviously have added that as well as being able to alter DESCRIPTION without calling the rest of the ALTER statement, it would also be great to be able to alter ATTRIBUTES ...

ALTER Table <Some Table Name>
ATTRIBUTES ''!
Wed, Oct 4 2017 2:27 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Adam,

<< Tim, Sorry, I should obviously have added that as well as being able to alter DESCRIPTION without calling the rest of the ALTER statement, it would also be great to be able to alter ATTRIBUTES ...  >>

Yep, no problem.  The general idea is to allow for all keywords to be optional, and for EDB to handle it properly when they're missing.

Tim Young
Elevate Software
www.elevatesoft.com
Image