>>Hi,
>>
>>Is it possible to add a column/field to a cursor created with Cursor Adapter? I tried ALTER TABLE and it does not work. And as far as adding a column I don't need the base table to be updated when entry in this column is set or changed. Basically this "extra" column won't have a corresponding field in the base table and I need it only to hold data for the UI tier. Before I try a different approach I thought I would ask to see if it can be done with cursor adapter. TIA.
>
>I believe you should be able to include computed column in the query and in the fields mapping simply omit this field.
I know that I can include the column in the query. But my CA cursor is created by a BIZ object that relies on a meta table of all "real" fields in the base table. And I don't want to change or break the BIZ class code. Just in this particular case I need to have an additional field in the cursor. From your message I get it that it is not possible once the cursor is created. So I suppose I will have to change the approach of what I am trying to do. Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham