Source language: Translate to:

DBSQLite 3 Plugin

Questions about NeoBook PlugIns

Moderator: Neosoft Support

DBSQLite 3 Plugin

Postby pfisterhamj » Sun Jun 03, 2012 1:07 am

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/
pfisterhamj
 
Posts: 39
Joined: Sun Sep 06, 2009 2:56 am

Postby HPW » Sun Jun 03, 2012 2:58 am

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
Hans-Peter
User avatar
HPW
 
Posts: 2520
Joined: Fri Apr 01, 2005 11:24 pm
Location: Germany

Postby dec » Sun Jun 03, 2012 3:27 am

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.
.
Enhance your NeoBook applications!
.
58 plugins, 1131 actions and 233 samples
.
NeoPlugins website: www.neoplugins.com
.
User avatar
dec
 
Posts: 1663
Joined: Wed Nov 16, 2005 12:48 am
Location: Spain

Hello

Postby pfisterhamj » Sun Jun 03, 2012 4:15 am

Hallo,

danke für die nette Begrüßung.

Als Programmiersprache hab ich hier Delphi 5 verwendet.



Hello,

thanks for the welcome.


Regards
pfisterhamj
 
Posts: 39
Joined: Sun Sep 06, 2009 2:56 am

Postby cp4w » Sun Jun 03, 2012 8:15 am

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
 
Posts: 533
Joined: Sun Apr 03, 2005 4:37 pm
Location: Great Neck, NY

Postby cp4w » Sun Jun 03, 2012 8:36 am

It would be good if, like the neobook, you could show a grid in a rectangle.
cp4w
 
Posts: 533
Joined: Sun Apr 03, 2005 4:37 pm
Location: Great Neck, NY

Postby pfisterhamj » Sun Jun 03, 2012 9:32 am

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
pfisterhamj
 
Posts: 39
Joined: Sun Sep 06, 2009 2:56 am

Postby cp4w » Sun Jun 03, 2012 10:08 am

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.
cp4w
 
Posts: 533
Joined: Sun Apr 03, 2005 4:37 pm
Location: Great Neck, NY

Postby pfisterhamj » Tue Jun 05, 2012 10:04 am

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
 
Posts: 39
Joined: Sun Sep 06, 2009 2:56 am

Postby pfisterhamj » Tue Jun 05, 2012 12:27 pm

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
 
Posts: 39
Joined: Sun Sep 06, 2009 2:56 am

Postby pfisterhamj » Wed Jun 06, 2012 11:14 am

Freeware plugin updated. The last correction of the PRO version (that are available at the Freeware version) are updated.
pfisterhamj
 
Posts: 39
Joined: Sun Sep 06, 2009 2:56 am

Postby pfisterhamj » Wed Jun 06, 2012 3:21 pm

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
 
Posts: 39
Joined: Sun Sep 06, 2009 2:56 am

Postby pfisterhamj » Wed Jun 06, 2012 4:50 pm

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.
pfisterhamj
 
Posts: 39
Joined: Sun Sep 06, 2009 2:56 am

Postby David de Argentina » Wed Jun 06, 2012 5:31 pm

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
User avatar
David de Argentina
 
Posts: 1560
Joined: Mon Apr 04, 2005 4:13 pm
Location: Buenos Aires, Argentina

Postby pfisterhamj » Thu Jun 07, 2012 9:03 am

Hello,

thanks. Your plugins are also very good.

Let's see how we can improve our products.


Best regards,
Jürgen
pfisterhamj
 
Posts: 39
Joined: Sun Sep 06, 2009 2:56 am

Next

Return to PlugIn Discussions

Who is online

Users browsing this forum: Yahoo [Bot] and 1 guest