1. 

   nsepetys, Member

   Hello myDBR Representative,

   How are you doing? Would it be possible to implement a go to line? Some of the procs we're dealing with are a good length and it would be helpful to have the ability to jump to the line number. A hotkey would be helpful here.

   Thanks,
   Noah
2. 

   myDBR Team, Key Master

   We can add that as a feature request.

   If your reports are so long that you need this feature, you might want to consider using subroutines.

   --
   myDBR Team
3. 

   nsepetys, Member

   We're using mysql and therefore cannot safely pass temporary tables to subroutines. I appreciate your consideration.
4. 

   myDBR Team, Key Master

   Noah,
   in MySQL, temporary table's scope is the session (database connection). So if you create a temporary table in main procedure, you can access it directly in the sub procedure (and vice versa). While this means that you should be careful when you use temporary tables (so you do not have conflict), it should not prevent you from using subroutines and you do not need to pass temporary tables between procedures.

   The goto line functionality has been added to the latest build.

   --
   myDBR Team
5. 

   nsepetys, Member

   Thank you for quickly incorporating this.

Reply

You must log in to post.