[
http://jira.undersunconsulting.com/browse/OFBIZ-188?page=comments#action_13935 ]
Marco Risaliti commented on OFBIZ-188:
--------------------------------------
Someone knows if it is still an issue and it has been solved ?
Thanks
Marco
> 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
Locked
