mssql中用defult设置列的缺省值，如：
CREATE TABLE [CaliHis] (
 [methodid] integer Default (0) null ,
 [useXiaoZheng] smallint Default (0) null ,
 [dxielv] float Default (0) null ,
 [djieju] float Default (0) null 
 )
请问access中如何表示
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.exoweb.net/pipermail/python-chinese/attachments/20050705/0f911463/attachment-0001.htm

[methodid] integer Default 0 null ,

不要加那个括号试试

2005/7/5, mahongquan <mahongquan730208 at 163.com>:
>  
> mssql中用defult设置列的缺省值，如： 
> CREATE TABLE [CaliHis] (
>  [methodid] integer Default (0) null ,
>  [useXiaoZheng] smallint Default (0) null ,
>  [dxielv] float Default (0) null ,
>  [djieju] float Default (0) null 
>  ) 
> 请问access中如何表示
>  
> _______________________________________________
> python-chinese list
> python-chinese at lists.python.cn
> http://python.cn/mailman/listinfo/python-chinese
> 
> 
> 


-- 
Blog:http://www.donews.net/changzheng

不行，提示default 处有错误
----- Original Message ----- 
From: "清风" <paradise.qingfeng at gmail.com>
To: <python-chinese at lists.python.cn>
Sent: Tuesday, July 05, 2005 1:13 PM
Subject: Re: [python-chinese] acesss 中使用sql如何设定列的缺省值


> [methodid] integer Default 0 null ,
> 
> 不要加那个括号试试
> 
> 2005/7/5, mahongquan <mahongquan730208 at 163.com>:
> >  
> > mssql中用defult设置列的缺省值，如： 
> > CREATE TABLE [CaliHis] (
> >  [methodid] integer Default (0) null ,
> >  [useXiaoZheng] smallint Default (0) null ,
> >  [dxielv] float Default (0) null ,
> >  [djieju] float Default (0) null 
> >  ) 
> > 请问access中如何表示
> >  
> > _______________________________________________
> > python-chinese list
> > python-chinese at lists.python.cn
> > http://python.cn/mailman/listinfo/python-chinese
> > 
> > 
> > 
> 
> 
> -- 
> Blog:http://www.donews.net/changzheng
> 


--------------------------------------------------------------------------------


> _______________________________________________
> python-chinese list
> python-chinese at lists.python.cn
> http://python.cn/mailman/listinfo/python-chinese
>