I am using MySql on a local host and
creating a database then adding records.
After creating the table I was using the
handler below to add records. I was not
using the revCommitDatabase gConID
statement after each record and some
times my database would be missing
one or two records. After including the
revCommitDatabase gConID statement
it appears to be including them all. Is
this the proper and fastest way to add
records in a sql lite database or should
I be using something else like a query
to update instead?
on fAddFiles
set the itemDelimiter to tab
put fld id 5246 of cd id 5187 into tList
repeat for each line tLine in tList
put "INSERT INTO tFiles(recID,field2, field3, field4) VALUES(null," &
tLine & ")" into sqTable
revExecuteSQL gConID,sqTable
revCommitDatabase gConID
end repeat
fRefresh
gConIDClose
end fAddFiles
Any information or ideas are helpful.
John Balgenorth
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
