From bfa452a375ea0a0a3f95304a69186936567e5263 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?J=C3=B6rg=20Frings-F=C3=BCrst?= Date: Mon, 14 Aug 2023 19:45:36 +0200 Subject: New upstream version 4.1.4 --- src/sql/xbalttbl.cpp | 120 --------------------------------------------------- 1 file changed, 120 deletions(-) delete mode 100755 src/sql/xbalttbl.cpp (limited to 'src/sql/xbalttbl.cpp') diff --git a/src/sql/xbalttbl.cpp b/src/sql/xbalttbl.cpp deleted file mode 100755 index 8a36b46..0000000 --- a/src/sql/xbalttbl.cpp +++ /dev/null @@ -1,120 +0,0 @@ -/* xbslttbl.cpp - -XBase64 Software Library - -Copyright (c) 1997,2003,2014,2022 Gary A Kunkel - -The xb64 software library is covered under the terms of the GPL Version 3, 2007 license. - -Email Contact: - - XDB-devel@lists.sourceforge.net - XDB-users@lists.sourceforge.net - -*/ - -#include "xbase.h" - -#ifdef XB_SQL_SUPPORT - -namespace xb{ - - -/***********************************************************************/ -xbInt16 xbSql::SqlAlterTable( const xbString &sCmdLine ){ - - // expected format: - // ALTER TABLE tablename.DBF RENAME TO newtablename.DBF - - - xbInt16 iRc = 0; - xbInt16 iErrorStop = 0; - xbString sTableName = ""; - xbUInt32 ulPos = 0; - xbString sCmd = sCmdLine; - xbString sNode = ""; - - xbString sSrcTbl; - xbString sTrgTbl; - xbDbf * dbf = NULL; - - try{ - -// std::cout << "xbSql::SqlAlterTable( " << sCmdLine.Str() << " )\n"; - - // drop off the first node "DROP" - ulPos = sCmd.Pos( ' ' ); - sCmd.Ltrunc( ulPos ); - sCmd.Ltrim(); - - // drop off the second node "TABLE" - ulPos = sCmd.Pos( ' ' ); - sCmd.Ltrunc( ulPos ); - sCmd.Ltrim(); - - // pull off the source table - sSrcTbl.ExtractElement( sCmd, ' ', 1, 0 ); - sSrcTbl.Trim(); - - // pull off the action - sNode.ExtractElement( sCmd, ' ', 2, 0 ); - sNode.Trim(); - sNode.ToUpperCase(); - if( sNode != "RENAME" ){ - iErrorStop = 100; - iRc = XB_SYNTAX_ERROR; - throw iRc; - } - - // pull off "TO" - sNode.ExtractElement( sCmd, ' ', 3, 0 ); - sNode.Trim(); - sNode.ToUpperCase(); - if( sNode != "TO" ){ - iErrorStop = 110; - iRc = XB_SYNTAX_ERROR; - throw iRc; - } - - sTrgTbl.ExtractElement( sCmd, ' ', 4, 0 ); - sTrgTbl.Trim(); - -// std::cout << "source table name = " << sSrcTbl.Str() << "\n"; -// std::cout << "target table name = " << sTrgTbl.Str() << "\n"; - - // if not open, attempt to open it - dbf = xbase->GetDbfPtr( sSrcTbl ); - - if( !dbf ){ - if(( iRc = xbase->OpenHighestVersion( sSrcTbl, "", &dbf )) != XB_NO_ERROR ){ - iErrorStop = 120; - throw iRc; - } - } - if( !dbf ){ - iErrorStop = 130; - iRc = XB_DBF_FILE_NOT_OPEN; - throw iRc; - } - - if(( iRc = dbf->Rename( sTrgTbl )) != XB_NO_ERROR ){ - iErrorStop = 140; - throw iRc; - } - - } - - catch (xbInt16 iRc ){ - xbString sMsg; - sMsg.Sprintf( "xbSql::SqlAlterTable() Exception Caught. Error Stop = [%d] rc = [%d] table = [%s]", iErrorStop, iRc, sTableName.Str() ); - xbase->WriteLogMessage( sMsg.Str() ); - xbase->WriteLogMessage( GetErrorMessage( iRc )); - } - - return iRc; -} - -/***********************************************************************/ -} /* namespace */ -#endif /* XB_SQL_SUPPORT */ - -- cgit v1.2.3