Sql Field Width in OE 11.5 Database

Posted by karasanr on 12-Jul-2016 01:26

Is there any way to dynamically change the sql field width for a field other than dbtool while users accessing the database.

Posted by James Palmer on 12-Jul-2016 03:27

Not in 11.5 as far as I know, but it's possible in 11.6 to set things to auto-adjust IIRC.

Posted by Dileep Dasa on 12-Jul-2016 03:46

Yes, starting from 11.6 OE SQL has new feature called ASU (Autonomous Schema Update).  When ASU is enabled, it auto adjusts SQL column widths.  

All Replies

Posted by James Palmer on 12-Jul-2016 03:27

Not in 11.5 as far as I know, but it's possible in 11.6 to set things to auto-adjust IIRC.

Posted by Dileep Dasa on 12-Jul-2016 03:46

Yes, starting from 11.6 OE SQL has new feature called ASU (Autonomous Schema Update).  When ASU is enabled, it auto adjusts SQL column widths.  

Posted by karasanr on 13-Jul-2016 03:43

Thanks James for your response

Posted by karasanr on 13-Jul-2016 03:43

Thanks Dileep for your response

This thread is closed