DSQL - Dynamic SQL

Moderator: Rathinagiri

User avatar
Amarante
Posts: 182
Joined: Fri Apr 27, 2012 9:44 pm
DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL
Location: Araruama-RJ, Brazil

DSQL - Dynamic SQL

Post by Amarante »

[English (via google)]
Finally today I had the day off and could produce a small application to demonstrate the use of my DSQL routines.
The application is called MySongs. It's just a record of songs.
Before criticizing the application (made in 3 hours), know that it is not the main goal. What I want here is to demonstrate the DSQL.
The idea of DSQL is to facilitate the production of small or large applications that use SQL database (SQLite, MySQL and Postgres).
I think the task of designing very tiring forms, and create reports.
DSQL with the main idea is that you waste your time over the structure of the database, since it automatically build the Grids, Forms and reports.
It is already quite functional but of course needs many improvements.
How is late, here are almost 3 am, soon I will post detailed information.
Hope you like it, because I need help to finish it.
New File: http://hmgforum.com/viewtopic.php?f=37&t=4293#p40736

[Portuguese]
Finalmente hoje tive o dia livre e consegui produzir um pequeno aplicativo para demonstrar o uso de minhas rotinas DSQL.
O aplicativo chama-se MySongs. É apenas um cadastro de músicas.
Antes que critiquem o aplicativo (fiz em 3 horas), saibam que ele não é o objetivo principal. O que eu quero aqui é demonstrar a DSQL.
A idéia da dsql é facilitar a produção de pequenos ou grandes aplicativos que usem base de dados SQL (SQLite, MySql e Postgre).
Eu acho a tarefa de desenhar formulários muito cansativa, bem como criar relatórios.
Com DSQL a ideia principal é que você se perca seu tempo mais a estrutura da base de dados, já que ela construirá automáticamente os Grids, Forms e relatórios.
Ela já está bastante funcional mas é claro precisa de muitas melhorias.
Como está tarde, aqui são quase 3 da manhã, em breve eu postarei informações detalhadas.
Espero que gostem, pois preciso de ajuda para termina-la.
Novo Arquivo: http://hmgforum.com/viewtopic.php?f=37&t=4293#p40736
Last edited by Amarante on Sun Apr 05, 2015 5:03 pm, edited 1 time in total.
User avatar
serge_girard
Posts: 3158
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: DSQL - Dynamic SQL

Post by serge_girard »

Great !

I cannot wait for play option!

Serge
There's nothing you can do that can't be done...
User avatar
serge_girard
Posts: 3158
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: DSQL - Dynamic SQL

Post by serge_girard »

Amarante,

What kind of help you need?

S
There's nothing you can do that can't be done...
User avatar
Amarante
Posts: 182
Joined: Fri Apr 27, 2012 9:44 pm
DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL
Location: Araruama-RJ, Brazil

Re: DSQL - Dynamic SQL

Post by Amarante »

Serge,
Soon I'll be posting the DSQL supplies and also some documentation. I have to finish the translation into English.
I need help to improve what already works and insert new things.
There are small bugs that need to be fixed and also change the way of functioning of some routines.
In short ... Basically in DSQL you define the structure of the data of the (SQLite, MySQL or Postgre) and the rest is done automatically.
In the example I posted I set the database, set the images and written some code related data validation after entering, but did not draw any Grid, Form or Report, they are built at runtime.
It is very interesting, I think.
The two years I posted here .... DSQLite was a sketch .... there was no interest from people. The DSQL is more powerful ... but still needs improvement.
My main objective is to facilitate the preparation of applications. (via google)
User avatar
serge_girard
Posts: 3158
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: DSQL - Dynamic SQL

Post by serge_girard »

Amarante,

This I understand. I made DSQL for the first time in 1992 working in a large world wide system (mainframe).
It was a dynamic report writer. I still have the PL/1 source on my PC...

Serge
There's nothing you can do that can't be done...
User avatar
Amarante
Posts: 182
Joined: Fri Apr 27, 2012 9:44 pm
DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL
Location: Araruama-RJ, Brazil

Re: DSQL - Dynamic SQL

Post by Amarante »

In my work I am asked to very quickly develop some solutions (permanent or not) and I can not always spend time in the making of Forms, but stick to the main problem.
Who never needed to build an application quickly and coming up in forms design work?
The idea is not to take creativity and stifle the programmer to have a standard data entry screen but allow him writing less can produce more.
So I need help from anyone interested in improving this idea which will be beneficial to all.
Each of us is more expert in one area. Some are experts in SQL, some on design, other reports. No matter what area you command it, each using their talent in a specific module quickly DSQL will only improve.
HMG is very powerful then the limit is our imagination.


Problems and settings;
DSQL
_ implement Postgre
- Currently the number of options to be used with items on a log (combobox, checkbox ...) is in Array, the best would be in a table.
- Allow Foreign Key and Triggers
- Create Automatic Menu
- To enable the construction of Menus, Grids, Forms and Reports From the templates.
- Make a friendlier programming

DSQL_Grid
- Maintain the position of the column when doing a refresh rather than go to the first column.
- Highlight the filter frame when filter
- Sort Ascending and Descending
- Select the order header
- Images in the header according to the order (up arrow = ascending, down arrow = descending)
- Convert to OOP and make a more friendly programming

DSQL_Print
- Orderby SOLVE the problem when the field was not selected for printing
- Wait Window during assembly and printing, and msgbox when finished
- CHANGE the detail impression: Instead of printing the line, print column by column to prevent dislodgement
- Allow to set the column size and make text wrap
- Aggregation and breaks
- Convert to OOP and make a more friendly programming

DSQL_Form
- Convert to OOP and make a more friendly programming

Thanks
The DSQL is a set of ideas and experiences of several people who got since I started programming and so it is difficult to name all the people who deserve my thanks, but are represented here by Roberto Lopez, Dr Claudio, Rathinagiri, Pablo César and Esgici.

Thank you for the patience
I hope be useful to someone


Here are the sources of DSQL and MySongs test application and also a new MySongs executable with some corrections.
In the DOC directory you will find a small manual of the DSQL syntax and a summary of the contents of the files in this package.
Attachments
MySongs_Source.rar
(1.06 MiB) Downloaded 550 times
MySongs_Exec.rar
(3.03 MiB) Downloaded 513 times
User avatar
Amarante
Posts: 182
Joined: Fri Apr 27, 2012 9:44 pm
DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL
Location: Araruama-RJ, Brazil

Re: DSQL - Dynamic SQL

Post by Amarante »

A question:
I'm recording images in Blob fields as string, that is, I am converting to Hex. I did not understand how to write binary files in BLOB fields (SQLite or MySQL) in HMG.
If someone can analyze the sources or give me a hint I thank you.
User avatar
bpd2000
Posts: 1207
Joined: Sat Sep 10, 2011 4:07 am
Location: India

Re: DSQL - Dynamic SQL

Post by bpd2000 »

Great
Thank you dear
BPD
Convert Dream into Reality through HMG
User avatar
andyglezl
Posts: 1461
Joined: Fri Oct 26, 2012 7:58 pm
Location: Guadalajara Jalisco, MX
Contact:

Re: DSQL - Dynamic SQL

Post by andyglezl »

Gracias Amarante
Me parece muy bueno tu trabajo, yo no estoy familiarizado con SQL pero quiero aprender.
----------------------------------------------------------------------------------------------------------
Thanks Amarante
I feel very good your work, I'm not familiar with SQL but I want to learn.
Andrés González López
Desde Guadalajara, Jalisco. México.
User avatar
Amarante
Posts: 182
Joined: Fri Apr 27, 2012 9:44 pm
DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL
Location: Araruama-RJ, Brazil

Re: DSQL - Dynamic SQL

Post by Amarante »

Grid
Maintain the position of the column when doing a refresh rather than go to the first column.
Someone knows how to solve this?
Post Reply