Sign in to follow this  
Followers 0
RWJ

Build GUI from SQLite database

4 posts in this topic

I have an Idea to build a GUI Like Menu's and Treeviews from database records

IE: a table could look like

Category (main menu)

Menu item

Menu action

or somthing lik this.

Did anyone create this once before? I hate doing thing which have been done before.

any other ideas?

Share this post


Link to post
Share on other sites



A database table as

Category

Menu item

Menu action

.. How do you expect to translate the records into a menu?

Maybe make some drawings or a concept...

Share this post


Link to post
Share on other sites

It's simple just use standard 

_SQlite_Query with your SELECT

and

While _SQLite_FetchData () = $SQLITE_OK 

WEnd

Inside this loop place your GUICtrlCreate commands for menu or treeview.

There is no exactly the same solution here. Just look into Autoit's helpfile at examples and put pieces of code together.

Share this post


Link to post
Share on other sites

Thanks Zedna Thats the idea, but I never done SQL(ite) before

@ Manadar: Yes, I like to build the menu's (with commands) and treeview from the tables.

The Idea is this:

The screen is split in three parts. in the left part of the screen about 20% of the screen resides the treeview which are Windows Active Directory properties of AD items (user: User name, email, phone,... or Computers: computername, location, ... and so on

and below the treeview a search field and button

The right part of the screen is split in 2 parts above each other.

The search entry is searched in a selected treeview item

In the upper part the Search results

The lower part, displays the result of a command choosen from a menu item run against one or more of the selected search results.

all is done in 2 steps. first I search ie a user using a part of his or her name.

In the search result part of the screen users are listed which are found with the used search criterea

In the second step a command is issued on one ore more of the selected users. lets say a password reset.

In addition I like to use some kind of security in the app for 3 user types (user , Power User and Admin)

The Idea from a database came up because I dont want to recode the program when I think of a new AD property to use or some new command.

I hope this makes the app more clear

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
Sign in to follow this  
Followers 0