Thank´s Tony ! fritz -----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[email protected]] Im Auftrag von Tony IJntema Gesendet: Freitag, 10. Oktober 2014 12:24 An: RBASE-L Mailing List Betreff: [RBASE-L] - RE: AW: [RBASE-L] - RE: Comment on Table --- include global Var #Date
Fritz, Don't mix up two methods. The reason why it is not working is because you have placed the variable between quotes and then it is considered to be a text Be careful you have used 2 times = in the definition Try this: Set var var1 TEXT = ( (ctxt(.#date)) & "Server table") COMMENT ON TABLE testtab IS .var1 Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dr. Fritz Luettgens Sent: vrijdag 10 oktober 2014 12:03 To: RBASE-L Mailing List Subject: [RBASE-L] - AW: [RBASE-L] - RE: Comment on Table --- include global Var #Date Thank´s Tony, but I do not get the result. Set var1= TEXT = (ctxt(.#date)) COMMENT ON TABLE testtab IS "(.var1) Server table;" Results in only Text, but no DATE included: WYSISWYG COMMENT ON TABLE testtab IS "(.var1) Server table;" Fritz -----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[email protected]] Im Auftrag von Tony IJntema Gesendet: Freitag, 10. Oktober 2014 11:25 An: RBASE-L Mailing List Betreff: [RBASE-L] - RE: Comment on Table --- include global Var #Date Fritz, Before you can do that you have to convert the date to a text value. Like this: Set var V_datecomment TEXT = (ctxt(.#date)) Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dr. Fritz Luettgens Sent: vrijdag 10 oktober 2014 10:35 To: RBASE-L Mailing List Subject: [RBASE-L] - Comment on Table --- include global Var #Date Hi, 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;" It is not working either. Thank´s Fritz
