AccessClient.ExecuteNonQuery

AccessClient.ExecuteNonQuery($mdbfilename, $sql)
This method executes insert or update SQL with MDB file.

Parameters
Name Summary
$mdbfilename a file name.
$sql SQL to execute.


Returns
a count of affected rows.

ex)
$mdb = "c:\temp\test.mdb";
$sql = "insert into [TableName] ([ColumnName1], [ColumnName2]) values ('Value1', 'Value2')";
$acc = new accessclient;
$acc.ExecuteNonQuery($mdb, $sql);

Last edited Mar 2, 2013 at 11:38 AM by Tom__S, version 5

Comments

No comments yet.