 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
n3xus
Joined: 06 Mar 2012 Posts: 9
|
|
Test Data Generator for Oracle issue |
|
Any how test data generator is generating 3 times longer strings for my Nvarchar2 fields. Is there any known bugs or workarounds?
Or is there anyway I can customize the SqlAssistant query to read table schema?
|
|
Wed Apr 11, 2012 8:19 am |
|
 |
n3xus
Joined: 06 Mar 2012 Posts: 9
|
|
|
|
Well I got it.
I've changed Db Options->DB Queries->Columns script.
replaced "Char_Col_Decl_Length" with "Char_length" and seems working now.
|
|
Wed Apr 11, 2012 8:29 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Can you tell us if that query in its original form returned incorrect column size values for NVARCHAR and NVARCHAR2 columns displayed in Intellisense prompts? In Table Info view
|
|
Wed Apr 11, 2012 10:25 am |
|
 |
n3xus
Joined: 06 Mar 2012 Posts: 9
|
|
|
|
 |
 |
Can you tell us if that query in its original form returned incorrect column size values for NVARCHAR and NVARCHAR2 columns displayed in Intellisense prompts? In Table Info view |
Yup. It returned incorrect column size on Nvarchar2 fields. I haven't checked it on any other datatypes though.
|
|
Wed Apr 11, 2012 8:55 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Thank you. In that case your change in "Columns" query is correct, it should work for all SQL Assistant features.
|
|
Wed Apr 11, 2012 9:59 pm |
|
 |
|
|
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
|
|
|