sql启动后没有关闭!!!我查看数据库,数据库里面数据已经被成功修改了
我的action里面的脚本是这样的
Action()
{
int NumRows=0;
int i;
lr_db_connect("StepName=DatabaseConnection",
"ConnectionString=Data Source=SBRTP6DT5LKJZSU;Initial Catalog=heketestersist Security Info=True;User ID=saassword=123456",
"ConnectionName=heketest","ConnectionType=SQL",LAST);
lr_rendezvous("selectstart");
lr_start_transaction("SQL");
/*
//查询
NumRows = lr_db_executeSQLStatement(
"StepName=PerformQuery",
"ConnectionName=heketest",
"SQLStatement=select * from table_a",
"DatasetName=heketest",
LAST );
*/
//修改
NumRows = lr_db_executeSQLStatement(
"StepName=Performinsert",
"ConnectionName=heketest",
"SQLStatement=update table_a set a ='qiufei' where a='test'",
//"SQLStatement=update table_a set a='qiufei' where a='heke1'",
//"SQLStatement=update table_a set a='{test2}' where a='{test1}'",
"DatasetName=heketest",
LAST );
lr_end_transaction("SQL", LR_AUTO);//获得查询记录所开销的时间
lr_output_message("The query returned %d rows.", NumRows);
while(i<NumRows) {
lr_db_getvalue("StepName=GetValue",
"DatasetName=heketest",
"Column=a",
"Row=next",
"OutParam=MyOutputParam",
LAST);
lr_output_message("The value is: %s", lr_eval_string("{MyOutputParam}") );