DBSQLite 3 Plugin

[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/

[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

[dec]

Hi to tall,

I also hope you get success with your plugin.

So welcome and congratulations Jürgen!

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

[pfisterhamj]

Hallo,

danke für die nette Begrüßung.

Als Programmiersprache hab ich hier Delphi 5 verwendet.



Hello,

thanks for the welcome.


Regards

[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

[cp4w]

It would be good if, like the neobook, you could show a grid in a rectangle.

[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

[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.

[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!

[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

[pfisterhamj]

Freeware plugin updated. The last correction of the PRO version (that are available at the Freeware version) are updated.

[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.

[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.

[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

[pfisterhamj]

Hello,

thanks. Your plugins are also very good.

Let's see how we can improve our products.


Best regards,
Jürgen