如何在MS Access中以编程方式更改querydef sql [英] How to change querydef sql programmatically in MS Access

问题描述

我做完

Dim qd as querydef
set qd = Querydefs("MyQuery")
qd.sql = "..."

在调试中，qd.sql已更新，但是物理MyQuery仍然包含旧的sql.

In debug qd.sql has been updated but the physical MyQuery still contains the old sql.

如何更新此物理查询?

Microsoft在此处给出的源代码 http://msdn.microsoft.com/en-us/library/bb177500. aspx

The source code given by microsoft here http://msdn.microsoft.com/en-us/library/bb177500.aspx

也不起作用.

推荐答案

除对象外，请勿使用SET.您需要一个QueryDefs对象，所以:

You should not use SET except with objects. You need an object for QueryDefs, so:

Dim qd As QueryDef
Set qd = CurrentDb.QueryDefs("MyQuery")
qd.SQL = "SELECT Category FROM Categories"

确保SQL有效，否则将出错.

Ensure that the SQL works, or it will error out.

这篇关于如何在MS Access中以编程方式更改querydef sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！