# Re: VB与资料库

Posted by 尧仔 on February 04, 1999 at 00:09:44:

In Reply to: VB与资料库 posted by Frad Tsai on February 03, 1999 at 21:44:43:

Parameters [sd] date,[ed] date,[name] text;
select * from table where [日期] between [sd] and [ed] and [人员]=[name] '存成querydef区间人员查询
set qd=db.querydef("区间人员查询")
qd.parameters(0)=[sd] '请写入所须日期
qd.parameters(1)=[ed]
qd.parameters(2)=[name]
set rs=qd.openrecordset

Follow Ups: