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

pr wrote:
> "shotokan99" <soft_devjava@[EMAIL PROTECTED]
> wrote in message 
> news:1140843728.083172.143400@[EMAIL PROTECTED]
> 
>>actually the the first algo for that was this:
>>
>>with db.table1 do
>>begin
>>  if locate(....) then  //checking if the record exist
>>  begin
>>    //adding values of other fields.. on the same record
>>  end
>>  else
>>    // if not existing ..insert new record here...
>>end;
>>
>>just change that to its new algo now..coz i did encounter problems.
>>actually i did set the time format and date format through regional
>>settings according to the format im using which m/d/yy and HH:mm:ss
>>
>>why is it in database desktop they only date data type. is there no
>>time data type in dbase?
>>so if im checking empty values with the use of ' ' -  shall we say
>>that's inaccurate, so what's the best way?
> 
> 
> It depends somewhat on the database. The way to perform a full check is:
> 
> if Table.FieldByName('TEST').IsNull or 
> (Table.FieldByName('TEST').AsString='') then
>   blah;
> 
> NULL is not equal to '' or 0 (zero), for that matter.
> NULL equals 'not known' value. Both '' and 0 are 'known' values.
> This is an extremely useful distinction but sometimesalso causes
problems
> and results which you may not expect but are very logical, e.g.
>  NumericValue + NULL = NULL
>  StringValue + NULL = NULL
> 
> 
> PR
> 
> 
and then you have compiler issues where it optimizes to pass
a null pointer of a string when it should be passing a
  valid pointer to a string with a zero length in it!
  (first character being a #0)..


-- 
Real Programmers Do things like this.
http://webpages.charter.net/jamie_5