So I don't know the geek speak here, but I'm trying to do the following:
SQL:
BEGIN TRANSACTION;
INSERT INTO Core_User (FirstName) VALUES (?);
INSERT INTO Core_User (FirstName) VALUES (?);
INSERT INTO Core_User (FirstName) VALUES (?);
COMMIT;
I've set the parameters:
For lngCount = 0 To cmdBatch.Parameters.Count - 1
Debug.Print(cmdBatch.Parameters.Item(CInt(lngCount)).Value)
Next
This will output:
Jason
Kevin
Mark
However, when I execute the SQL, in the database I get three records with the following values for "FirstName:"
Jason
Kevin
Kevin
Any ideas?