/// <summary>
/// Execute a V-SQL query that does not return a result set. These include INSERT, DELETE and UPDATE.
/// </summary>
public void ExecSQL()
{
//Execute SQL command
//Set rowsAffected
int rowsaffected = 0;
if (queryID <= 0)
{
return;
}
if (opened)
{
throw new InvalidOperationException("Query opened");
}
lock (syncRoot)
{
VistaDBAPI.ivsql_SetSQL(queryID, commandText);
sqlID = VistaDBAPI.ivsql_ExecSQL(queryID, ref rowsaffected);
rowsAffected = rowsaffected;
}
}
/// <summary>
/// Execute a V-SQL query that does not return a result set. These include INSERT, DELETE and UPDATE.
/// </summary>
public override void ExecSQL()
{
//Execute SQL command
if (this.queryID == 0)
{
return;
}
if (this.opened)
{
throw new InvalidOperationException("Query already opened");
}
lock (syncRoot)
{
this.rowsAffected = 0;
VistaDBAPI.ivsql_SetSQL(this.queryID, this.commandText);
VistaDBAPI.ivsql_ExecSQL(this.queryID, ref this.rowsAffected);
this.startTraversing = true;
}
}
