Search results for query: *

Not in 4gl - you'll have to call a C function.

I see you're using a tetra/sage system (on C-ISAM version?): select plsuppm.supplier, plsuppm.name, ytd_sales,supplier_category,sum(vat_amoun t) va,sum(currency_amount) ca from plsuppm, plinvm...

Can you post your current sql? That might help. I'd imagine something like this: select account_no, sum(order_value) from customers, orders where [joins] and [conditions] group by 1 order by 1

If the above doesn't sort the problem, then you could get it entered as text and use the following function to check if it's a number: #------------------------------------------------------------------------------ # Takes a string and works out whether it's a number or not... FUNCTION...

You can use arg_val(0) which contains the program name. Other variables that might help: SQLCA.SQLCODE - error status of last SQL SQLCA.SQLERRD[2] - ISAM status for last SQL err_get() - get description for error (uses finderr) Note the module is recorded in the log file whenever you have...

Nope, informix always pads strings with spaces (for some unfathomable reason).

You should check whether you've received values from the second select: if sqlca.sqlcode = 100 then # not found else # found end if