COMMIT - If so many no. of records?????????

[Reshmi Jacob]

Hello..............

I have a text file with about 10000 - 15000 lines. Each line is an action SQL like Insert/Update/Delete . Using VB code I read from text file line by line and execute each line.

Dim ConLocal As New ADODB.Connection
Dim FileSys As New Scripting.FileSystemObject
Dim TxtStream As TextStream
Dim SQLString As String

'-----I wrote code to open textfile

Conn.BeginTrans
Do While Not TxtStream.AtEndOfStream
SQLString = TxtStream.ReadLine
Conn.Execute SQLString
Loop
Conn.CommitTrans

This is the basic algorithm I used, my doubt is if there are more than 10000 SQL statements in notepad, and when the control(execution sequence) is at Conn.CommitTrans(Commit is being executed!!!!) some power failure occurs in the middle, what happens

* A part of the statments are committed?(ie, 4000 out of 10000 got committed?)
* All discarded?(10000 statements roll back????)

Pls help me out of this......when I executed it out of these 10000 some lines is missing, others found!!! I can't see any errors in the VB code, kindly help me to solve this issue....

Regards
Reshmi