SQLite for lisp

#1
Great job on the ICARX wrappers. My SQLiteLsp routine compiled without issue.
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
)
SQliteLisp for CMS.png
SQliteLisp for CMS.png (101.85 KiB) Viewed 1534 times
</p>
Note, this is free, open-source software, I can only make fixes until my trial period ends. Enjoy!

Re: SQLite for lisp

#3
Hi Danielm103,
How to start the DB SQL demon, please? Or where, what irx file to copy in CMS IntelliCAD please?
I have IntelliCAD 10.0.1572.123806.PE.VC15.x64.CMS100a
Your SQLiteLspIC11x64.irx run for IntelliCAD 11.

TRACEBACK 1

Code: Select all

Command: _APPLOAD
Loading C:\Lisp\SqliteLsp\SQLiteBIN\SQLiteLspIC11x64.irx
Command: 
One of the library files needed to run "c:\lisp\sqlitelsp\sqlitebin\sqlitelspic11x64.irx" cannot be found.
error: LOAD failed

EDIT: Ok I follow your tread on TheSwamp forum now.....
Patrick Depoix
Architecte D.P.L.G. & Historien-chercheur en histoire de l'Architecture