CAD Software Forum

Posted: **Sun Jan 01, 2023 6:44 am**

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 (101.85 KiB) Viewed 10036 times

</p>
Note, this is free, open-source software, I can only make fixes until my trial period ends. Enjoy!

Posted: **Sun Jan 01, 2023 9:41 am**

What make this script, please?

EDIT: Ha yes You can use a DB with lisp scripts! Very good! Thks.

Posted: **Tue Jan 03, 2023 8:04 am**

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.....

CAD Software Forum

SQLite for lisp

SQLite for lisp

Re: SQLite for lisp

Re: SQLite for lisp