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