My "procedural language" is C#, so that is a can-do situation. But I would like to get a lot more out of set-based SQLite if possible.
On Fri, Dec 11, 2009 at 11:55 PM, Igor Tandetnik <[email protected]>wrote: > Sqlite Fool wrote: > > In a previous life, I was able to get the stuff into a MS SQL Server > > adjancency model table using TSQL constructs like WHILE and FOR to > iterate > > over parts of strings, use temp-holder variables, and then perform > inserts. > > From what I understand about SQLite, only CASE is available and only > > set-based (non-procedural) operations are possible. > > Well, you are using SQLite from your application, likely written in some > procedural language. Why don't you write procedural parts in that language, > running SQL statements as necessary? > > Igor Tandetnik > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
