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.