I have a function, which selects data from two tables. With LiveCode I get an error.
Code: Select all
function selectFieldsPisos
local tQuery, tData
put "SELECT f.finca, p.pis, p.lloguer, p.rebut FROM Pisos AS p, Finques AS f WHERE p.pisID ='" & field "ID" & "' AND p.fincaID = f.fincaID" into tQuery
put textDecode(revDataFromQuery(tab, cr, gDatabaseID, tQuery),"UTF-8") into tData
return tData
end selectFieldsPisos
What is It wrong in the function?
Carles