[JIRA] Commented: (OFBIZ-188) Alter Table syntax for MS-SQL server incorrect.

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[JIRA] Commented: (OFBIZ-188) Alter Table syntax for MS-SQL server incorrect.

JIRA jira@ofbiz.org
     [ 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