Re: [sqlite] Suggested user-defined-function example

2009-11-19 Thread P Kishor
On Thu, Nov 19, 2009 at 12:32 PM, Tim Romano wrote: > Thank you, Jay and Pavel. > > So, there is much work going on "behind the scenes" in these two lines > because of the tightly-knit connection between TCL and SQlite: > > proc sql_addnum { a b } { return [expr { $a + $b }] } > db function addnum

Re: [sqlite] Suggested user-defined-function example

2009-11-19 Thread Tim Romano
Thank you, Jay and Pavel. So, there is much work going on "behind the scenes" in these two lines because of the tightly-knit connection between TCL and SQlite: proc sql_addnum { a b } { return [expr { $a + $b }] } db function addnum sql_addnum Regards Tim Romano ___

Re: [sqlite] Suggested user-defined-function example

2009-11-19 Thread Jay A. Kreibich
On Thu, Nov 19, 2009 at 10:58:55AM -0500, Tim Romano scratched on the wall: > Perhaps the list can help me to get beyond some fundamental igorance here. > > What is the name for what Walter is doing in the two lines below, He is defining a custom SQL function. > and can what Walter is doing

Re: [sqlite] Suggested user-defined-function example

2009-11-19 Thread Pavel Ivanov
> can what Walter is doing be done in other languages, namely Adobe Flex > AIR/ActionScript? I don't know Flex's API but I bet you have documentation for that and can find there whether it has registration of user-defined functions or not. > Is "return [expr { $a + $b }]" also written in TCL?

Re: [sqlite] Suggested user-defined-function example

2009-11-19 Thread Tim Romano
Perhaps the list can help me to get beyond some fundamental igorance here. What is the name for what Walter is doing in the two lines below, and can what Walter is doing be done in other languages, namely Adobe Flex AIR/ActionScript? proc sql_addnum { a b } { return [expr { $a + $b }] } db fu

Re: [sqlite] Suggested user-defined-function example

2009-11-18 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Walter Dnes wrote: > It didn't help me because it used only one parameter. It didn't say > anything about you > - *MUST NOT* have commas between parameters in the function definition That is standard TCL rules and has nothing to do with SQLite. >

[sqlite] Suggested user-defined-function example

2009-11-18 Thread Walter Dnes
Whilst trying to get a TCL script to create a function in SQLite I ran into problems and did a lot of Googling. I got very tired of seeing the same old same old... proc sql_sqrt {x} {return [expr {sqrt($x)}]} db function sqrt sql_sqrt It didn't help me because it used only one parameter. It