Welcome, Guest
Username: Password: Remember me
Components and Libraries for Database Development, discussions, problems and suggestions
  • Page:
  • 1

TOPIC:

Connexion to Sqlite3 database 4 years 9 months ago #14373

  • Rimbaud
  • Rimbaud's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 1
  • Thank you received: 0
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.

Connexion to Sqlite3 database 4 years 9 months ago #14374

  • Jan Roza
  • Jan Roza's Avatar
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 173
  • Thank you received: 6
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.
Operating Systems Windows 11 and Linux Mint (64-bit) and virtual Raspberry Pi Desktop
Attachments:

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

Connexion to Sqlite3 database 4 years 9 months ago #14375

  • Matis A.
  • Matis A.'s Avatar
  • Away
  • Moderator
  • Moderator
  • Posts: 1106
  • Thank you received: 162

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.

Connexion to Sqlite3 database 4 years 9 months ago #14376

  • Matis A.
  • Matis A.'s Avatar
  • Away
  • Moderator
  • Moderator
  • Posts: 1106
  • Thank you received: 162

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.

Connexion to Sqlite3 database 4 years 9 months ago #14377

  • Jan Roza
  • Jan Roza's Avatar
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 173
  • Thank you received: 6
"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).
Operating Systems Windows 11 and Linux Mint (64-bit) and virtual Raspberry Pi Desktop

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

Last edit: by Jan Roza.

Connexion to Sqlite3 database 4 years 9 months ago #14378

  • Matis A.
  • Matis A.'s Avatar
  • Away
  • Moderator
  • Moderator
  • Posts: 1106
  • Thank you received: 162
Yes, please
PilotLogic Core Programmer

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

Connexion to Sqlite3 database 4 years 9 months ago #14380

  • Jan Roza
  • Jan Roza's Avatar
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 173
  • Thank you received: 6
The (slightly) translated version is attached to my previous message.
Thanks for including it.
Operating Systems Windows 11 and Linux Mint (64-bit) and virtual Raspberry Pi Desktop

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

Connexion to Sqlite3 database 4 years 9 months ago #14381

  • Matis A.
  • Matis A.'s Avatar
  • Away
  • Moderator
  • Moderator
  • Posts: 1106
  • Thank you received: 162
Thanks Sir
PilotLogic Core Programmer

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

Connexion to Sqlite3 database 1 year 6 months ago #17779

  • HIGH-Zen
  • HIGH-Zen's Avatar
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 32
  • Thank you received: 1
Finally Sqlite3dataset bug is fixed.
To topic author and others that have problems with Sqlite3dataset.
 

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

  • Page:
  • 1