sqlite

[garry r fisher]

Hi,

Trying to use the Tcl bindings with sqlite on Cloverleaf v5.3 on W2K.

I can get sqlite to work quite happily if I copy the dll to the lib directory of my Activestate install. Obviously this won’t work on Cloverleaf so I copied it to the local Tcl/Lib directory but it isn’t recognised as a command. Looking at a number of forums/website they suggest using a pkgIndex so I created one and it still doesn’t work.

Can somebody provide me with the definitive installation instructions for tclsqlite3.dll? I want to use it on a production system and need to test it first – At the moment as you can see my testing is failing miserably:-(

Regards

Garry

Topic

[Charlie Bursell]

You need to build a pkgIndex file and put that in the Tcl path.  Since Tcl will search one level deeper than the paths defined in the auto_path variable, I typically put my phkIndex file in $HCISITEDIR/tclprocs/lib. As a matter of fact I usually put my database there as well.

sqlite is great.  You will like it

[garry r fisher]

Thanks Charlie,

Setup as you described. Something is not quite right. I start tcl, type ‘package require sqlite3’ and it drops back out to cmd.

I edited my pkgIndex.tcl manually – is that correct? Can you suggest any other reason why its not working? Very odd.

UPDATE : Spent a bit more time with it and read through the relevant chapter in Brent Welsh – I can get it to work in 5.4.1 but not in 5.3. Unfortunately for me the production system is on 5.3. Going copy the pkgIndex.tcl from the 5.4.1 to 5.3 directory and see if works.

UPDATE 2: No – That doesn’t work either. Tcl scripts run fine for most commands but if I try and do ‘package require sqlite3’ or pkg_mkIndex …. then it drops out of Tcl without reporting an error. I’ve tried it on two different 5.3 installs and they both do the same. So is it Tcl or the Windows version of Tcl causing the problem – 5.3 uses Tcl 8.3 while 5.4.1 uses Tcl 8.4.

Any ideas anyone?

Regards

Garry

[Charlie Bursell]

Send me an e-mail and I will send you what I have

[Gary Atkinson]

I’m curious  8) Is there a version for AIX?

[Charlie Bursell]

Yes, you may have to compile it

[Bala Pisupati]

I have ftp’ed tclsqlite-3.6.8.so on my redhat linux4.o platform. Can anyone tell me how to run the .so. I am really new to sqlite.

[Tom Rioux]

We are on a UNIX platform but I’m assuming it will pretty much the same.  Take the .so file and move it to you $HCISITEDIR/tclprocs/libs directory.   You will need to do this for every site you are using sqlite in.  (I’m not sure if putting in a master site on 5.6 will work for all sites or not).  When you begin to write your code, you will need to include the following line at the beginning of your proc:

package require sqlite

Let me know if you have any more questions.   You can do a search on here for sqlite.  There are many helpful threads on here that can get you started and provide good information in getting you started in writing your code.

Hope this helps….

Tom Rioux

Baylor Health Care Systems

[Tom Rioux]

One last note on the sqlite…Did you get your tclsqlite-3.6.8.so file from Healthvision.  I remember a couple of months ago when I was attempting to run my code, I kept getting an error.  I worked with Dean B. from Healthvision regarding the error and was told the file was one they were working on to be released with 5.7.  It wasn’t working quite like it should yet and I had to use the libsqlite3.3.4.so file instead.  Works just as good.  I think I remember this correctly and I’m not sure if the errors have been cleared up or not.

Hope this helps…

Tom Rioux

Baylor Health Care System

[Bala Pisupati]

Thanks for your replies.

I got this from http://www.sqlite.org/download.html not from HealthVision

[Tom Rioux]

My advice to you is to contact Healthvision support and get the sqlite version that is compatible with the Cloverleaf version you are currently running.  They are very helpful and can get you started.

As far creating your database, the command to do that is:

sqlite DBCMD .db

You can do this from your script that you write.

Thanks….

Tom Rioux

[Author]

Replies