--- In firebird-support@yahoogroups.com, "andyh20012003"
<andyholcomb@c...> wrote:

> Alexander, I apologize for doing this to you, I am having problems
> finding info on doing what you talked about.
>
> First: my lowest value is set in my code of 0.001 therefore anything
> Greater than or equal to 0.001 is not equal to 0, right?

More cautious will be 0.0001 - if 0.001 is lowest significant value,
it can be stored as 0.0009(9)

> I have not found any info on where to place the code you sent me,
> does this look right? This code will not run, it gives me a column
> name error.

Outside SQL statement you should use not table columns but variables
into which values of this columns are fetched, i.e. not

if ((ENH.TestedValue >= 0.001 ) and (ENL.TestedValue >= 0.001))

but

if ((EHTestedVal >= 0.001 ) and (ELTestedVal >= 0.001))

> PS. Any good book ideas on using sql with ib or fb would be great.

IB6 docs are first step :) There are links to download on
www.ibphoenix.com. On this particular subject look Procedures and
Triggers chapter in LangRef and corresponding chapters in DataDef.

Best regards, Alexander.