Because a view can be updatable, there is no way that field could be updated, hence the error.


>When coding a SQL statement for a view, I used the “AS” statement to combine three character fields into one field:
>
>CREATE SQL VIEW lv_contview AS ;
>SELECT Contracts.*, Titles.titleno, Titles.itemno, Titles.authorno,;
> Titles.titlename, Titles.paythis, Titles.perc_used, Titles.dateroypai,;
> Titles.itemname, Titles.tnotes, Authors.authorname,;
> contracts.contractno+titles.titleno+titles.itemno as titno ;
> FROM contapp!contracts INNER JOIN contapp!titles;
> INNER JOIN contapp!authors ;
> ON Titles.authorno = Authors.authorno ;
> ON Contracts.contractno = Titles.contractno;
> ORDER BY Contracts.contractno
>
>The line of interested in is:
>
> contracts.contractno+titles.titleno+titles.itemno as titno
>
>I tried to add DBSETPROP lines in “VIEWS.PRG” but had to remove them due to continual errors. I found that it worked fine as long as the “TITNO" phrase was in the actual SQL statement, with no reference to it in the DBSETPROP statements. I am very keen to know if this is correct, if not what DBSETPROP statements should be added.
>
>Thanks Allan Godney.