When I try to construct join table & get "ResultSet" from "CCursor", I can just get all data in join table.
But, if I just need partial column in the join table, how could I do for this case?
Regards!
Alan #
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Um, I'm a little unclear as to what you need. What do you mean by a partial column?
The SQL generated by the framework works only on column names and does not provide for expressions in the select statements. The reasoning being that the framework is designed to persist objects to/from a database and you cannot save an expression.
That said, you can always write a view that uses expressions and map a readonly object to the view.
Maybe if you give me a better idea of what you are after I can help.
- Richard.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Dear seniors,
When I try to construct join table & get "ResultSet" from "CCursor", I can just get all data in join table.
But, if I just need partial column in the join table, how could I do for this case?
Regards!
Alan #
Hi Alan,
Um, I'm a little unclear as to what you need. What do you mean by a partial column?
The SQL generated by the framework works only on column names and does not provide for expressions in the select statements. The reasoning being that the framework is designed to persist objects to/from a database and you cannot save an expression.
That said, you can always write a view that uses expressions and map a readonly object to the view.
Maybe if you give me a better idea of what you are after I can help.
- Richard.