SQLite - Tiny contribution

(Sample Scripts and Snippets)

SQLite - Tiny contribution

Unread postby Stefan Schnell » Fri Sep 26, 2014 9:10 pm

Hello community,

as a great fan of FBSL and SQLite here an include of the actual SQLite version and the actualized FBSL example of SQLite.

Update 15/03/06: New include file for actual SQLite version 3.8.8.3. Added new functions and a few constants.

Cheers
Stefan
Attachments
sqlite3.zip
(2.47 KiB) Downloaded 66 times
Last edited by Stefan Schnell on Fri Mar 06, 2015 7:27 pm, edited 2 times in total.
Visit my homepage
or meet me at XING or at the SCN
User avatar
Stefan Schnell
FBSL geek
FBSL geek
 
Posts: 132
Joined: Thu Aug 22, 2013 7:48 am
Location: Germany - Oberirsen

Re: SQLite - Tiny contribution

Unread postby Gerome » Sat Sep 27, 2014 2:35 pm

A big thanks Stefan !
BTW, your sample does not work with latest SQLITE version
Yours,

(¯`·._.·[Gerome GUILLEMIN]·._.·´¯)
:: Full SETUP w. HELP 05th of December 2011 ::
http://www.fbsl.net/setup/FBSLv3.exe [full v3.4.10 installation pack]
http://www.fbsl.net/setup/FBSLv3bin.zip [minimal upgrade to v3.4.10]
Laissons les jolies femmes aux hommes sans imagination. / Let us leave pretty women to men without imagination.(M.Proust)
The success is a defeat for the one who does not want to dance any more! (H.F. Thiefaine)
User avatar
Gerome
FBSL Administrator
FBSL Administrator
 
Posts: 3149
Joined: Sat Mar 12, 2005 9:06 pm
Location: Paris -- France

Re: SQLite - Tiny contribution

Unread postby Stefan Schnell » Mon Sep 29, 2014 11:06 am

Hello Gerome,
thank you very much for your reply.
I check it out and in my case the example works on Windows 7 SP1 32bit and 64bit perfect.
I use SQLite from 2014/08/15 with the version 3.8.6.0. The SQLite database file was created without any error.
Cheers
Stefan

001.jpg
001.jpg (15.17 KiB) Viewed 987 times


002.jpg
002.jpg (94.44 KiB) Viewed 987 times
Visit my homepage
or meet me at XING or at the SCN
User avatar
Stefan Schnell
FBSL geek
FBSL geek
 
Posts: 132
Joined: Thu Aug 22, 2013 7:48 am
Location: Germany - Oberirsen

Re: SQLite - Tiny contribution

Unread postby Stefan Schnell » Fri Mar 06, 2015 7:21 pm

Hello community, hello Egor,

here an example how to use SQLite in multi-thread mode:

Code: Select all
//-Begin----------------------------------------------------------------

  //-Directives---------------------------------------------------------
    #AppType Console
    #Option Strict

  //-Includes-----------------------------------------------------------
    #Include <Include\sqlite3.inc>

  //-Main---------------------------------------------------------------
    Sub Main()

      //? "SQLite version ", sqlite3_libversion_number()
      ? "SQLite version ", Peek(sqlite3_libversion(), $16)
      Pause

      If sqlite3_threadsafe() > 0 Then
        ? "Library is threadsafe"
      Else
        ? "Library is not threadsafe"
        Exit Sub
      End If

      If sqlite3_config(SQLITE_CONFIG_MULTITHREAD) = SQLITE_OK Then
        ? "Set library in multithread mode"
      Else
        ? "Can't set library in multithread mode"
        Exit Sub
      End If

      If sqlite3_initialize() = SQLITE_OK Then



        If sqlite3_shutdown() <> SQLITE_OK Then
          ? "Error: Can't shutdown"
        End If
      Else
        ? "Error: Can't initialize"
      End If

      Pause

    End Sub

//-End------------------------------------------------------------------


Cheers
Stefan
Visit my homepage
or meet me at XING or at the SCN
User avatar
Stefan Schnell
FBSL geek
FBSL geek
 
Posts: 132
Joined: Thu Aug 22, 2013 7:48 am
Location: Germany - Oberirsen


Return to FBSL v3 Samples Repository

Who is online

Users browsing this forum: No registered users and 1 guest

cron