I've got a problem has me stumped. I have a client where SET ZERO is always ON. I won't go into the details, but this is a must.
Running the latest patch of 6.5++ both DOS and Win. I need to test a column (REAL) on several entry forms to see if it is NULL or zero. Seems the ISNULL function is not up to the task. Here is some demo code: set null -0- set zero on -- required set var vreal real = null set var vtest = (ifnull(.vreal,'is null','is not null')) wri .vreal, .vtest wri ' ' set var vreal real = 0 set var vtest = (ifnull(.vreal,'is null','is not null')) wri .vreal, .vtest vTest always = 'is null' Anyone have a magic bullet that will solve my problem? Dennis McGrath
