sqlYoga: sqlite primary key and a few detailed questions
Andrew Kluthe
andrew at rjdfarm.com
Wed Apr 7 17:58:54 EDT 2010
Look into using sqlquery_ commands where sqlrecord_ fails you. I have noticed
that it is easier in some cases to use sqlquery_ over sqlrecord_.
http://www.bluemangolearning.com/revolution/docs/sql_yoga/api_docs/Documents/stack_libSQLYoga_package_SQLp20Query.htm
There is a link to the documentation.
And what about a looped function that takes a list of Id numbers and deletes
the record?
sIDList = "67,54,39,112"
reapeat for each item theID in sIDList
Delete theID
end repeat
This pulls each comma delimited item out of sIDList and deletes the record.
--
View this message in context: http://n4.nabble.com/sqlYoga-sqlite-primary-key-and-a-few-detailed-questions-tp1753188p1755712.html
Sent from the Revolution - User mailing list archive at Nabble.com.
More information about the use-livecode
mailing list