SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Q: Files in Database Explorer

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Q: Files in Database Explorer
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 1401

Post Q: Files in Database Explorer Reply with quote
I accidentally dropped a file on Database Explorer pane in SQL Editor and now I have a Files folder with that file there and some interesting context items of which I've found no trace in help.

The context items are the following when invoked on a file:

Link files - I guess the dialog opened by that one only adds new files. The dialog has a small glitch, though. When the file type dropdown is set to SQL (*.sql, *.ddl), there are no files shown in the current folder even if there are files there with those exceptions.
Remove File - pretty obvious
Open as New Document - pretty obvious as well
Load to Current Document - this one has a slight bug. SE has it ANSI encoding as default for new empty tabs and loading an UTF-8 (with BOM) file into a new tab will load the BOM bytes into the code, resulting in syntax error. By the way, is there a way to change the default encoding?
Execute SQL - now that could come in pretty handy if it worked as I'd expect, except that it doesn't: I thought it would simply execute the contents of the file regardless of the contents of the editor. Instead of that it does execute the file but overwrites the contents of the editor with the contents of the file at the same time.

Could you tell us what those are? Is this an abandoned feature or a not-yet-complete one?


Last edited by gemisigo on Tue Dec 13, 2016 6:52 am; edited 1 time in total
Mon Dec 12, 2016 2:14 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
This feature enables associating files to database objects and databases. In a simplest example, when you are working on a new schema version for an existing application and you have a bunch of incomplete stored procedures or data seed scripts that you want to associate with that existing schema and access all of that from a single place you can use the Link Files feature.

There is actually a menu available to link files, drag and drop also can be used for the linking. Right click menu can be used to show/hide linked files.
Mon Dec 12, 2016 5:32 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1401

Post Reply with quote
Sounds great, truly fascinating. Any way to link folders perhaps? It would allow to link the files added to the folder automatically.

UPDATE: Perhaps not :( When I drop a folder on anything it shows as if it was a file and says it doesn't exist when I try to open it.
Tue Dec 13, 2016 6:55 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.