SQLite: free embedded database in TD applications

Post your tools and samples or ask for them.
Dave Rabelink
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 1161
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

SQLite: free embedded database in TD applications

Post by Dave Rabelink » 26 Dec 2018, 21:20

A new article has been added to TD Wiki:

SQLite: free embedded database in TD applications

How to use SQLite in TD using native TD API libraries implementing the C(++) DLL interface.
It shows a fully working example using local databases and a memory database.
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

FRBhote
India
Posts: 1232
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Re: SQLite: free embedded database in TD applications

Post by FRBhote » 27 Dec 2018, 05:48

Very Interesting.

Jeff Luther
Site Admin
Site Admin
United States of America
Posts: 2167
Joined: 04 Mar 2017, 18:34
Location: Palm Springs, California

Re: SQLite: free embedded database in TD applications

Post by Jeff Luther » 27 Dec 2018, 19:38

Dave -- Great write-up, professional and well-written as always! Thanks much from me and on behalf of all of us here on the Forum.

And let me wish the Best of 2019 to you and to all the members and visitors to your TD Forum site!
Jeff Luther @ PC Design
Palm Springs, California
TD info. & samples: http://www.jeffluther.net/TD/

LarsAke
Sweden
Posts: 12
Joined: 23 Nov 2017, 15:59
Location: Stockholm/Sweden

Re: SQLite: free embedded database in TD applications

Post by LarsAke » 27 Dec 2018, 20:16

This was very interesting but when I try to run the app SQLite3_CountriesFlags_Sample.apt in TD version 6.2 I get this error in the function SQLite_LibVersion (see attached file)!
You do not have the required permissions to view the files attached to this post.

Dave Rabelink
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 1161
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

Re: SQLite: free embedded database in TD applications

Post by Dave Rabelink » 27 Dec 2018, 20:31

LarsAke wrote:
27 Dec 2018, 20:16
...TD version 6.2 I get this error in the function SQLite_LibVersion (see attached file)!
Strange. It runs here with TD 6.2.
Which SP are you using?

(I'm running TD 6.2 SP5)
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

LarsAke
Sweden
Posts: 12
Joined: 23 Nov 2017, 15:59
Location: Stockholm/Sweden

Re: SQLite: free embedded database in TD applications

Post by LarsAke » 27 Dec 2018, 22:44

I am running SP2!
I don't know what I did but now it seems to be working, very strange but good:-)

Dave Rabelink
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 1161
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

Re: SQLite: free embedded database in TD applications

Post by Dave Rabelink » 28 Dec 2018, 07:38

Jeff Luther wrote:
27 Dec 2018, 19:38
Dave -- Great write-up, professional and well-written as always! Thanks much from me and on behalf of all of us here on the Forum.

And let me wish the Best of 2019 to you and to all the members and visitors to your TD Forum site!
Thanks Jeff!
For you and all on the forum, a great new year and the best wishes for 2019.
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

a_sivababu
India
Posts: 63
Joined: 10 Mar 2017, 08:46
Location: Chennai,India

Re: SQLite: free embedded database in TD applications

Post by a_sivababu » 30 Dec 2018, 05:41

Very nice Article Dave and as usual, there is good amount of work you put in to show this one as well. This is definitely going to be 2019 bonus for forum visitors :-)

I think year 2019 is going to be good year for all open source databases including SQLLite.

Wish you many happy new year to forum users and Guests :-)

Return to “Tools & Samples”

Who is online

Users browsing this forum: No registered users and 0 guests