StrataFrame Forum » StrataFrame Database Deployment Toolkit » Issues » Problem with Version 1.6.1

Problem with Version 1.6.1

Ben Hayat — Tue, 15 May 2007 18:17:12 GMT

To SF Team:

I started to change my VarChar to NVarChar and noticed a problem. First SF, changes the field to 50, which needs to be reentered again (Can we just enter our own column size without default). But the worst part comes after. When you move to the next field, the [b][u]50[/u][/b] keeps overwriting the next field size. This is trouble for anyone doesn't notice it.

Could we please get a fix to this soon? Thanks!

RE: Problem with Version 1.6.1

Ben Hayat — Tue, 15 May 2007 18:17:12 GMT

[quote]We already have an enhancement request that will not change the field size when changing within a legal or like type. For example, changing from VarChar to NVarChar would leave the size alone[/quote]

Yes, this is somewhat annoying the way it changes existing fields once you use NVarChar, it automatically changes the [b][u]NEXT[/u][/b] field to 50 as soon as you land on it. Please have it fixed for the final version of 1.6.1. Thanks!

RE: Problem with Version 1.6.1

Trent L. Taylor — Tue, 15 May 2007 13:13:23 GMT

Yes, this is not a bug, but rather by design. We already have an enhancement request that will not change the field size when changing within a legal or like type. For example, changing from VarChar to NVarChar would leave the size alone. So this is already on the books for a change.

RE: Problem with Version 1.6.1

Ben Hayat — Tue, 15 May 2007 10:34:52 GMT

[quote]I am not exactly sure what you mean, but I just brought up a table that had 10 VarChars and changed them all to NVarChar without any issue. You may need to elaborate as to what you are referring to. Thanks.[/quote]

Sure! Go to a field that is VarChar and then on the drop down box type "N" twice to bring up the NVarChar option.
Then type, say "40".
Now on the left side, on the list of fields, click on the next field (be sure the next field is also a Char),
Now here is the problem: type N twice again (to bring up NVarChar), and now the 50 is automatically overwrites the existing field size.

Let me know if you can duplicate it!

RE: Problem with Version 1.6.1

Trent L. Taylor — Tue, 15 May 2007 10:15:31 GMT

[quote]First SF, changes the field to 50, which needs to be reentered again (Can we just enter our own column size without default).[/quote]

This is already on the enhancement list....in fact, I think you have already made this request before.

[quote]50 keeps overwriting the next field size. This is trouble for anyone doesn't notice it.
[/quote]

I am not exactly sure what you mean, but I just brought up a table that had 10 VarChars and changed them all to NVarChar without any issue. You may need to elaborate as to what you are referring to. Thanks.