Thank you very much Razzak, I think including Date this into the COMMENT command could be a nice enhancement when running update routines on tables. Very best regards to the US Fritz
-----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[email protected]] Im Auftrag von A. Razzak Memon Gesendet: Freitag, 10. Oktober 2014 15:18 An: RBASE-L Mailing List Betreff: [RBASE-L] - Re: Comment on Table --- include global Var #Date 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! --
