Re: problem w/ locate function...need ur input guys...

i checked the my code last night and the problem is not actually on how
i check for empty like ' '  -- but yes i agree checking empty values
using isnull() is very logical. For sure i will adapt that.

the problem is on this ****tion:

with db.table1 do
begin
   if locate(...) then
     // edit record
   else
     // insert new record...

... database engine failed to locate the record, even though record is
there.