With this release we give you a brand new SQL editor which is integrated into the CFML editor. The SQL Editor supports code assist and code colorization for the following types of SQL statements:
- Select
- Insert
- Update
- Delete
Also, note that for SQL statements within the cfquery tag, code assist is available in the CFML editor itself. You need not open the SQL Editor for code completion hints. In order to get code assist in the main editor or the SQL editor, you must have a server configured, running and associated with your project in ColdFusion Builder. The SQL editor does not support offline databases. I shall write more about the type of SQL code assist available in subsequent posts.