/*-----------------------------数据库中数据的更新------------------------------*/
1.利用SQL语句update
int main()
{
ConnectHandle=DBConnect ("DSN=CVILocal;UID=sa;PWD=123");
ActivateHandle = DBActivateSQL (ConnectHandle, "update 测试表 set 测试变量值=3.0 where 测试变量ID=1203");
resCode = DBDeactivateSQL (ActivateHandle);
DBDisconnect (ConnectHandle);
return 0;
}
2.DBPutColFloat等函数直接更新
int main()
{
ConnectHandle=DBConnect ("DSN=CVILocal;UID=sa;PWD=123");
ActivateHandle = DBActivateSQL (ConnectHandle, "select * from 测试表 where 测试变量ID=1203");
resCode = DBPutColFloat (ActivateHandle, 3, 23.2);
resCode = DBPutRecord (ActivateHandle);
resCode = DBDeactivateSQL (ActivateHandle);
DBDisconnect (ConnectHandle);
return 0;
}
3.用非SQL变量的形式更新数据库中的值
int main()