TQuery的Filter中能否使用统配符号?
解决方案 »
- 遇到一奇怪问题
- 还是问个简单点的问题:使WebBrowser获得焦点
- 棋牌游戏新开张,欢迎大家来测试!
- WebServer+soap+分布式开发 应用程序,如何构架??
- 求教关于Socket通讯----分用完了,很急!!!
- 高手帮忙...Delphi中调Oracle的存储过程
- 50元人民币真心求师指点(认真地)
- 哪位用过SkinEngine?为什么用Sleuth QA测试以后有这么多错误和内存泄漏?
- 我用IIS5.0建站,为什么不能浏览.dll文件,是用delphi做的dll。
- 数据库StoredProc编程,在退出时发生异常
- 请问哪里有 Delphi 程序调试参考手册 下载
- 清空数据库表格时,用EMPTYTABLE;语句时,发生 'table is busy.'这样的错误,是什么引起的?
当然可以,不过要你的数据库端支持呀这样的么,为什么我在select中支持的通配符,到Filter中不支持呢?
如支持
fcypmc='*中*'
但不支持
fcypmc like '*中*'
以下是FILTER中支持的操作符
Operator Meaning
< Less than
> Greater than
>= Greater than or equal to
<= Less than or equal to
= Equal to
<> Not equal to
AND Tests two statements are both True
NOT Tests that the following statement is not True
OR Tests that at least one of two statements is True
+ Adds numbers, concatenates strings, ads numbers to date/time values (only available for some drivers)
- Subtracts numbers, subtracts dates, or subtracts a number from a date (only available for some drivers)
* Multiplies two numbers (only available for some drivers)
/ Divides two numbers (only available for some drivers)
* wildcard for partial comparisons (FilterOptions must include foPartialCo
另:Filter不能过滤非物理字段头痛,又要写代码了。