If you are unable to create a new account, please email support@bspsoftware.com

 

Impact of Change in varchar length for Framework Manager Query Subjects

Started by actcognosuser, 01 Apr 2020 09:08:57 AM

Previous topic - Next topic

actcognosuser

Hi,

The character length for a column  has changed in the table. Do the query subjects in Framework Manager need to be validated ?
Will it fail ?

MFGF

Quote from: actcognosuser on 01 Apr 2020 09:08:57 AM
Hi,

The character length for a column  has changed in the table. Do the query subjects in Framework Manager need to be validated ?
Will it fail ?

Hi,

I'm assuming this won't cause you problems unless you have specific calculations that are created based on the assumption the item is a specific length. Has the size increased or decreased?

MF.
Meep!

actcognosuser

Hi MFGF,

The reports do not use this field. The char length has changed from 10 to 12.
Will the query subject throw an error while package is being published?

MFGF

Quote from: actcognosuser on 01 Apr 2020 10:02:14 AM
Hi MFGF,

The reports do not use this field. The char length has changed from 10 to 12.
Will the query subject throw an error while package is being published?

I'm pretty sure it won't be a problem. I'm not even sure you will need to re-publish the package.

Cheers!

MF.
Meep!