hpwSQLite help with query syntax

#1 · June 7, 2024, 5:49 pm

I just found out that hpwSQLite plugin is avaliable for VisualNeo Win and I like to use it on my apps.
I looked at the sample app, but I don't know how to create a new table using your plugin...

I tested with:

CREATE TABLE test (id INTEGER PRIMARY KEY AUTOINCREMENT,username TEXT UNIQUE NOT NULL);

And not working.
I like to know in what format I should use sqlite query commands to work on hpwSQLite plugin.

(Also about other queries, like delete tables, and other CRUD commands, is there a detailed guide or any website to use?)

Thanks for the great and free plugins!

#2 · June 7, 2024, 7:45 pm

Hello,

As you can see on my page this plugin is quite aged and base on a sqlite dll of version 2.X.

https://www.hpwsoft.de/anmeldung/html1/neobook/neobook12.html

That was created in 2003. And in the last years I have not used it myself aktivly.

In the last time my delphi development work also has come down.

I am getting older and my own resources gets more and more limited.

Sorry that I can not help.

Regards,

Hans-Peter

luishp, Vadim and 2 other users have reacted to this post.

#3 · June 7, 2024, 10:05 pm

Hi there bro!

after posting I looked at the page and yeah thats toooo old but it's all okay, nothing important, I think plugin it's still useful and I have another options too.

I'm getting old also and I understand you, thanks again for whole hpw plugin pack I use many of them...

Regards and Respect.

luishp and luiz have reacted to this post.

hpwSQLite help with query syntax - Forum

hpwSQLite help with query syntax