views:

24

answers:

1

With MSSQL, I can mix in case, if...then, and while constructs in my SQL code. Is anything similar available for SQLite? I have not seen anything on "mixing procedurally" with SQLite, anywhere.

Thanks.

+1  A: 

SQLite doesn't have any loop syntax - FOR or WHILE. CASE statements are supported rather than IF.

OMG Ponies
Thanks. I am trying to load a csv file into a Celko-esque "nested set" table in SQLite. I need to keep track of temporary variables and etc. Need help thinking...
ScSub