At 04:34 AM 10/10/2014, Dr. Fritz Luettgens wrote:
I would like to fill in the actual date to my table comment command, how can
I do that? If the global Var is within "Name" it can not work,
COMMENT ON TABLE SQLIETBLSTDAT IS "(.#DATE) Server table;"
but if it is before like
COMMENT ON TABLE SQLIETBLSTDAT IS (.#DATE) "Server table;"
Fritz,
COMMENT command requires QUOTES around the entire text string.
In your specific case ...
First, create a text string with a concatenated date and the text. Then, use
the ampersand command to accomplish your goal.
Here's how:
SET VAR vQuotes TEXT = (CVAL("QUOTES"))
SET VAR vComment TEXT = (.vQuotes+(CTXT(.#DATE))&"Server table"+.vQuotes)
COMMENT ON TABLE SQLIETBLSTDAT IS &vComment
RETURN
That's all there is to it!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
31 years of continuous innovation!
16 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
