LabWindows/CVI

cancel
Showing results for 
Search instead for 
Did you mean: 

SQLite

Hi gurus,

I am interested in integrating SQLite into my application.
It is marvelous piece of code, small, simple (everything is relative...),
fast and free, well tested etc.
There is a beautiful VI wrapper for Labview, but nothing for CVI.
I made an attempt to build an instrument driver, but it is beyond me, I am
just a plain biologist with a bunch of data, currently in text files...
Is anybody out there who tried to do embed SQLite in a CVI application and
SUCCEDED?
If there is enough interest, we could suggest that NI adds a sqlite.fp in
the next release...

regards: lajos

0 Kudos
Message 1 of 4
(5,865 Views)
Lajos,

Although I don't consider myself a "guru", I have something here that might be of some help to you.

It is an SQLite function-panel/DLL set (with SQLite source included) that was done a few years ago by someone I regard as an expert CVI "guru". I cannot confirm who the author was, butI believe it was Guillaume Dargaud (see http://www.gdargaud.net). However, I recall that I got it from somewhere other than his own web site (where he has many other CVI apps and source code for download, you should check out his site). The reason why I think it was him because there it references "iso646.h" and "def.h", which are custom header files that he uses throughout his other work (I added these into to this ZIP file I attached to this posting, at 797,728 bytes).

Inside that ZIP file are the two original SQLite ZIP files that were authored by Guillaume. In the top level ZIP file is a CVI 8.0 workspace file that I created that show how to use the work that he had started into a typical project layout of your own. You might even be able to open the *.cws file in CVI 6.x and 7.x, not sure though...

You should know that there are very few "non-NI" locations where CVI code is available, and that Guillaume's site is at the top of the list. Another one worth mentioning is the "Rebel CVI" site, which by the way has info on using MySQL in CVI (http://perso.orange.fr/philippe.baucour/). It is in French, but you can load any interesting web page URLs into http://BabelFish.Altavista.com/ to translate to English or whatever.

Another "non-NI" place to get specialized help is the original CVI mailing list, which I know has been around for well over 10 years now, and although it does not have much traffic on it anymore (now that NI has these forums) it still has about a couple hundred subscribers, who are "gurus" of CVI, some, like me, since CVI versions 2.0 (DOS) or 3.0 (Win16), who might take the time to answer a question now and then. In fact, I vaguely recall that this is where Guillaume once offered up this SQLite function-panel/DLL set.

This list is still hosted on a Texas A&M University server, the address is: INFO-LW@LISTSERV2.TAMU.EDU (send the command SUBSCRIBE INFO-LW in the body of the email to subscribe to it), but you might want to start here first: http://www.lsoft.com/scripts/wl.exe?SL1=INFO-LW&H=LISTSERV2.TAMU.EDU

Also, there is a new "NI Community" site that NI has in beta right now (http://community.ni.com/), where "gurus" can submit their example code for all to use. I am hoping that this provides a great future repository for us all someday, especially the CVI community, which really needs something like this...

Jumper Bones
--
To whom it may concern: My alias is also my nickname, I've had it since I was a (very) skinny basketball-playing teen. OK, so I've got a 38 inch waist now, but my hometown friends haven't shaken that appellation for me. I trust that you will someday be OK with that alias, as I have been with that nickname.
Message 2 of 4
(5,842 Views)
Thank you! It helps. One question remains though! I keep getting an error message that labwin can not handle the long long declaration for the 64bit integers. I never used _I64, and this is a kind of problem... There is no decent description of _I64 in Labwindows and code compatibilities. greetings! layosh
0 Kudos
Message 3 of 4
(5,758 Views)

Although the long long type is not supported in CVI, you should be able to use __int64, which is. Note there are some issues in using this, as discussed here.

JR

0 Kudos
Message 4 of 4
(5,750 Views)