Request SQL Generated Statement From VistaDB Data Builder
R
Robert Marquez
started a topic
over 7 years ago
It would be a time saver feature if I could right click on the columns node under the tables node of VistaDB Data Builder and have an option to generate an SQL statement for all columns in that table. If I right click the Columns node now all I see is "Add New Column" and "Refresh". I am suggesting to add another option in that list offering "Generate SQL Statement". If selecting this then a user could get a simple sql statement which includes all columns in the table. With this then I could copy and paste it into my code and adjust it as needed. Or, I may be able to use the content to help me create a new class representing the column names.
Robert Marquez
It would be a time saver feature if I could right click on the columns node under the tables node of VistaDB Data Builder and have an option to generate an SQL statement for all columns in that table. If I right click the Columns node now all I see is "Add New Column" and "Refresh". I am suggesting to add another option in that list offering "Generate SQL Statement". If selecting this then a user could get a simple sql statement which includes all columns in the table. With this then I could copy and paste it into my code and adjust it as needed. Or, I may be able to use the content to help me create a new class representing the column names.