How to execute a SQL insert from TC 9
The code segment below works(the entry IS inserted in the table). function qaCreatePrenatalHxFolder() { var sql_statement = "select * from dbo.TRK_TrackCategory where TrackCategory_Cod...
Forum Discussion
Try using a different ADO object instead of the query object - ADO Command is what I use for inserts. Assuming the file you open has an INSERT INTO statement in it, try the following.
var sql_statement = aqFile.ReadWholeTextFile("Q:\\Insert_Prenatal_HX.sql", aqFile.ctANSI);
var Qry = ADO.CreateADOCommand();
Qry.ConnectionString = "Driver={SQL Server};Server=" + dbServer + ";Database=" + dbName + "; Trusted_Connection=True;";
Qry.CommandText = sql_statement
Qry.CommandType = cmdText;
Qry.Execute();
Qry.Close();
I've never tried to use RecordCount with an ACO Command object, but since this is an insert you aren't going to get a result set anyway.
var sql_statement = aqFile.ReadWholeTextFile("Q:\\Insert_Prenatal_HX.sql", aqFile.ctANSI);
var Qry = ADO.CreateADOCommand();
Qry.ConnectionString = "Driver={SQL Server};Server=" + dbServer + ";Database=" + dbName + "; Trusted_Connection=True;";
Qry.CommandText = sql_statement
Qry.CommandType = cmdText;
Qry.Execute();
Qry.Close();
I've never tried to use RecordCount with an ACO Command object, but since this is an insert you aren't going to get a result set anyway.