The above statements insert the old student record table into a new student record table. STD_ID is char(12) and the primary key of both table
I use the "STD_ID like '000%'" to limit the number of record insert into the new student table. By change the condition, i can roughly limit the number of record insert into the new student table
When the the number of record is about 8000, the program run correctly, but when I delete condition "STD_ID like '000%'", about 100000 record will insert into the new student record table, the VB program crash.
the message just said some memory location is not allow to read.