CDaoDatabase支持"LIKE"吗？

[involute]

我用"delete from table1 where field1 like '%hello%'"怎么不行？
另外"where not field1 like '%hello%'"和"where field1 not like '%hello%'"
或"where not field1='124'"和"where field1 <>'124'"有区别么？
我觉得好像一样。

睡觉觉，明天来看结果，希望大家能帮我。

[involute]

又是我自己解决的！

通配符竟然是'*'!!我TNND!

[蒋晟]

Microsoft Access 2000 provides three new object models to use in the creation, maintaining and managing of your Access 2000 databases and their related data by using Visual Basic.

Microsoft ActiveX Data Objects (ADO)

ADO contains the objects needed to create, maintain, and delete records in a given datasource.

Microsoft ADO Ext. for DDL and Security (ADOX)

ADOX provides the Data Definition Language(DDL) objects needed to create a new database and its contained objects in addition to the objects needed to manage security.

Microsoft Jet and Replication Objects 2.1 Library (JRO)

Since ADO objects were designed to work with many databases in addition to Microsoft Jet databases, functionality specific to Jet was broken out into the JRO library.

The following table lists the functionality provided by each compared

Functionality DAO ADO1 ADOX2 JRO
(MDB's Only)
Support ANSI92 SQL*** No Yes Yes Yes
*** Though Jet does support some ANSI 92 SQL it is not yet fully ANSI92 compliant.
在Access2002中可以通过用户界面修改是否兼容ANSI92 SQL语法，在Access2000中只能编程修改。

[bugz]

这个和CDaoDatabase无关，是看你的DBMS是不是支持like的语法

[WnEunfn]

呵呵，原来你也被它拌了一下子……