Locate 问题(50分)

  • 主题发起人 主题发起人 f950436
  • 开始时间 开始时间
F

f950436

Unregistered / Unconfirmed
GUEST, unregistred user!
为什么对一个表循环LOCATE,却找不到记录,可明明有要找的记录啊
 
"Options"这个参数有没有设好!
function Locate(const KeyFields: string; const KeyValues: Variant; Options: TLocateOptions): Boolean; virtual;
---------------------------------------------------------
type
TLocateOption = (loCaseInsensitive, loPartialKey);
TLocateOptions = set of TLocateOption;
-----------------------------------------------------------
Value Description
------------------------------------------------------------
loCaseInsensitive Key fields and key values are matched without regard to case.
loPartialKey Key values can include only part of the matching key field value; for example, 'HAM' would match both 'HAMM' and 'HAMMER.'
 
ADOTable1.Locate('field',Value,[]);
這樣找不到嗎?如果找不到﹐能不能說詳細一點
 
谢谢二位:我是这样的
if not query2.Locate('TASK_ID',task_id,[]) then
begin
ssql := ' INSERT INTO T_SY_PLAN_TASK (TASK_ID,TASK_NAME,TASK_STATE) '+
' VALUES(''%s'',''%s'',''%s'') ';
ssql := Format(ssql,[task_id, task_name,task_state]);
query2.SQl.Clear;
QUERY2.SQL.Add(ssql);
query2.ExecSQL;
end;

外层的循环就省了

 
后退
顶部