Information générale
Catégorie:
The Mere Mortals Framework
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement