hi,

I've got a class myClass having a constructor

public new myClass(Object arg0, Object arg1, Object arg2).

I'm trying to select sth from my DB and have a result in the instances of myClass.

let's assume I've got my_table in the DB, havin 3 fields


If I do

SELECT new myClass(t.f1, t.f2, t.f3) FROM myTable AS t

then it works, but if I want the application not to select t.f3 from the DB,
and I want to initialize myClass with 2 fields only it doesn't work? WHY???

SELECT new myClass(t.f1, t.f2, null) FROM myTable AS t

gives me an exception

"undefined alias: null "

You can't use constants or nulls there. Why don't you just create a second constructor which takes two arguments and calls the first constructor?

gloeglm,

thank You, at least now I know it is not possible to use null in the constructor in SELECT clause. I don't want to create a constructor in this class, since this class has been generated automatically and every time I change DB, I generate all my persistent classes, so I don't want to creat anything in such classes.
But nonetheless thanks a lot

Maciek

inherit the generated class and add the constructor.

OK folks,

thank You a lot. I did, like you mentioned

regards
Maciek