vc如何使用嵌入式sql(exec sql命令)?可不可以直接在cpp文件中使用exec sql 命令? 还是必须放在proc文件中?vc怎么配置?谁有简单的例子? 我在cpp文件中(不是.pc文件)加入:
EXEC SQL BEGIN DECLARE SECTION;
VARCHAR username[20]; //声明宿主变量
VARCHAR password[20];
VARCHAR dbname[20];
EXEC SQL END DECLARE SECTION;出错.
EXEC SQL BEGIN DECLARE SECTION;
VARCHAR username[20]; //声明宿主变量
VARCHAR password[20];
VARCHAR dbname[20];
EXEC SQL END DECLARE SECTION;出错.
pDatabase->ExecuteSQL("delete from TableName where ...."); //执行SQL语句
_CommandPtr vCommand;
if(!SUCCEEDED(vCommand.CreateInstance(__uuidof(Command)))) return ;
vCommand->CommandText = "UPDATE Test1 SET A1 = 0 where A1=11";
//UPDATE mytable SET first_column='Updated!' WHERE second_column='Update Me!'
vCommand->ActiveConnection = app->pADOConnect.GetInterfacePtr();
vCommand->CommandType = adCmdText;
vCommand->Execute(&fieldCount, NULL, adCmdUnknown);