SqlDbx
You are not logged in.
Pages: 1
Ok, thanks.
I have enabled the SQL log with the options of "Log file per server" and "Monthly / daily (checked) logs" and it don't save any data for connections that have checked "Use alt. background and text color" (for connections with regular background the log file is updated after each successful command).
Is that a bug or it's by design?
I use version 3.44 Pro. Thanks.
Hello,
When SqlDbx exports data from SQL Server as Inserts, it does include calculated fields in the field list, making the inserts generated unusable because as you might imagine SQL Server won't allow updating calculated fields.
This could be solved ignoring those fields when generating inserts, which is pretty straightforward since that fields have "iscomputed" set to 1 in the syscolumns table (I did something similar for a internal app sometime ago).
Regards.
Can you please email autosave file (SqlDbx Default Session.state) located
in directory: C:Documents and Settings<user>AppDataLocalSqlDbx
to support@sqldbx.com
I just send it and an screenshot of SqlDbx after restoring the session.
Regards.
Hello,
We recently updated from version 3.31 to version 3.40 and I noticed a small bug in the new version: when restoring the autosaved session with several connections, the first connection is shown with the results panel "maximized", i.e., it takes all the screen leaving no room for the object and script panels. The rest of connections are restored fine.
In (lame) ASCII art, instead of getting:
|--------------------------------|
| | |
| objects | scripts |
| | |
|--------------------------------|
| results |
|--------------------------------|I get this for the first connection restored:
|--------------------------------|
|--------------------------------|
| |
| results |
| |
| |
|--------------------------------|I can resize the results panel to its normal height but the next time I open the program it happens the same, and it's a bit annoying.
(I connect to SQL Server databases, if it matters).
Regards.
The mode which links script to results not to result tabs exist now.
Go to Options->Results and uncheck "Enable Multiple Result Tabs" and restart.
I agree that it's not exactly the same but close.
Many thanks, that was exactly what we was asking for. Probably we tried it without restarting the program (maybe you should add a hint in the options that require program restart, like you do with other options that require query rerun).
My boss will be happy (he uses multiple script tabs all the time) :-)
First, thanks for your work in the app. Almost every new version have a cool new feature :-) .
That said, it would be nice if you could add an option for linking a script tab to a result tab, so when you change to another script tab then the associated result tab become also active (the opposite, changing the result tab activates also the associated script tab, could be useful too).
This would make easier working with the results of several scripts at the same time. With the current mode of operation, if you change to another script tab but forget to change also the results tab you can "overwrite" the results of the other script.
Since this could interfere with current behaviour of opening as many result tabs as you want, maybe this could be a global setting, so the user have to select between having linked results (my suggestion) or independent results (the current mode).
Thanks.
After thinking a little bit more about data compare I think
we probably should ignore all whitespace when comparing
data when option "ignore whitespace" is on
Many thanks, I just installed the last version and found that you change it to ignore whitespace also in varchars. I find it very useful since most of the tables we use have varchar columns.
We are talking about two different things here.
You refer how server handles CHAR and VARCHAR columns
for storage and in expressions. I was referring how SqlDbx
handles CHAR and VARCHAR columns on retrieval.
Sorry about that, I misunderstood you. Thanks for the response (and the patience).
The difference between CHAR and VARCHAR columns is that CHAR columns are right trimmed and VARCHAR columns not. This has nothing to do with compare, this is how data retrieved from the server.
Sorry, but at least in SQL Server is just the opposite, CHAR columns are always right padded up to the column length with spaces since CHAR is a fixed length type. VARCHAR columns can be right trimmed or not depending of SET ANSI_PADDING:
char and varchar: http://msdn.microsoft.com/en-us/library/ms176089.aspx
SET ANSI_PADDING: http://msdn.microsoft.com/en-us/library/ms187403.aspx
using your previous example, if you have:
select cast ('spaces ' as CHAR(20))+'.'
you get 21 characters while if you have:
select cast ('spaces ' as VARCHAR(20))+'.'
you get only 12.
Currently whitespace can be ignored only when comparing text and it's
not ignored when comparing data. The example you provided is exactly the
reason we implemented it this way. I agree that we should make it clear or maybe
add an option to ignore whitespace for data compare too.
So when making comparisons varchar columns are considered data? Or to put it in another way, ignore whitespace only affect char columns?
Thanks for the response.
My company just acquired SqlDbx (great tool) and while trying the most interesting features I think that I found a bug in the visual diff tool (version 3.28.1).
I used for testing it a basic table, with a structure like this:
CREATE TABLE TableName
(
Code char(6) NOT NULL,
Name varchar(100) NOT NULL,
CONSTRAINT PK_TableName PRIMARY KEY (Code)
)
I entered the query "select * from TableName" and connected to two test servers (one SQL Server 2000 and the other SQL Server 2005) that have the same table definition and the same data in the table, but in one server the varchar field was padded with spaces.
After running the diff, it marked the varchar column as changed (yellow) in all rows, either with Ignore Whitespace checked or not (I re-run the diff several times). So I executed a "update TableName set Name=rtrim(Name)" and after this all the differences disappeared.
If this a bug of the current version or I'm missing something?
Regards.
Pages: 1