In the YouTube Livecode channel there is the video: Learn to Code: A Local Database with Michael McCreary that uses the libDB.livecodescript library
I have a few questions:
A library is created as a normal stack and then the livecode extension is changed by livecodescript?
It is always an individual stack on the same level as the application or it can be a substack. If so, what is better?
If the ID connection is in the library, can I use it from the mainStack? In principle queve that a local variable of the stack of the library
From the library, you could make a similar query to this. If you know how to do it
Code: Select all
SELECT finca Property, d.anyo Year, l.Income , d.Expenses
FROM Finques f
LEFT JOIN (
SELECT fincaID, anyo , sum(total) Expenses
FROM Despeses
GROUP BY fincaID, anyo) d
ON f.fincaID = d.fincaID AND l.anyo = d.anyo
LEFT JOIN (
SELECT fincaID, anyo, sum(total) Income
FROM Lloguers
GROUP BY fincaID, anyo ) l
ON l.fincaID = f.fincaID AND l.anyo = d.anyo
Carles