locate doesnt work

[filipe29]

Hi .I have a locate to a query like this:
if vendas_em_divida.Locate('IDVenda',qry_vendasidvenda.Value,[])=true then
showmessage(vendas_em_dividaidvenda.AsString);

and for some reason the message is not displayed.The sintax is correct and i have in vendas_em_divida the value (qry_vendasidvenda.Value)

why doesnt locate??

My database is sql server with ADO querys

 

[buho]

I dont know what qry_vendasidvenda.Value is returning or what it is at all, but try using the target value directly.

Like in:

Target := value_to_search;
if vendas_em_divida.Locate('IDVenda', Target, []) then ...

Eventually, using:

Target := qry_vendasidvenda.Value;
if vendas_em_divida.Locate('IDVenda', Target, []) then ...

will let you set a breakpoint and check Target.

HTH.
buho (A).

 

[LucieLastic]

Just a tip... always do a First before a locate to make sure you start at the beginning.

vendas_em_divida.First;
vendas_em_divida.locate...