I have this query:
SELECT clients.id_client, clients.fname, clients.lname, (SELECT total
FROM prcdr_due(clients.id_client) AS due, clients.due_date FROM clients

the due column returns as null instead of having a value, when I
execute the procedure in ibexpert I get the correct results, so any
suggestions would be greatly appreciated

JT