1
Automation Interface, Add-Ins and Tools / Re: SQL query for getting component description
« on: October 04, 2024, 06:00:42 pm »
I think you may find this behaviour useful in the future.
In the 'normal' list (i.e. right click on a diagram background | Switch View | Switch to List View), the notes tend to be long text, so displaying the notes like this (and we can select part or all of the notes) makes it easy to read the notes.
In the SQL Scratch Pad, we can select any column in the table to display separately by specifying 'AS NOTE'. For example, the StyleEx column of the t_diagram table usually contains long text, so 'SELECT Diagram_ID, StyleEx AS NOTE from t_diagram' makes it easier to read and check the column.
In the 'normal' list (i.e. right click on a diagram background | Switch View | Switch to List View), the notes tend to be long text, so displaying the notes like this (and we can select part or all of the notes) makes it easy to read the notes.
In the SQL Scratch Pad, we can select any column in the table to display separately by specifying 'AS NOTE'. For example, the StyleEx column of the t_diagram table usually contains long text, so 'SELECT Diagram_ID, StyleEx AS NOTE from t_diagram' makes it easier to read and check the column.