RE: [sqlite] Can I use internal variables in SQL scripts?
Christian, Thank you for your reply. I will be happy to develop stored procedure capability for SQLite in my copious spare time. :-) Don't hold your breath. RobR -Original Message- From: Christian Smith [mailto:[EMAIL PROTECTED] Sent: Friday, July 28, 2006 10:10 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Can I use internal variables in SQL scripts? No, because SQLite has no stored procedure capabilities. SQLite has only simple SQL statements. I'm sure the community would welcome such an addition, should you or anyone else fancy contributing them:)
Re: [sqlite] Can I use internal variables in SQL scripts?
Rob Richardson uttered: In SQL Server, I can write a stored procedure that looks something like this: [snip] Other features available in SQL Server stored procedures include while loops, temporary tables, and the FETCH command to retrieve data from a resultset one row at a time. I have SQLite Explorer and SQLiteSpy. Does either one have similar capabilities? No, because SQLite has no stored procedure capabilities. SQLite has only simple SQL statements. I'm sure the community would welcome such an addition, should you or anyone else fancy contributing them:) Thanks very much! Rob Richardson RAD-CON, Incv. -- /"\ \ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL X - AGAINST MS ATTACHMENTS / \
[sqlite] Can I use internal variables in SQL scripts?
In SQL Server, I can write a stored procedure that looks something like this: CREATE PROCEDURE MyProc AS DECLARE @someVariable INT SELECT @someVariable = someColumn FROM someTable WHERE someConditionThatReturnsOneRow SELECT someOtherColumn FROM someOtherTable WHERE thePrimaryKey = @someVariable END PROCEDURE Other features available in SQL Server stored procedures include while loops, temporary tables, and the FETCH command to retrieve data from a resultset one row at a time. I have SQLite Explorer and SQLiteSpy. Does either one have similar capabilities? Thanks very much! Rob Richardson RAD-CON, Incv.