Jump to content
panoss

Database (sqlite) examples with GUI?

Recommended Posts

panoss

Hi everybody!

I 'm new in autoit and I want to use it for database applcations creation (I want to replace ms Access with autoit apps).

I 'm trying to find some examples of db apps with GUI, preferrably using a SQLite database.

I have found some but they don't work, eg: KindEbook Wishlist. Au3 Script Database, addrbook

Are there any examples that run as they should?

I 'm using ISN Autoit Studio 1.07.

 

Share this post


Link to post
Share on other sites
FrancescoDiMuro
Posted (edited)

Hi @panoss, and welcome to the AutoIt forum :)

Take a look at _SQLite* functions in the Help file :) There are a lot of very well documented examples about SQLite :)

For the GUI, you can look at Koda Form Designer.

By the way, if you write in the Help file GUI or _GUI, there a lot of examples about all the controls you can implement in your application :)

If you have any other question, feel free to ask :)

 

Best Regards.

Edited by FrancescoDiMuro
  • Thanks 1

Click here to see my signature:

Spoiler

I will always thank you for the time you spent for me.
I'm here to ask, and from your response, I'd like to learn.
By my knowledge, I can help someone else, and "that someone" could help in turn another, and so on.

ALWAYS GOOD TO READ:

In case I am violating some pseudo Forum rule, or I am doing something wrong, I want let you know that I'm not doing this on purpose, and for this, I kindly ask you to send me a private message about the "bad content" I posted, in order to edit/remove it, and to not be warned wrongly.
Thanks in advance.

 

Share this post


Link to post
Share on other sites
panoss
Posted (edited)

Thanks for the welcome.

Yes I've seen the SQLite functions.

I 'm looking for an integrated example (db+GUI).

I found this one (even thoug it 's not SQLite), it works fine when I run it by double clicking on the .au3 file but not when I run a project in ISN Autoit Studio made out of the same .au3 file!!:o

It looks like the debugger halts it even though I click the resume button.

EDIT: I deactivated the debugger and I can run it at ISN Autoit Studio ...I guess the debugger has some issues.

Edited by panoss

Share this post


Link to post
Share on other sites
panoss
Posted (edited)
9 hours ago, AutoBert said:

http://ritzelrocker04.bplaced.net/wordpress/sqlite-tutorials/ are some tut's for SQLite and AutoIt (German language).

I 'm running this tutorial and I get an error message:

'SQLite.dll konnte nicht gelanden werden' (translated by translate.google: 'SQLite.dll could not be loaded ').

In the same directory with the script, I have these files:

_Biespel.sql

sqlite.au3

SQLite.dll.au3

sqlite.def

sqlite.dll

sqlite3_300801000.dll

 

It 's caused by the '_SQLite_Startup()' line 60.

 

EDIT: I placed in the script 's directory the 2 files (sqlite3.dll and sqlite3.def) contained in the zip file 'sqlite-dll-win32-x86-3240000.zip'
downloaded from https://sqlite.com/download.html seems to run.

Edited by panoss

Share this post


Link to post
Share on other sites
panoss
Posted (edited)

I run this tutorial.

I created a new project in ISN Autoit Studio based on the file 0021_Sqlite_StarterDB_Gui.au3. (I uploaded the whole project in the attachment)

In order to run it in  ISN Autoit Studio you have to comment out lines 12-16.

;Global Const $SS_SIMPLE = 0xB
;Global Const $SS_SUNKEN = 0x1000
;Global Const $ES_AUTOHSCROLL = 128
;Global Const $ES_READONLY = 2048
;Global Const $GUI_EVENT_CLOSE = -3

This way it runs in Studio.

I compiled it with these lines commented out and the exe would show an error and not run.

 

I removed the comments from these lines, compiled and the exe now would run properly!

 

What is happening?

02_SQLiteStarter-Tut.zip

Edited by panoss

Share this post


Link to post
Share on other sites
FrancescoDiMuro

I prefer to use SciTE editor, instead of the tool you are using :)


Click here to see my signature:

Spoiler

I will always thank you for the time you spent for me.
I'm here to ask, and from your response, I'd like to learn.
By my knowledge, I can help someone else, and "that someone" could help in turn another, and so on.

ALWAYS GOOD TO READ:

In case I am violating some pseudo Forum rule, or I am doing something wrong, I want let you know that I'm not doing this on purpose, and for this, I kindly ask you to send me a private message about the "bad content" I posted, in order to edit/remove it, and to not be warned wrongly.
Thanks in advance.

 

Share this post


Link to post
Share on other sites
panoss
Posted (edited)

What a pitty! It would be so nice if it worked as expected.

 

So, what would you suggest that I should use?

I 'm thinking of:

1. Editor: Scite

2. Debugger: AutoIt Debugger 0.47.0.0 (I see it has not been updated since 2011...)

3. Forms' editor: Koda

Edited by panoss

Share this post


Link to post
Share on other sites
jchd

For people new to SQLite, I'd recommend following the step by step approach:
  o) First install a nice 3rd-party SQLite DB manager named SQLite Expert
  o) Used this to design your DB
  o) Use the SQL tab to run the various SQL queries and statements you expect to be using
  o) Fine-tune the design as necessary
  o) Only then start coding your fancy GUI app.


This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.
Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe here
RegExp tutorial: enough to get started
PCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta.

SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.
SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.
An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.
SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)
A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!
SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)

Share this post


Link to post
Share on other sites
panoss
Posted (edited)

Ok, thank you for the suggestions, but I 'm not new to SQLite. I 'm new to Autoit.

Edited by panoss

Share this post


Link to post
Share on other sites
jchd

You might benefit from looking at this thread:

 

  • Thanks 1

This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.
Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe here
RegExp tutorial: enough to get started
PCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta.

SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.
SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.
An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.
SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)
A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!
SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×