Valentina Script Problem
Brian Maher
plsntbreez at mac.com
Wed Feb 4 19:16:29 EST 2004
Hi Folks,
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
More information about the use-livecode
mailing list