From: Jorg J. <jj...@us...> - 2002-02-28 06:46:27
|
Update of /cvsroot/compiere/db/maintain/Maintenance In directory usw-pr-cvs1:/tmp/cvs-serv825/maintain/Maintenance Added Files: 9_UpdateDBVersion.sql Log Message: . --- NEW FILE: 9_UpdateDBVersion.sql --- /************************************************************************* * The contents of this file are subject to the Compiere License. You may * obtain a copy of the License at http://www.compiere.org/license.html * Software is on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either * express or implied. See the License for details. Code: Compiere ERP+CRM * Copyright (C) 1999-2001 Jorg Janke, ComPiere, Inc. All Rights Reserved. ************************************************************************* * $Id: 9_UpdateDBVersion.sql,v 1.1 2002/02/28 06:46:24 jjanke Exp $ *** * Title: Update Database Version * Description: ************************************************************************/ UPDATE AD_Message -------------==========----- SET MsgText='2002-02-26', -------------==========----- Updated=SysDate WHERE AD_Message='!Version!'; -- Sync Translations UPDATE AD_Message_Trl trl SET MsgText=(SELECT MsgText FROM AD_Message m WHERE trl.AD_Message=m.AD_Message) WHERE AD_Message='!Version!'; |