![]() Special optimize-options with help information are also available from code completion The code complition shows Table,Views, Functions, Procedures but also details about columns ![]() The window handle hyperlinks in your remarks text also. If you have information in the remarks property saved, you see that here. On the code completion help window SQL DATA LENS shows details that comes from the data model. A drop down list might appear after you type a delimiter like point or comma or just press CTRL Space code completion table\view list The SQL DATA LENS query editor will help to find the necessary information while writing the SQL script without leaving the query editor for such purposes. The results of a executed statement is displayed in the results pane including database specific messages and error codes. The query editor allows executing all SQL statements accepted by the database and the driver. place the cursor at any position and execute the current statement with F5.Execute single SQL statement at cursor position.Execute Script with multiple SQL statements.You can jump back and forth and execute the current statement simply by pressing F5 With that feature it is very easy to work with a large number of statements within one editor window. The current batch of statements is composed of all statements entered since the last GO, or since the start of the ad hoc session or script if this is the first GO. SQL DATA LENS interpret GO as a signal that they should send the current batch of SQL statements to InterSystems Caché \ IRIS. SQL DATA LENS provides commands that are not send to the database, but are recognized by SQL DATA LENS query editor. Work with multiple sql statements – use GO! Write and run queries in the advanced SQL editor speeds up your coding and reduce errors with features such as auto-completion, syntax highlighting, Bracket Matching, Goto Line commands and many more. SQL DATA LENS can work with multiple open editors at the same time, execute scripts and process the results. The query editor is used to edit simple queries but also to write complex SQL scripts. The query editor is a tool in SQL DATA LENS to run SQL queries against your database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |