> To do this, you'd have to create a virtual table that actually gets
> instantiated per CSV file:
> CREATE VIRTUAL TABLE temp.file1 USING
> SELECT * FROM file1;
> DROP TABLE file1;
> In the above, the xCreate method of the virtual
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
On 9/14/15, Sylvain Pointeau wrote:
> 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
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
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
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.
On Tue, Oct 13, 2009 at 1:19 PM, Igor Tandetnik wrote:
> 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
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?
"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:
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)
customerA productA 100 0
[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
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
Mail list logo