begin
// ...
with qryAudit do
begin
Filtered := False;
Filter := '((车号 = ''0'' AND 始发港 LIKE ''%上海%'') OR (车号 = ''达驳'' AND 目的港 LIKE ''%上海%'')) AND (运单号 LIKE ''%SH102238%'')';
Filtered := True;
end;
end;不知道为什么这段代码老报错,错误如下:"参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。"
但是,分别执行Filter := '((车号 = ''0'' AND 始发港 LIKE ''%上海%'') OR (车号 = ''达驳'' AND 目的港 LIKE ''%上海%''))'或者Filter := '(运单号 LIKE ''%SH102238%'')'可以,不知道为什么合到一起就不行了,TADOQuery的Filter有长度限制或者因为逻辑过于复杂?知道的高手指点一下,谢谢了!
解决方案 »
- 1.请问怎样在dbgrid中只显示符合搜索条件的记录2.请问怎样对表中的数据汇总
- treeview 节点数值的问
- 看看我下面的句子错哪了?
- NMUDP能用于internet程序吗?
- 标签打印
- MTS在对COM/DCOM/COM+的集中管理上主要起到什么作用。其中的Context对象和Package的作用分别是什么
- 请问当一个query的添加事件是什么?为什么afterinsert事件没反应????up有分
- 请问大虾,Delphi中取余函数是什么,这类函数在那个单元中?
- delphi 怎么取进程或程序目录?绝对给分
- 送分的来了!切勿错过!
- 求DevExpress TDBComponentmath 控件
- 欢迎加入Delphi群:45755097 互相交流,共同进步
> 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, adds 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 foPartialCompare)这些是filter支持的算符
TO tianhuo_soft: 是啊,上海一家物流公司的
TO 24782882: ''不是双引号,是2个单引号,转义用的
汗死了...