A friend has asked me to post this for him.
===========================================
I hope that someone can help me here. I have an application that I'm building 95% done, but I've ran into a snag, that for some reason I can't see what I'm missing.

I have a firebird db, with two fields defined as:

LO_NBR_ BIGINT NOT NULL
HI_NBR_ BIGINT NOT NULL

The above is used, because I have to store numbers up to 5,000,000,000, and according to FB BIGINT covers:

9,223,372,036,854,775,807

Given this
number1 = 3289661541 (unsigned long int)
number2 = 3289661550 (unsigned long int)

I then try to filter the records

as_the_filter := StrToFloat(number1) + '>=' + FloatToStr(lo_nbr) + ' and ' + StrToFloat(number1) + '<=' + FloatToStr(hi_nbr);

I then kick in the filtering, and it is NO WERE NEAR the record I'm expecting. I don't know if it's my C++ background that messing me up, or what.

NOTE: I'm not on my normal computer, so if the syntax is off, forgive me, but you get the idea.

Help please!