我试过用select * from data.db where UPPER(memo) like upper(:key)的方法,但好象upper并不支持memo形的字段,报错,有没有简单的方法让query控件不区别大小写查询啊?
解决方案 »
- QQ聊天对话框中,发送图片,是怎么提取出来的。
- 求16进制字符串转数值的函数
- ★★★★再放200 嘿嘿~~★★★★
- 本人因为想学习DELPHI 想自己购买一套关于ERP方面的软件自己学习用,请问哪们大虾能把自己好的作品分享给呀!
- 请大家讨论一下delphi有前途吗?
- 请问OleVariant, wordbool , safecalld 的用法和含义?
- dbimage 打不开bmp图像,说是"bitmap is not valid"
- 如何从内存中释放所有窗口?急!!!!
- 我用Delphi写了一个打字软件,有两个问题搞不定
- 一个图形编程工具的编写(对我来说有点难)
- dbgrideh中的修改 行选 时选中记录的背景色?
- 请教简单问题:StringGrid问题???
Call Locate to search a dataset for a specific row and make it the current row.KeyFields is a string containing a semicolon-delimited list of field names on which to search.KeyValues is a variant that specifies the values to match in the key fields. If KeyFields lists a single field, KeyValues specifies the value for that field on the desired row. To specify multiple search values, pass a variant array as KeyValues, or construct a variant array on the fly using the VarArrayOf routine. For example:with ADOTable1 do
Locate('Company;Contact;Phone', VarArrayOf(['Sight Diver', 'P', '408-431-1000']), [loPartialKey]);
TLocateOptions Opts;
Opts.Clear();
Opts << loPartialKey;
Variant locvalues[2];
locvalues[0] = Variant("Sight Diver");
locvalues[1] = Variant("P");
CustTable->Locate("Company;Contact", VarArrayOf(locvalues, 1), Opts);Options is a set that optionally specifies additional search latitude when searching on string fields. If Options contains the loCaseInsensitive setting, then Locate ignores case when matching fields. If Options contains the loPartialKey setting, then Locate allows partial-string matching on strings in KeyValues. If Options is an empty set, or if KeyFields does not include any string fields, Options is ignored.