RE: How to select records from columns with where default =

Beermann, Albert wrote:
> 
> Hello Everbody !
> 
> With sql-studio i want to select some records from the columns table
> (date or datetime fields with  default definition)
> 
> I can do:
> 
> Select * from columns where datatype like 'DA%'
> 
> I want to do:
> 
> Select * from columns where datatype like 'DA%' and default 
> like '9999%'
> 
> Error ! default no allowed
> 
> 
 
use "DEFAULT"  as default is a (reserved) keyword and interpreted
different
to your needs.
"default" will not help as this is different to the columnname "DEFAULT"
defined for DOMAIN.COLUMNS

Elke
SAP Labs Berlin

> 
> Any help welcomed.
> 
> Best regards 
> 
> Albert
> 
>                               ''''' 
>                              ''''''''' 
>                             (0 0) 
>  +---------oOO-----------(_)------------------------------+ 
>  | Tel: 0541/5841-868                                  | 
>  | Fax: 0541/5841-869                                 | 
>  | Mail: mailto:[email protected]
> <mailto:[email protected]>   |  
>  | Internet:  http://www.piepenbrock.de <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]