× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
anilkalshetti reported 2014-09-10T07:02:42Z  · last modified 2014-09-12T06:35:58Z

Sybase ASE- Cannot alter 'in row' property using ADS Visual Editor


Priority Low
Complexity Unknown
Component App - Visual Editing
Version 15.0

Aqua Data Studio 15.0.0-rc-32
Build #: 40124
Built on: 2014-Sep-09 05:58:02 PM          

OS: Ubuntu 14.04
Linux (3.13.0-24-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.7.0_60-b19
Memory: Max=3,817,865,216;  Total=1,762,656,256;  Free=1,000,696,840;  CPUs=8

Database: Sybase ASE 15.7

Issue: Sybase ASE-  Cannot alter 'in row' property using ADS Visual Editor

Issue is observed while testing Issue 12347


Steps to reproduce the issue:
1. Connect ADS to Sybase ASE 15.7  database.
2. Open Query Analyzer, and create a table using below script

//Create Table script

create table new_titles (
 title          varchar (80)    not null
    , type           char (12)       null
    , price          money           null
    , pubdate        datetime        not null
    , description    text            in row (300)
    , notes          text            in row
    , reviews        text            off row)
 

3. Right click on this Table, and select Alter Table option.
4. In General tab, select 'description' column,
Look this column property in Column block.

5. Change 'In Row' value  to 400
6. Click on Preview SQL tab, you will observe that, no script is generated.

 

@Dev:

Alter Table window-  Preview SQL Tab, script is not generated, when 'in row' property is modified.

Expected Script:
// Script to modify in row property-

ALTER TABLE dbo.new_titles
MODIFY description  text in row (400)

 

 

2 attachments

Issue #12484

Closed
Fixed
Resolved 2014-09-11T15:18:30Z
 
 
Completion
No due date
Fixed Build v15.0.0-rc-36
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017