Known Bugs And Limitations

From SQLBrowser

• SQLBrowser works on Windows. SQLBrowser could work on Unix, Linux or Mac but are not tested on these platforms
• SQLBrowser works on Sybase ASE version 12.5 or higher
• SQLBrowser may not parse certain DDL statements: don't use the DDL extracts for re-creation of database objects
• Sometimes, the shortcuts are lost. This is due to Netbeans Module loading order and will be addressed in a later version
• Cut & Paste between external applications and SQLBrowser sometimes require to Ctrl-Tab twice before being able to paste
• Control-Z (undo) gives sometimes the impression of not working because the focus is moved to the top Menu. Need to click inside the window for Control-Z to operate.
• Debugging: debugging is done through sending executables as individual batches with all variables expanded with their literal values. This has certain limitations , for instance the following construct:

   declare main_cursor cursor for select * from #t1
   declare sub_cursor cursor for select * from #t2 where c2 = @c1 -- !WATCH THIS: deferred evaluation!
   open main_cursor
   fetch main_cursor into @c1 -- !WATCH THIS: @c1 is only known here!
   open sub_cursor

is not likely to work!. Another weird statement like:

   declare @i int
   declare c cursor for select @i = id from sysobjects

will not work because declare cursor must be the only statement in a batch.