Query Builder tool

[HighlanderSword]

Has anyone designed a query builder tool?

I searched the forums and could not find one.

Looking to see if anyone has built something that allows user to select the database, then it populates a form with all of the fields of a desired table and'

then present the user with filter options like field name like , order by statements etc...

Wanted to check before i build my own

 

[jchd]

There are many GUI tools for as many RDBMS. Which engine do you have in mind?

[HighlanderSword]

Hello,

 

I'm looking to use Autoit for Oracle DB's

[mLipok]

  On 10/31/2021 at 9:01 PM, HighlanderSword said:

use Autoit for Oracle DB's

Expand  

How ?

Do you use ADO.au3 UDF ?

[HighlanderSword]

For access using Access_Accdb.au3, and Sqlite for Sqlite DB, so looking to see if there are any exisitng forms out there that are flexible like the GUI Products available

[jchd]

Many third-party GUI exist for SQLite. Personally I use SQLite Expert but you can select another one.

[HighlanderSword]

I was looking to keep this all in Autoit and not have any third party tools, I will begin building out my own SQL builder form in Autoit...

[jchd]

I wish you good luck. Maybe the SQLite syntax railroad diagrams starting here will help you a bit.

[Skysnake]

I am a bit lost as to what you really want

Have you looked at the AutoIt SQLite functions? https://www.autoitscript.com/autoit3/docs/libfunctions/_SQLite_Startup.htm

Then ADO.UDF allows you to create an ADO friendly ODBC link to SQLite db's 

Perhaps a bit more clarity on what the plan is?

[HighlanderSword]

looking to build a sql query builder form in autoit , where the end user can dran and drop files to the form to add files to include in the sql and dropdowns for standard sql functions like in clause , like ...etc ...

[Skysnake]

Cool

1. What level is your SQL? 

2. What is your experience with AutoIt?

Is this in line with your expectation?

 

 

 

 See this by GreenCan 

 

 

 

 

This is a very simple example of data from SQLite to a Listview

 

Skysnake

[jchd]

From what I understand from the OP's posts, he wants to create an SQL[ite] query builder allowing SQL-illiterate users to click on GUI components to assemble a valid SQL query to perform the operation(s) expected.

More or less generic SQL builder are available, payware or freeware, but this isn't a simple task. In fact, beyond very simple queries, things turn out to be very complex and if you insist on efficiency, then you need some level of IA.

Edited November 1, 2021 by jchd

[Earthshine]

Yeah good luck with that. Unless you have extreme SQL skills I doubt this is going to be a successful project

[robertocm]

Just for ideas:  i'm using these tools for learning sql:

- HeidiSQL

- my attached excel file with vba code: double click event in the body of tables execute sql in the above table (see sheet module).

Copy both tables for running new examples.

 

SQL_workbench.xlsmFetching info...

Edited November 2, 2021 by robertocm