[JIRA] Closed: (OFBIZ-188) Alter Table syntax for MS-SQL server incorrect.
Posted by
JIRA jira@ofbiz.org on
Sep 14, 2006; 8:38pm
URL: http://ofbiz.116.s1.nabble.com/JIRA-Closed-OFBIZ-188-Alter-Table-syntax-for-MS-SQL-server-incorrect-tp172279.html
[
http://jira.undersunconsulting.com/browse/OFBIZ-188?page=all ]
Marco Risaliti closed OFBIZ-188:
--------------------------------
Resolution: Won't Fix
For the moment I will close it if someone interested on it can create a new issue.
> Alter Table syntax for MS-SQL server incorrect.
> -----------------------------------------------
>
> Key: OFBIZ-188
> URL:
http://jira.undersunconsulting.com/browse/OFBIZ-188> Project: [OFBiz] Open For Business
> Type: Bug
> Components: entity
> Versions: SVN
> Environment: Database update on startup and webtools database update
> Reporter: BJ Freeman
> Assignee: Jira Administrator
>
> Original Estimate: 5 hours
> Remaining: 5 hours
>
> ofbiz send this
> ALTER TABLE dbo.CREDIT_CARD RENAME CARD_NUMBER TO TMP_CARDNUMBER
> MS SQL server sytax does not support Rename.
> ALTER TABLE dbo.CREDIT_CARD ALTER COLUMN NullCOl NVARCHAR(20) NOT NULL
> is the sytax to change column size.
> will check code anb provide patch soon.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.undersunconsulting.com/secure/Administrators.jspa-
For more information on JIRA, see:
http://www.atlassian.com/software/jira