sparrow wrote:Added:
- Working with IS NULL , IS NOT NULL in the filter
- Function to detach a database to connect to a new one
- When using a filter, the generated request is displayed in MEMO for the opportunity to supplement the request
- The clear button clears the filter and returns the default query
- Fixed some bugs
Sparrow, congratulations and thank you for the improvements you have implemented! I will include the formatting below for the "Field Total" field and am making changes so that the "Field Filter" and "Field Total" comboboxes are changed when the SQL statement displays results other than the default in the tablegrid, by user intervention - e.g. :
"SELECT ID_FORNECEDORES, SUM(SAIDA) AS SAIDA FROM DB2.LANCAMENTO GROUP BY ID_FORNECEDORES".
After that, I upload the new version. I tried to use the "SQLQuery" function, to avoid the standard MVD error message, in case of an error when manually constructing the SQL statement, but I couldn't...
frm_runsql.TableGrid1.Columns[num_col_total].Footer.Caption :=
FormatFloat( '###,###,##0.00', frm_runsql.TableGrid1.Columns[num_col_total].Footer.FormulaValue);
Roberto Alencar