 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
irlana
Joined: 10 Sep 2008 Posts: 1 Country: Ukraine |
|
Auto substitution SQL in INSERT |
|
In previous version when I use the 'INSERT' or 'UPDATE' statement , sql-assistent auto-show (substitute) all colums and values when wrote the query from the very beginning only, if I already wrote 'INSERT INTO' and name of table. like this:
NSERT INTO Item
(
Id,
Title,
Description
)
VALUES
(
/*Id*/,
/*Title*/,
/*Description*/
)
In version 3.5 this ontion is absent. Now when I type INSERT INTO, it's get a popup and locate the required table. It's very uncomfortable when writing batch. Can I adapt v.3.5 of SQL Ass for this way of insert in my SQL Ass option?
|
|
Wed Sep 10, 2008 4:19 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
There are new settings in 3.5 that control this behavior. I guess when you ran the latest install on top of the existing installation, it preserved your old settings in the config file and added new settings with default "false" values. Please see DB Options tab in SQL Assistant's Options dialog. Make sure you modify settings for the correct SQL dialect, it is important that you highlight the dialect on the left side of the dialog before you make changes in the settings on the right side.
|
|
Wed Sep 10, 2008 9:19 am |
|
 |
|
|
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
|
|
|