Build GUI from SQLite database

[RWJ]

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?

[jvanegmond]

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

[Zedna]

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.

[RWJ]

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