Page 1 of 2

DBSQLite 3 Plugin

PostPosted: Sun Jun 03, 2012 1:07 am
by pfisterhamj
Hello,

I've created a plugin that can deal with the SQLite3 Database API. Hope you enjoy my plugin.

For simple usage I released a Freeware edition. This edition has not all features of the shareware but try it on your own.

Version 1.0 released

http://dbsqlite.alldaysoftware.com/

PostPosted: Sun Jun 03, 2012 2:58 am
by HPW
Hallo,

Schön mal wieder einen deutschen Plugin-Entwickler zu sehen!
Viel Erfolg.
Verwendete Programmiersprache?


Nice to see a german plugin developer again.
I wish you much success.
Used programming language?

Regards

PostPosted: Sun Jun 03, 2012 3:27 am
by dec
Hi to tall,

I also hope you get success with your plugin.

So welcome and congratulations Jürgen! :wink:

If need some help, don't hesitate to ask here.

Hello

PostPosted: Sun Jun 03, 2012 4:15 am
by pfisterhamj
Hallo,

danke für die nette Begrüßung.

Als Programmiersprache hab ich hier Delphi 5 verwendet.



Hello,

thanks for the welcome.


Regards

PostPosted: Sun Jun 03, 2012 8:15 am
by cp4w
Great ! ,

This is important because I would rather not need to use ODBC connection to sqlite.

I like your help files.

It would just be easier to test the plug-in if you included some sample pubs.

Thanks

PostPosted: Sun Jun 03, 2012 8:36 am
by cp4w
It would be good if, like the neobook, you could show a grid in a rectangle.

PostPosted: Sun Jun 03, 2012 9:32 am
by pfisterhamj
Hello shx,

I'm working on some examples. They will be available through my homepage.

Grids I don't have planned yet. But I take it on my list.

Possible workaround:
My favorite Grid is npGrids. You can use it in combination with the dbSQLite3_ExecSQL action. This action calls on each result of a query a NeoBook subroutine you defined. Then you can fill the grid.



Currently I'm working on some actions that makes it easier to do standard tasks.


Thanks for your feedback

PostPosted: Sun Jun 03, 2012 10:08 am
by cp4w
Thanks for your quick response.

I really like what you have done so far.

I also like very much your help files.

I am going to purchase this,

Thank you.

PostPosted: Tue Jun 05, 2012 10:04 am
by pfisterhamj
Just release DBSQLite3 1.0.1.1

1.0.1.1
    *If an error occurs at on dbSQLite3_ExecSQL the variable [LastError] will be set
    * NEW ACTION dbSQLite3_ParentChild under utils is added.
    * Help file updated
    * dbSQLite3_BindInt und dbSQLite3_BindDouble now working with alphanumeric and numeric parameters.
    * The Textfield on the dialogs dbSQLite3_ExecSQL and dbSQLite3_CreateStatement now have vertical scrollbars. Now scrolling with the mouse wheel is possible



I've also create a small SQL-Tutorial with an example pub that shows you who to work efficient and quick mit DBSQLite.

Have fun!

PostPosted: Tue Jun 05, 2012 12:27 pm
by pfisterhamj
Just released: 1.0.2.1

    * Added: Syntax highlighting for SQL scripts that are inserted by using the actions dbSQLite3_ExecSQL and dbSQLite3_CreateStatement
    * Dialog for action dbSQLite3_CreateStatement redesigned for better usuability
    * Offline Help and WebHelp updated

PostPosted: Wed Jun 06, 2012 11:14 am
by pfisterhamj
Freeware plugin updated. The last correction of the PRO version (that are available at the Freeware version) are updated.

PostPosted: Wed Jun 06, 2012 3:21 pm
by pfisterhamj
Hello,

for better understanding, what can be done with DBSQLite I've linked a example, that I use for my personal purposes.

Look under Read world example. There you can see that I successfully imported movies from an online DB (in german) into NeoBook. All import to the sqlite database is done with DBSQLite3.

PostPosted: Wed Jun 06, 2012 4:50 pm
by pfisterhamj
Can't sleep, so I've implemented a new action for the the Pro-Version:

just released: PRO Version 1.0.3.1

dbSQLite3_LastRowID


For details look into the WebHelp: http://dbsqlite.alldaysoftware.com/documents/webhelp/


So, now I can try to sleep


Good night.

PostPosted: Wed Jun 06, 2012 5:31 pm
by David de Argentina
Hi overthere !

Nice job !

Take a look of this link:

http://www.neosoftware.com/forum/viewtopic.php?t=16104

Perhaps you could improve this service.

Greetings from Buenos Aires,

David de Argentina

PostPosted: Thu Jun 07, 2012 9:03 am
by pfisterhamj
Hello,

thanks. Your plugins are also very good.

Let's see how we can improve our products.


Best regards,
Jürgen