So I’ve included a build (SQLiteLspIC11x64.irx) at https://www.theswamp.org/index.php?topic=28286.0
There’s few samples in the package, plus the development history at the swamp thread
Code: Select all
(DEFUN C:TEST123 ( / a db)
(SETQ DB "E:/chinook/chinook.db")
(DSQL_OPEN DB)
(setq Q "SELECT
trackid,
tracks.name AS Track,
albums.title AS Album,
artists.name AS Artist
FROM
tracks
INNER JOIN albums ON albums.albumid = tracks.albumid
INNER JOIN artists ON artists.artistid = albums.artistid
WHERE
artists.artistid = 10;")
(SETQ A (DSQL_ASSOCQUERY DB Q ))
(DSQL_CLOSE DB)
A
)
Note, this is free, open-source software, I can only make fixes until my trial period ends. Enjoy!