SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Test Data Generator for Oracle issue

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Test Data Generator for Oracle issue
Author Message
n3xus



Joined: 06 Mar 2012
Posts: 9

Post Test Data Generator for Oracle issue Reply with quote
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 View user's profile Send private message
n3xus



Joined: 06 Mar 2012
Posts: 9

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
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 View user's profile Send private message
n3xus



Joined: 06 Mar 2012
Posts: 9

Post Reply with quote
SysOp wrote:
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
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 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.