> Could you post more information about the error message? Ok, here it comes:
I have a dutch version of Cach�, version 5.0.2.607.1, running on WinXP. I'll translate everything between []. I have an object (or, equivalently) table called Employee, with a Property called Firstname. I start SQL Manager, and choose Object -> Uitvoeren Query [Run Query] Now I type the query "SELECT IsNull(Firstname,'No First Name') FROM Employee", and choose Query Uitvoeren... [Run Query...]. Now I see a message box saying: Uitvoeren Query - Kan geen dynamisch query-object voor dit statment maken. [Can not make dynamic query-object for this statement] ERROR #5821: Cannot instantiate query: 'SQLCODE = -400' (Hints omitted) The syntax is correct, and if I run "SELECT Firstname FROM Employee", I get all first names of employees. So there is a problem with IsNull (and functions like it). I think the word dynamic is important, but I don't know what the problem is. It's not SQL Manager's problem, because it does not work in Studie either (I get an empty result set). So the question is: What is a dynamic query object, and what can I do to use IsNull? Thanks for helping... Joost
