Current Status of El Choni's SQLite Library?

ebs · Post by **ebs** » Mon May 03, 2004 5:53 pm

I've looked through the message threads, but I'm not sure what the exact status of the SQLite library is.
I'm using PB 3.90 and the matching version of jaPBe.

I get nonsensical errors when executing simple SQL "INSERT" statements,
and my program crashes when running from the jaPBe IDE. I didn't have
any problems when using previous PB versions, including 3.81 (I think).

Should the SQLite library work with the current PB compiler version?

Karbon · Post by **Karbon** » Mon May 03, 2004 6:18 pm

Yes, I'm using 3.90 + some beta libs (note, not the full 3.91 beta) and I use SQLite in several projects - no problems yet..

There are some problems if you open/use more than one SQLite DB, I think he is working on the new version now...

ebs · Post by **ebs** » Tue May 04, 2004 1:06 am

I found out why I was getting SQLite errors and my program was crashing, so I want to share it with you!

My code looked like this (simplified):

Code: Select all

Person.s = "Smith, John"
SQLiteExec("INSERT INTO StatusTable VALUES('" + Person + "','OUT','')")

When I inserted "Debug Person" statements before and after the SQLiteExec call, I discovered that the variable Person had changed!

When I rewrote my code this way:

Code: Select all

Person.s = "Smith, John"
Ins.s = "INSERT INTO StatusTable VALUES('" + Person + "','OUT','')"
SQLiteExec(Ins)

all the problems went away!

I'm guessing that trying to concatenate the strings directly in the SQLiteExec call somehow overwrote the variable. Can anyone tell me exactly why this should/shouldn't work?

Eric

El_Choni · Post by **El_Choni** » Tue May 04, 2004 1:20 am

Because it's a bug (fixed in next version)

Regards,

ebs · Post by **ebs** » Tue May 04, 2004 12:26 pm

El Choni,

Thanks for the fast reply, and for the fix!

Regards,
Eric

Karbon · Post by **Karbon** » Tue May 04, 2004 12:31 pm

New SQLite?

El_Choni · Post by **El_Choni** » Tue May 04, 2004 1:03 pm

Yes. I rewrote the whole thing, with the same syntax but bugfixed and threadsafe. However, I'm still at the point where it doesn't compile (some problems with Fasm macros). Then, testing will come, etc. I hope you'll offer yourselves as betatesters...

Regards,

Karbon · Post by **Karbon** » Tue May 04, 2004 1:05 pm

Sure!

Send anything over by email/IRC/PM

Karbon · Post by **Karbon** » Tue May 04, 2004 1:11 pm

Remember that patched userlib you sent me to make sure that the SQLite DLL loading is the one passed to SQLiteInit()? Are those fixes/changes in the new version? That is very important to several of my projects (as I use modified SQLite libs..)

El_Choni · Post by **El_Choni** » Tue May 04, 2004 1:36 pm

Yes, that's included in the new version. The only change your userlib has is that thing you mention.

Karbon · Post by **Karbon** » Sat May 08, 2004 11:25 am

Hey El, does the current lib return #SQLITE_BUSY properly? It doesn't seem to in my tests.. I'm trying to detect if anyone else is writing to the db before I allow the current user to. My initial method was to loop the exec procedure to test for #SQLITE_BUSY and if it found it to sleep for a few miliseconds and try again - it doesn't seem like #SQLITE_BUSY ever gets returned though.

El_Choni · Post by **El_Choni** » Sat May 08, 2004 1:28 pm

Yes, it returns errors from sqlite.dll. I've never received SQLITE_BUSY, probably because I never accessed a sqlite db concurrently.

Regards,

ebs · Post by **ebs** » Thu Jun 10, 2004 8:05 pm

El Choni,

Hello!

Any news about an updated version of your SQLite library?

I have one additional question for you to think about. I am trying to be able to detect if the network connection to the database is lost. I use code like the following (SQL is a string variable):

Code: Select all

If SQLiteGetTable(SQL) = 0
    ; success - do something
Else
    ; failure
    MessageRequester("Database Error", "Database connection lost!", #MB_ICONERROR|#MB_OK) 
EndIf

The funny part is that if I unplug my network cable, I DON'T get any error!

I will get an immediate error if I try to use:

Code: Select all

SQLiteExec(SQL)

when the network is disconnected, though.

Do you have any idea why no error occurs? I always use:

Code: Select all

SQLiteRemoveData()

after I'm done with a table, but I don't think that makes any difference.

Any help will be greatly appreciated!

Eric

Karbon · Post by **Karbon** » Thu Jun 10, 2004 8:07 pm

Ebs: The network being disconnected would be like the hard drive that the database file was living on being ripped out while the database was still open - I'd expect an immediate error (if not a total crash) in that case

ebs · Post by **ebs** » Thu Jun 10, 2004 9:22 pm

Ebs: The network being disconnected would be like the hard drive that the database file was living on being ripped out while the database was still open - I'd expect an immediate error (if not a total crash) in that case

Mitch,

I'm not sure that I'd expect an immediate error, but I certainly would expect one the next time I tried to retrieve data from the database! That's what puzzles me!

Eric

PureBasic Forums - English

Current Status of El Choni's SQLite Library?

Current Status of El Choni's SQLite Library?

I Learned a Valuable Lesson!!!