 |
Tech
GURU
Joined: 18 Oct 2000
Posts: 2733
Location: Atlanta, USA
|
 Posted: Wed Aug 04, 2010 3:32 pm
[3.22a] Feature Request
|
Hey Zugg,
Any chance of upgrading to SQLite 3.6.19? That's when they introduced foreign key constraints and I'd like to be able to use that instead of triggers to enforce my foreign keys. I'm sure other folks would like that as well. |
|
_________________
Asati di tempari! |
 |
|
|
Zugg
MASTER
Joined: 25 Sep 2000
Posts: 23379
Location: Colorado, USA
|
Posted: Wed Aug 04, 2010 5:13 pm
|
Can you just try renaming the SQLite 3.6.19 file to SQLite3.DLL and replace the file in your CMUD program files directory and see if it works? That's all I would be able to do here.
If there are actual changes to the SQLite API then I doubt I will do much with it. CMUD uses SQLite via the ZeosLib database library for Delphi. And I'd need to see if ZeosLib has been updated for the new version or not. It's a far amount of work for me to do that update.
But if the API didn't change and the DLL is compatible then it would be easy for me to just distribute the new DLL with CMUD. |
|
|
|
|
Taz
GURU
Joined: 28 Sep 2000
Posts: 1395
Location: United Kingdom
|
Posted: Wed Aug 04, 2010 6:35 pm
|
I couldn't find a download for 3.6.19 but I downloaded 3.7.0.1 and the file inside the zip was already called sqlite3.dll so I just copied it over the existing one. CMUD ran and I was able to open a session and it's related packages so I can only assume that it worked fine.
Is it also safe to assume that everything that was in 3.6.19 is in 3.7.0.1?? |
|
_________________
Taz :) |
|
|
|
Tech
GURU
Joined: 18 Oct 2000
Posts: 2733
Location: Atlanta, USA
|
Posted: Wed Aug 04, 2010 7:23 pm
|
Yes... and you actually beat me to it. It looks like it works. I was able to create the DB and view with no issues. If I run into any issues I'll let you know.
[Edit] FYI, here's the download link. http://www.sqlite.org/sqlitedll-3_7_0_1.zip |
|
_________________
Asati di tempari! |
|
|
|
|
|
|
