Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Trying to use SQLite


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 2 - Last Post: Nov 29, 2017 1:11 PM Last Post By: Robert Evans Threads: [ Previous | Next ]
G. Smith

Posts: 44
Registered: 5/3/03
Trying to use SQLite  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 18, 2017 8:45 AM
I'm using XE8, and trying the tutorial: "Connecting to a SQLite Database from a VCL Application"

It doesn't work of course. An exception is generated: EExternalException (which tells me nothing) and then a number of "Access violation at 0x000000000" exceptions.

Once again, I am dissapointed with the (lack of suitable) documentation.

I presume that there is some code, somewhere, trying to use a SQLite DLL. (I'm guessing of course, I can find no reference to this in the documentation). If this is the case, where do I tell it which file to use (whih version of the DLL) and where it is?

I'm trying to use SQLite3.dll. And it's in the subdirectory containg the Delphi project files.

Can anyone help? Please?
G. Smith

Posts: 44
Registered: 5/3/03
Re: Trying to use SQLite  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 29, 2017 8:28 AM   in response to: G. Smith in response to: G. Smith
I have marked the question as unanswered because nobody answered it.
Robert Evans

Posts: 114
Registered: 10/16/99
Re: Trying to use SQLite  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 29, 2017 1:11 PM   in response to: G. Smith in response to: G. Smith
In article <949761 at forums dot embarcadero dot com>, G. Smith <?@?.?.invalid>
wrote
I have marked the question as unanswered because nobody answered it.

I'm not sure what you expect to achieve by that. However:

1. There is perfectly good documentation in the DocWiki on using SQLite
with FireDAC and also example code. Start at:
http://docwiki.embarcadero.com/RADStudio/Tokyo/en/SQLite_support_in_RAD_Studio

2. You can dynamically link the SQLite client libraries (including the
DLLs provided for Win32 and Win64) but it is simpler (and usually
better) to use the statically linked libraries as explained in the
documentation.

--
Bob Evans
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02