1. 

   Ken, Member

   If you have any code selected (highlighted) in the procedure you are working on, and you press Execute to same the procedure, you will get an error saying you have a error in your SQL code.

   Deselect the code and the procedure will be saved without error.

   To recreate the error, simply open any known good stored procedure. Select the first work in the procedure and press the "Execute" button. The error will be presented. Click anywhere to deselect the word, and press "Execute" again and the procedure will be saved.
2. 

   myDBR Team, Key Master

   This is actually a feature of the editor. You can use the editor not only executing all of the code, you can select part of the code and execute just that selection. You can use this for all database operations (select, insert, update, delete and DDL statements).

   Similarily you can select a procedure/function name and clicking the "Show selected object" get the procedure opened to another tab or select a myDBR command and document will be opened for that command.

   --
   myDBR Team
3. 

   Ken, Member

   OK, I see that the definition of the "execute" button is that is "executes selected code, and if none is selected, executes the full stored procedure".

   So technically this is a "feature" and therefore not a bug.

   It pays to read the manual fist... :)
4. 

   myDBR Team, Key Master

   Well, we consider it a *feature*, not a "bug" ;)

   --
   myDBR Team

Reply

You must log in to post.