H horseFree Unregistered / Unconfirmed GUEST, unregistred user! 2003-04-13 #1 有一字段值是中文字符,想用filter过滤,如“福建省人民政府”,我想设过滤条件为“人民”二字,如何做?
C Carson_zzd Unregistered / Unconfirmed GUEST, unregistred user! 2003-04-13 #3 table1.filter := false ; table1.filter := 'fieldname like ' + '%人民%' ; table1.filtered := true ; table1.open ;
table1.filter := false ; table1.filter := 'fieldname like ' + '%人民%' ; table1.filtered := true ; table1.open ;
H horseFree Unregistered / Unconfirmed GUEST, unregistred user! 2003-04-14 #4 Carson_zzd 如何引用字段,如表里有一个字段“adres”,
任 任豆豆 Unregistered / Unconfirmed GUEST, unregistred user! 2003-04-14 #5 table1.close; table1.filter := false ; table1.filter := 'adres like' + #39 + '%人民%' + #39; table1.filtered := true ; table1.open ;
table1.close; table1.filter := false ; table1.filter := 'adres like' + #39 + '%人民%' + #39; table1.filtered := true ; table1.open ;
H horseFree Unregistered / Unconfirmed GUEST, unregistred user! 2003-04-14 #9 按任豆豆的办法加入代码,编译可以通过,运行出错,提示:找不到字段“XXXX”,该字段是中文,谁能帮我?
B bowl Unregistered / Unconfirmed GUEST, unregistred user! 2003-04-14 #10 你是不是全部COPY的? table1.filter := false ; 错了
H horseFree Unregistered / Unconfirmed GUEST, unregistred user! 2003-04-14 #11 我也改了:table1.filtered := false ;
H horseFree Unregistered / Unconfirmed GUEST, unregistred user! 2003-04-14 #12 对不起,是我搞错了,豆豆大侠的代码可以执行,但新的问题是:起不到过滤作用,我的过滤条件是通过edit1.text传送的,谁知道是怎么回事?
C coolqiang Unregistered / Unconfirmed GUEST, unregistred user! 2003-04-14 #13 试试这个: '[adres] like ' + Chr($27) + '%' + Edit1.Text + '%' + Chr($27)
C Carson_zzd Unregistered / Unconfirmed GUEST, unregistred user! 2003-04-14 #14 table1.close ; table1.filter := false ; table1.filter := 'adres like ' + '%' + QuotedStr(Edit1.text) + '%' ; table1.filtered := true ; table1.open
table1.close ; table1.filter := false ; table1.filter := 'adres like ' + '%' + QuotedStr(Edit1.text) + '%' ; table1.filtered := true ; table1.open
H horseFree Unregistered / Unconfirmed GUEST, unregistred user! 2003-04-14 #15 table1.close ; table1.filter := false ; table1.filter := 'adres like ' + '%' + QuotedStr(Edit1.text) + '%' ; table1.filtered := true ; table1.open 上述代码运行死机。 '[adres] like ' + Chr($27) + '%' + Edit1.Text + '%' + Chr($27) 故障同上。
table1.close ; table1.filter := false ; table1.filter := 'adres like ' + '%' + QuotedStr(Edit1.text) + '%' ; table1.filtered := true ; table1.open 上述代码运行死机。 '[adres] like ' + Chr($27) + '%' + Edit1.Text + '%' + Chr($27) 故障同上。
任 任豆豆 Unregistered / Unconfirmed GUEST, unregistred user! 2003-04-14 #16 table1.close ; table1.filtered := false ; table1.filter := 'adres like ' +#39 + '%' + Edit1.text + '%' + #39; table1.filtered := true ; table1.open
table1.close ; table1.filtered := false ; table1.filter := 'adres like ' +#39 + '%' + Edit1.text + '%' + #39; table1.filtered := true ; table1.open
H horseFree Unregistered / Unconfirmed GUEST, unregistred user! 2003-04-14 #18 还是出错。提示:operation not applicable
B bbs-wqt Unregistered / Unconfirmed GUEST, unregistred user! 2003-04-14 #19 table1.filter := 'adres like ''%' + Trim(Edit1.text) + '%''' ;