J
jmls
Guest
by default, the data dictionary sets the sql width to be 2x format width I think that the dbtool sets the sql width to be the size of the largest field size (see http://knowledgebase.progress.com/articles/Article/P162121). The max-width is the largest data field size. One of the options when running dbtool is the "padding" (Padding % above current max: 100 for example ) This allows you to specify how much "padding" (in % terms) to add on, so 100% is 2xmax field size. http://stackoverflow.com/questions/11998342/fixing-sql-length-error-in-progress-4gl-10-2b Julian On 10 March 2014 12:57, Stefan Marquardt wrote: RE: Export from progress to SQL server Database - Error messages Reply by Stefan Marquardt IIRC, dbtool sets sql_width to twice the width of the widest instance if the field in question I just run a test with 10.2A: Twice a value would be every time a even value but it's odd. Current max fieldLen for T02Accident (27): Fld# SQLWidth Max Width ERROR NAME ---- -------- --------- ----- ---- 4: 200 245 *** AccidentName After running dbtool it's: Current max fieldLen for T02Accident (27): Fld# SQLWidth Max Width ERROR NAME ---- -------- --------- ----- -
Continue reading...
Continue reading...