[sqlite] user defined function returning a result set

2015-09-17 Thread Sylvain Pointeau
> > To do this, you'd have to create a virtual table that actually gets > instantiated per CSV file: > > CREATE VIRTUAL TABLE temp.file1 USING > csvFileReader('/path/to/my/file.csv'); > SELECT * FROM file1; > DROP TABLE file1; > > In the above, the xCreate method of the virtual

[sqlite] user defined function returning a result set

2015-09-14 Thread Sylvain Pointeau
Hello, I think I have read on this mailing list that sqlite now has functions able to return rows. (but cannot find it anymore) I am interested about this new functionality. Would it be possible to see a very basic sample of it? Do you think we can implement a kind of CSV reader with this new

[sqlite] user defined function returning a result set

2015-09-14 Thread Richard Hipp
On 9/14/15, Sylvain Pointeau wrote: > Hello, > > I think I have read on this mailing list that sqlite now has functions able > to return rows. (but cannot find it anymore) https://www.sqlite.org/draft/vtab.html#tabfunc2 > > I am interested about this new functionality. Would it be possible to

Re: [sqlite] User Defined Function using P/Invoke SQLite wrappers

2012-05-01 Thread Joe Mistachkin
Rick Guizawa wrote: > > I was wondering if someone could give me a simple straight forward > example of creating user defined function in c# - sqlite application. > I have collected basic ( probably incomplete) P/Invoke SQLite wrapper > functions but I don't know how to include the user defined

Re: [sqlite] User Defined Function using P/Invoke SQLite wrappers

2012-05-01 Thread Rick Guizawa
Hi All, I have an assignment to do statistical processes in C#. I like SQLite stand-alone feature but I need to be able to do the assignment using something like SQL Server stored-procedure. I was wondering if someone could give me a simple straight forward example of creating user defined

Re: [sqlite] User-defined function invocation during triggers

2009-10-13 Thread Pavel Ivanov
With the next version of SQLite (which will be released this week) you will be able to write a trigger on deletion of dependent rows where you will just call your function. Pavel On Tue, Oct 13, 2009 at 1:19 PM, Igor Tandetnik wrote: > mwnn wrote: >> i

Re: [sqlite] User-defined function invocation during triggers

2009-10-13 Thread Igor Tandetnik
mwnn wrote: > i am using triggers to delete dependent rows of a table when a > referred row is deleted. Is there a way for me to let SQLite call a > user-defined function for every row deleted in a trigger? Well, you could write your trigger like this: create trigger ... on

[sqlite] User-defined function invocation during triggers

2009-10-13 Thread mwnn
Hi all, i am using triggers to delete dependent rows of a table when a referred row is deleted. Is there a way for me to let SQLite call a user-defined function for every row deleted in a trigger? Regards, mwnn ___ sqlite-users mailing

Re: [sqlite] user defined function

2007-10-10 Thread drh
"Aviad Harell" <[EMAIL PROTECTED]> wrote: > Hey Igor, > > Thanks for your replay. I tried not to use user defined function to do it. > This code is working on SqlServer but on SQLite I get misuse of aggregate: > (SUM(SALES)). > See http://www.sqlite.org/cvstrac/tktview?tn=2652

[sqlite] user defined function

2007-10-08 Thread Aviad Harell
Hey, I tried to create user defined function called Rank. which gets partition columns and order by column. this function should create rank according to its parameters. i.e.: select customer, product, sales, Rank(customer, sales) from table should return: customerA productA 100 0 customerA

Re: [sqlite] User Defined Function vs.Keyword

2004-10-01 Thread D. Richard Hipp
[EMAIL PROTECTED] wrote: I tried to use my function with a statement like: SELECT left('Hallo Du!', 5); I got: "near "(" : syntax error" This is - I assume - because LEFT is already a keyword with a special meaning as stated in http://www.sqlite.org/lang.html#keywords and can therefore not be used

[sqlite] User Defined Function vs.Keyword

2004-10-01 Thread programmer
Hello again, thanks for your reply yesterday. I'm limited in my mailing possibilites, therefore no reply yesterday, but this new issue today. I did not yet try to write a collation function but began with simple user defined functions. My first try was an IIF function similar to MySQL's