Hi,
I've enhanced the TSQLQuery component editor in the IDE somewhat. For starters, it now also shows the component editor menu items as TBufDataset has (recently added). Which means you can save data to a file, for instance. That's useful for preparing offline data. Additionally, you can: - Edit the SQL statement from within the component editor. (will work faster than looking for the SQL property in the OI) - Generate the default Update/Delete/Insert SQL statements. These are the statements as the TSQLQuery component itself will generate them at runtime if you didn't specify any statements yourself. Note: Due to a bug in FPC 3.0.4, this will not always work. It always works with trunk, and once the fix is merged to 3.2, also with 3.2. - There is now also a dialog to edit all SQL statements at once, and there is also a possiblity to let the IDE generate Update/Delete/Insert SQL statements based on a table name and a selection of fields. The format of the generated statement can be customized to some degree. Enjoy! Michael. -- _______________________________________________ lazarus mailing list lazarus@lists.lazarus-ide.org https://lists.lazarus-ide.org/listinfo/lazarus
