Forum
× Components and Libraries for Database Development, discussions, problems and suggestions

Question Connexion to Sqlite3 database

  • Rimbaud
  • Rimbaud's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 month 2 weeks ago #14373 by Rimbaud
Connexion to Sqlite3 database was created by Rimbaud
Hi! Everybody;
I'm trying to connect to a sqlite3 database. All my project now is a form, a sqlite3dataset and a small sqlite3 database.
Each time i try to activate the dataset, a "Violation" error raise.

Does anybody can help me on this?

I'm on windows 64 bits version and a new user of code typhon.

Thanks in advance.
Attachments:

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #14374 by Jan Roza
Replied by Jan Roza on topic Connexion to Sqlite3 database
It is hard to see from one picture and no code what your problem can be, but try a different approach: Use a Sqlite3Connection and SQLQuery instead of the sqlite3dataset.
I've included a small demo database project I once wrote for a magazine which works this way, maybe it gives you ideas how to work with databases.
Attachments:

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #14375 by Matis A.
Replied by Matis A. on topic Connexion to Sqlite3 database

Rimbaud wrote: .....
I'm trying to connect to a sqlite3 database. All my project now is a form, a sqlite3dataset and a small sqlite3 database.
Each time i try to activate the dataset, a "Violation" error raise.

......


-Where are you sqlite3 libraries ?
-Your project is 64 or 32 bit ?

PilotLogic Core Programmer

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #14376 by Matis A.
Replied by Matis A. on topic Connexion to Sqlite3 database

Jan Roza wrote: ....
I've included a small demo database project I once wrote for a magazine which works this way, maybe it gives you ideas how to work with databases.


Sir can we put your sample to CodeOcean ?

PilotLogic Core Programmer

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago - 1 month 2 weeks ago #14377 by Jan Roza
Replied by Jan Roza on topic Connexion to Sqlite3 database
"Sir can we put your sample to CodeOcean ?"
Sure, no problem but maybe it would be better if I replace the dutch comments and text by english ones and then send you a new zip.
Attached is the (slightly translated version).
Attachments:
Last edit: 1 month 2 weeks ago by Jan Roza.

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #14378 by Matis A.
Replied by Matis A. on topic Connexion to Sqlite3 database
Yes, please

PilotLogic Core Programmer

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #14380 by Jan Roza
Replied by Jan Roza on topic Connexion to Sqlite3 database
The (slightly) translated version is attached to my previous message.
Thanks for including it.

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #14381 by Matis A.
Replied by Matis A. on topic Connexion to Sqlite3 database
Thanks Sir

PilotLogic Core Programmer

Please Log in or Create an account to join the conversation.