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]
