Re: "Select * where ......."长度太长整么办?
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 stringwsql = "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)
