SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in

Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Author Message
Site Admin

Joined: 26 Nov 2006
Posts: 6776

Post Reply with quote

The first thing is something we are planning on enhancing. For now, I suggest that you use the popup before typing "Table1.a". If you have noticed, SQL Assistant parses names of already entered tables and aliases and if you have multiple tables in the same query, it pastes column names as Table.Column, if table names include schema names, it pastes Schema.Table.Column, if tables are aliased, it pastes names as Alias.Column.

As for the handling of local variables, in the current version 1.0 we are trying to avoid full script parsing for performance reasons. Because SQL Assistant is not really part of the editor, it doesn't have access to internal memory buffers used by the editor, and so it basically has to work with the text displayed on the editor screen. Requesting the entire script from the editor and re-parsing it after each change. When large scripts are used, such operations become slow and not very efficient. If you ever worked with SQL Prompt tool you probably know how annoying that is when you have to sit and wait for minutes while your scripts get opened and after various copy and paste operations.

As a side note, we are going to implement some kind of full script parsing in version 2. I don't know if support for local variables will be added in that version.


Last edited by SysOp on Mon Aug 13, 2007 6:00 pm; edited 1 time in total
Wed Jan 24, 2007 10:03 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.