SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQL Assistant v3.5 is now available

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SQL Assistant v3.5 is now available
Author Message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post SQL Assistant v3.5 is now available Reply with quote
Here is what's new and changed in 3.5

1. Use of coding history is put to real work. We are sure most people will love it. It appears to save a lot of time for everybody coding same objects and procedures every day.

2. Eclipse plug-in. That's right SQL Assistant can be now used with Eclipse and derivate products. Yet, the main target in mind is Eclipse Data Tools Platform.

3. Multiple column selection lists in UPDATE and INSERT statement, checkboxes added to the column list and behave similar to SELECT column list.

4. Multiple column foreign keys are better supported in JOIN clauses. The entire JOIN with all columns can be now added with a single click.

5. New Code Bird's View – navigate long files and procedures as never before.

6. Coding statistics and productivity gain display. Some of our internal tests achieved as much as 1200% productivity gain from using SQL Assistant! Try it for yourself.

7. Added code-wrapping options to formatting rules

8. Support for batch delimiters for all environments. including parsing and support for MySQL's DELIMITER keyword and DB2'sSET TERMINATOR

9. Expanded support for Oracle objects – added code IntelliSense for types, type and package constants, exception handlers and declarations, package and type scope records

10. Added code block commenting/uncommenting function, targeted mostly for use with non-SQL editors such Notepad, UltraEdit and other editors not supporting such commonly used function natively.

11. Numerous other minor enhancements and usability changes.


Last edited by SysOp on Mon Nov 03, 2008 11:49 am; edited 1 time in total
Thu May 08, 2008 12:09 pm View user's profile Send private message
aamirocp1



Joined: 26 Feb 2008
Posts: 9
Country: Pakistan

Post really nice... Reply with quote
Hi

That 's really nice. SQL assistant 3.5 seems quiet complete product now. Thanks for full filling my requests in short time. I as promise is recommending my clients SQL assistant. All of them are quiet impressed and as i said want more and more...

Here is some feed backs i got from my clients....

create tablespace on permanent segaments has a bug. The statement is not as in oracle documentation.

regular expression functions full support needed

another client wants regular expression creation support ( dont take him seriously) but if you add that will be really interesting.

SET transaction USE_ROLLBACK_SEGMENT rollback_segment_name. there is no under score between user and rollback and segment.

can you add the support for import, export, sql loader (please add that one) or data pump

In my last input. I suggested that if some code is written the coder place a cursor on it and get reference sql assistant should show the reference with modification done from the point the code ends.
Mon May 26, 2008 1:45 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
Thanks for your feedback. I will forward your comments and suggestions to the development team.
Mon May 26, 2008 3:14 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
And of course, thank you for recommending SQL Assistant to other people! We always strive to make our products better with every release and to meet and exceed user requirements and expectations.
Mon May 26, 2008 3:20 pm View user's profile Send private message
aamirocp1



Joined: 26 Feb 2008
Posts: 9
Country: Pakistan

Post oracle import export sql load and data pump support Reply with quote
Hi

please add import , export datapump and sql load support in sql assistant. The support should be shown in the same way the other oracle statements are shown

if you are working on this then when can i get this.

thanks
Fri Jul 18, 2008 1:03 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
Hi,
import/export/datapump are neither SQL or PL/SQL commands. They are typically executed manually from Unix shell, DOS command prompt or from shell/batch files. I don't think there is a place for them in SQL Assistant which is focused on providing SQL coding assistance in SQL editors and other SQL related functions.
Fri Jul 18, 2008 5:08 pm View user's profile Send private message
aamirocp1



Joined: 26 Feb 2008
Posts: 9
Country: Pakistan

Post Reply with quote
when are you planing to introduce new version of the sql assistant
Sun Jul 20, 2008 7:25 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
We expect new major version 4 to be ready in October/November 2008. Some minor maintenance versions might be released before that.
Sun Jul 20, 2008 9:02 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.