As a test I have the following script to insert 1,000,000 records into a Valentina database. The script works without error (although I had to use revdb_commit since revCommitDatabase returns an error that the command is not understood) but when I close the db in rev then open it in the Valentina application there are no records in the database. Does anyone have any idea what is going on?
Thanks, Brian
global theDB
on mouseUp
put the ticks into time1
repeat for 1000000 times
put the random of 100000 into x
revExecuteSQL theDB, "INSERT INTO RandomTable (ID, StringData) VALUES (" & x & "'String Value " & x & "')"
end repeat
revCommitDatabase theDB
put the ticks into time2
answer (time2 - time1)
end mouseUp
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution