Hello Albert, SQL Studio does not handle the default values for date and a ' ' for char correctly. I will correct this in one of the next versions.
http://www.sapdb.org/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1135887 Thank you for the hints. Regards Wolfgang -----Original Message----- From: Beermann, Albert [mailto:[EMAIL PROTECTED] Sent: Dienstag, 31. Mai 2005 12:27 To: maxdb@lists.mysql.com Subject: How to set/alter a default in SQL-Studio ! Hello Everybody ! with the sql-dialog I can do: alter table xyz column fielda alter default ' ' for char columns or alter table xyz column fielda alter default '9999-12-31' for date columns (The datetime parameter in my database is "EUR") I want to know how to do this with the sql-studio gui ?? I tried alter table, then click on default , then chosing userdefined value, then typing ' ' for char columns or '9999-12-31' for date columns, but this doesn't work. Same with " " ..... Error: invalid end of sql statement What do i have to type in the userdefined value to get the same results as with the sql dialog??? Any help welcomed Albert ''''' ''''''''' (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] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
