ah but, in theory, this tells you that there was no data returned but does not tell you that you asked for a property that does not exist in the table. SQLCODE would generate a specific error message - by using SQLCODE and then you could use $$sqlcode^%apiSQL(Error) or equivalent API to display what the problem really is
kev
