如何在select命令中引用系统日期

[WONGRAIN]

如select * from abc where between {^2005-1-1} and 当前系统日期，另外请教如何在程序初始化时应用的其他数据表是共享打开不是独占
thanks

[WONGRAIN]

to 站在路口不远处，thank you very much
请问有没有办法前面选定为1号，后面就自动设定为所选月份的最后一天呢

[zsjiaming]

要用变量.

如果是视图就要用变量 ?变量名
如果不是视图,直接用变量名

**如果是视图:
begindate=date(2005,12,1)
enddate=gomonth(begindate,1)-1
select * from abc where between ?begindate and ?enddate

*如果不是视图
begindate=date(2005,12,1)
enddate=gomonth(begindate,1)-1 &&下个月退后一天.
select * from abc where between begindate and enddate

*或者(非视图)
begindate=date(2005,12,1)
select * from abc where between begindate and gomonth(begindate,1)-1

[zsjiaming]

select * from abc where between {^2005-1-1} and date()

use 表名 in 0 shared &&共享
如果是在数据环境中的表.选中此表,设置属性shared为.T.

[zsjiaming]

订正:
如果是在数据环境中,把此表的exclusive属性设为.F.