On Mon, 9 May 2005 22:28:34 -0400, "basil thomas" <[EMAIL PROTECTED]> wrote:
> database. SQLite is definitely extremely fast and we have no plans of
> abandoning due to lack of stored procedures but definitely would be nice to
> have...
you could fake it with a view and a instead of trigger
/* setup */
create table param_codes
(code integer primary key, description varchar (10));
insert into param_codes values (1, 'atest');
/* fake a stored procedure */
create view my_procedure as select 1 as param1,'' as param2;
create trigger my_procedure_body instead of insert on my_procedure
for each row
begin
update param_codes
set description = new.param2
where code = new.param1;
end;
/* test */
select * from param_codes;
insert into my_procedure values (1, 'atest2');
select * from param_codes;
klint.
+---------------------------------------+-----------------+
: Klint Gore : "Non rhyming :
: EMail : [EMAIL PROTECTED] : slang - the :
: Snail : A.B.R.I. : possibilities :
: Mail University of New England : are useless" :
: Armidale NSW 2351 Australia : L.J.J. :
: Fax : +61 2 6772 5376 : :
+---------------------------------------+-----------------+
