Increase datavase field size

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
robgrigg
Lieutenant (LT)
Lieutenant (LT)
Posts: 76
Joined: Fri Jun 12, 2009 2:22 am

Increase datavase field size

Post by robgrigg » Wed Jan 06, 2010 2:36 am

Hi,

I need to increase the field size in the system for the postal codes include and exclude fields.

I need to be able to increase the DB field size and all input fields.

I also need to know that the code which processes these will not be affected.

Please help, I need to do this urgently.

Thanks.

Rob.

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Increase datavase field size

Post by mazhar » Wed Jan 06, 2010 9:19 am

For this you can change it in ac_ShipZones table, I mean the PostalCodeFilter and ExcludePostalCodeFilter columns. I think it wont break any code.

rjcuser
Ensign (ENS)
Ensign (ENS)
Posts: 8
Joined: Fri Aug 13, 2010 3:27 pm

Re: Increase datavase field size

Post by rjcuser » Wed Jan 19, 2011 5:46 pm

I'm trying to change te length of the fields, but it's not letting me save the table in SQL Server Management Studio... any idea why not? or what I have to do to achieve this? Thanks...

Post Reply