Database

CDatabase database;
CString sDriver = "MICROSOFT EXCEL DRIVER (*.XLS)";  // exactly the same name as in the ODBC-Manager

CString sExcelFile =_T("C:\\Users\\Admin\\Desktop\\1.xls");// Filename and path for the file to be created

CString Query_Str="";

TRY  
{ 

	Query_Str.Format(_T("DRIVER={%s};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\"%s\";DBQ=%s"),                
	sDriver, sExcelFile, sExcelFile);     // Create the database (i.e. Excel sheet)

	if( database.OpenEx(Query_Str,CDatabase::noOdbcDialog) )
	{
		// Create table structure
		Query_Str = "CREATE TABLE demo (Name TEXT)";
		database.ExecuteSQL(Query_Str);

		// Insert data
		Query_Str = "INSERT INTO demo (Name) VALUES ('Albert')";
		database.ExecuteSQL(Query_Str); 

		//add column
		Query_Str = "ALTER TABLE demo ADD Col2 TEXT";
		database.ExecuteSQL(Query_Str);
	}
	// Close database
	database.Close();

}  
CATCH_ALL(e)
{    
	AfxMessageBox(e->ReportError());
}
END_CATCH_ALL;

can u please help me to ALTER TABLE with DEFAULT

Eddy Vluggen wrote:

First add all the columns and do the insert when all columns are present, or
make sure that the column you're going to add accepts null-values.

Le@rner wrote:

get all column name list of current database.

Did you mean get all column name list of current table.

Blue_Boy wrote:

Did you mean get all column name list of current table.

ERROR at line 7:
ORA-06550: line 7, column 7:
PLS-00103: Encountered the symbol "S" when expecting one of the following:
. ( * @ % & - + / at loop mod remainder rem ..
<an exponent (**)> || multiset
The symbol "loop" was substituted for "S" to continue.
ORA-06550: line 8, column 27:
PLS-00103: Encountered the symbol "`" when expecting one of the following:
( ) - + case mod new not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
table continue avg count current exists max min pr
ORA-06550: line 9, column 24:
PLS-00103: Encountered the symbol "`" when expecting one of the following:
( ) - + case mod new not null select <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
table continue avg count current exists max