Re: [sqlite] Creating procedures in sqlite

2009-04-23 Thread John Stanton
Sqlite does not have stored procedures, but does have functions.

We iplemented Javascript as a stored procedure language in Sqlite and 
are currently looking at doing the same with Python for another 
application.  You could also use Lua.  These are all Open Source projects.

Jyoti Seth wrote:
> Hi All,
>
>  
>
> SQLite lacks built-in support for stored procedures. We need to create it in
> our application. Please guide me any alternative method to achieve this
> functionality.
>
>  
>
> Thanks,
>
> Jyoti
>
>  
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>   

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Creating procedures in sqlite

2009-04-23 Thread Kris Groves
Perhaps this helps ?
http://sqlite.org/c3ref/create_function.html

Jyoti Seth wrote:
> Hi All,
>
>  
>
> SQLite lacks built-in support for stored procedures. We need to create it in
> our application. Please guide me any alternative method to achieve this
> functionality.
>
>  
>
> Thanks,
>
> Jyoti
>
>  
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>   

-- 
Kris Groves

 Project Manager / Software Engineer   mm-lab GmbH
 Phone:  +49 7154 827 323  Stammheimer Str. 10
 Fax:+49 7154 827 350 D-70806 Kornwestheim
 kris.gro...@mmlab.de www.mmlab.de

Domicile of Company: Kornwestheim, Germany
   District Court - Court of Registration Stuttgart HRB 207257
  Managing Directors: Bernd Herrmann, Lothar Krank,
 Michael Meiser, Dr. Andreas Streit

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Creating procedures in sqlite

2009-04-23 Thread Jyoti Seth
Hi All,

 

SQLite lacks built-in support for stored procedures. We need to create it in
our application. Please guide me any alternative method to achieve this
functionality.

 

Thanks,

Jyoti

 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users