Perhaps you have missed the COMMENT ON statement, as described at http://dev.mysql.com/doc/maxdb/en/6d/117c53d14811d2a97400a0c9449261/content.htm
Anyway, creating the table, and specifying the individual comments are separate SQL statements. Regards Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 05, 2004 4:20 PM > To: [EMAIL PROTECTED] > Subject: Problem with MAXDB Comment field > > > Hallo ! > > My application uses the field comments of a table to decide > what to do. > Is the user allowed to leave the field empty, is he allowed to enter > data, do i need a textbox or a combobox in my forms ...... > > > Is there a way to pass value to the field comment of a table when > creating a table via programm ??? > > create table xxx( field1 char(20) comment = "mycomment",.......) > Until now i create a table from my programm and then use sqlstudio to > alter the table (putting my comments to the fields) > > Any help welcomed > > Best regards > > Albert Beermann > > ''''' > ''''''''' > (0 0) > +---------oOO-------(_)-------------------+ > | Tel: 0541/5841-868 | > | Fax: 0541/5841-869 | > | Mail: mailto:[EMAIL PROTECTED] | > | Internet: http://www.piepenbrock.de | > +-------------------------------oOO-------+ > |__|__| > || || > ooO Ooo > > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
