# Re: "Select * where ......."长度太长整么办?

Posted by 纪文和 on June 15, 1998 at 09:17:03:

In Reply to: posted by 霈捷 on June 15, 1998 at 01:04:01:

这个问题其实很简单, 您只要稍微换个角度想就可以了!
例如: Set ss = Db.CreateSnapshot("Select * from table1 where field1 = 'aaa' and field2 = 'bbb' and ...")

您可以改成以下方式:
Dim wsql as string
wsql = "Select * from table1 where "
wsql = wsql & "field1 = 'aaa' and "
wsql = wsql & "field2 = 'bbb' and "
wsql = wsql & "field3 = 'ccc' and "
wsql = wsql & "...." 您想多长就可多长
Set ss = Db.CreateSnapshot(wsql)

Follow Ups:

- 建立 query 或使用 stored procedure 小吴 18:44:18 6/15/98 (1)
  - Re: 谢谢！我再试试看。 霈捷 02:36:33 6/17/98 (0)