[sqlite] Dynamically load all the sqlite functions

Hi all, I need to dynamically load all the functions inside a sqlite shared library. What I am trying to do is to execute the same code just swapping a pointer from libsqlite1 and libsqlite2 (two different version of the sqlite library). Normally I should dlopen the library, load all functions

[sqlite] SQLite Functions: "That assembly does not allow partially trusted"

Hello After migration from Windows Server 2003 to Windows Server 2012R2 the following error occurs in the C# library SQLite (version 1.0.98.0): (NuGet Package) "That assembly does not allow partially trusted" The server is shared and there is no possibility to change system settings. The

[sqlite] What is the right order of the main SQLite functions?

Thanks, all working beautifully now. RBS On Fri, Mar 20, 2015 at 1:27 AM, Simon Slavin wrote: > > On 19 Mar 2015, at 11:48pm, Bart Smissaert > wrote: > > > Is this all how it should be? > > Apart from the following, nothing I see looks like it will cause > problems. You should be checking

[sqlite] What is the right order of the main SQLite functions?

On 19 Mar 2015, at 11:48pm, Bart Smissaert wrote: > Is this all how it should be? Apart from the following, nothing I see looks like it will cause problems. You should be checking the result codes of all the calls you do to make sure you are getting SQLITE_OK (==0) returned from them and

[sqlite] What is the right order of the main SQLite functions?

Thanks, that is very useful. Maybe this should be more clearly (and simple) in the documentation somewhere. RBS On Fri, Mar 20, 2015 at 12:23 AM, Igor Tandetnik wrote: > On 3/19/2015 7:48 PM, Bart Smissaert wrote: > >> I know this is basic and should be in the documentation, but it is not >>

[sqlite] What is the right order of the main SQLite functions?

I know this is basic and should be in the documentation, but it is not quite clear to me. Basically I have 3 type of procedures: 1. Getting values from a table. For this I have the following steps: (Open) Prepare Then in a loop: Step ColumnInt, ColumnDouble, ColumnText After the loop:

[sqlite] What is the right order of the main SQLite functions?

On 3/19/2015 7:48 PM, Bart Smissaert wrote: > I know this is basic and should be in the documentation, but it is not > quite clear to me. > Basically I have 3 type of procedures: > > 1. Getting values from a table. For this I have the following steps: > > (Open) > Prepare > > Then in a loop: > >

Re: [sqlite] Functions affecting table structure ?

, 06. Dezember 2013 11:47 An: General Discussion of SQLite Database Betreff: [sqlite] Functions affecting table structure ? Hi, I am trying to add some additional data with the table structure stored in SQLite. Everything seems to be working fine but when I do an alter query it seems to drop

[sqlite] Functions affecting table structure ?

Hi, I am trying to add some additional data with the table structure stored in SQLite. Everything seems to be working fine but when I do an alter query it seems to drop the table. I have made changes in the following functions to handle the addition of the data: sqlite3AlterFinishAddColumn() ,

Re: [sqlite] Functions and index

On 2011-06-27 17:34 Simon Davies wrote: > select julianday( ( select max( day_date ) from days ) ); Of course I tried this, but with a single bracket I got a syntax error. With double bracket it works. Thanks! Adam ___

Re: [sqlite] Functions and index

On 27 June 2011 16:16, hilaner wrote: > I have hundred thousands of records in this table: > > CREATE TABLE days ( >        day_id INTEGER NOT NULL PRIMARY KEY, >        day_date DATE > ); > > CREATE INDEX day_i ON days (day_date ASC); > > And then if I run such query: > >

[sqlite] Functions and index

I have hundred thousands of records in this table: CREATE TABLE days ( day_id INTEGER NOT NULL PRIMARY KEY, day_date DATE ); CREATE INDEX day_i ON days (day_date ASC); And then if I run such query: EXPLAIN QUERY PLAN SELECT JULIANDAY(MAX(day_date)) FROM days; 0|0|0|SCAN TABLE

Re: [sqlite] Functions to convert dates with non-English month name?

On Mon, 17 Aug 2009 07:44:15 -0400, "Igor Tandetnik" wrote: >update membres set dateinscription= >substr(dateinscription, -4) || '-' || >(case substr(dateinscription, 4, length(dateinscription) - 8) > when 'January' then '01' when 'February' then '02' ... >

Re: [sqlite] Functions to convert dates with non-English month name?

Gilles Ganault wrote: > Before I go ahead and write a script to loop through all the rows, I > was wondering if SQLite supports functions to convert DD MM into > the MySQL-friendly -MM-DD, and whether those functions are > localized so that it understands month names in languages other

[sqlite] Functions to convert dates with non-English month name?

Hello, Before I go ahead and write a script to loop through all the rows, I was wondering if SQLite supports functions to convert DD MM into the MySQL-friendly -MM-DD, and whether those functions are localized so that it understands month names in languages other than English? Here's an

Re: [sqlite] Functions embedded in SQL statements

"Roger Binns" <[EMAIL PROTECTED]> wrote: > > The new SCM I (and others) are working on will allow you to > > quickly and easily download the entire source code/wiki/ticket > > repository and/or synchronize your local repository with remote > > changes. So ultimately this will not be an issue.

Re: [sqlite] Functions embedded in SQL statements

D.Richard Hipp <[EMAIL PROTECTED]> wrote: >Perhaps it would be sufficient to take snapshots of the wiki and >ship that with each release? Yes, shipping wiki snapshots with each build should be fine. Even better: A versioned wiki - so users of legacy versions can edit and improve documentation

Re: [sqlite] Functions embedded in SQL statements

The new SCM I (and others) are working on will allow you to quickly and easily download the entire source code/wiki/ticket repository and/or synchronize your local repository with remote changes. So ultimately this will not be an issue. But all that is still in the future. Is this available

Re: [sqlite] Functions embedded in SQL statements

Ralf Junker <[EMAIL PROTECTED]> wrote: > > This is especially valuable for all all who need to work with older versions > of the SQLite because their environment has not yet updated to the latest > release. It can be very unfortunate for them to find updated information > which might be

Re: [sqlite] Functions embedded in SQL statements

[EMAIL PROTECTED] wrote: Eric Bohlman <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > I'm thinking that all documentation is better placed in > > a wiki. > > Hmmm. The problem I see is that it makes access to the full > documentation contingent on connectivity to a possibility

Re: [sqlite] Functions embedded in SQL statements

[EMAIL PROTECTED] wrote: I'm thinking that all documentation is better placed in a wiki. Hmmm. The problem I see is that it makes access to the full documentation contingent on connectivity to a possibility ephemeral external site. Maybe the solution is to incorporate wiki snapshots into

Re: [sqlite] Functions embedded in SQL statements

Eric Bohlman <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions > > http://www.sqlite.org/lang_expr.html#corefunctions > > > > I will admit that the SQLite website is not particularly > > well indexed for human browsing. But you

Re: [sqlite] Functions embedded in SQL statements

Bud Beacham <[EMAIL PROTECTED]> wrote: > I cannot find any documentation > on the SQLite documentation page that explains these functions. > What other functions exist? What is the syntax? Where can they > be used in SQL statements? Is there any documentation on these > functions? >

RE: [sqlite] Functions embedded in SQL statements

-users@sqlite.org, [EMAIL PROTECTED] Subject: RE: [sqlite] Functions embedded in SQL statements Date: Sun, 18 Jun 2006 14:50:23 -0700 (PDT) Thank you, but I am not looking for C/C++ functions. I am using Tcl. I am looking for the functions that appear to extend the SQL syntax. I did not see

Re: [sqlite] Functions embedded in SQL statements

On 6/18/06, Bud Beacham <[EMAIL PROTECTED]> wrote: My apologies if I have overlooked it. I also had trouble finding them first few times, even though I knew they were there somewhere. Anyway, here's what you're looking for: http://www.sqlite.org/lang_expr.html -- Nemanja Corlija <[EMAIL

Re: [sqlite] Functions embedded in SQL statements

Bud Beacham <[EMAIL PROTECTED]> wrote: > I have the book SQLite by Chris Newman and it has examples of > functions embedded within SQL statements. > > For example on page 38 the ifnull() function is used. > > SELECT code, ifnull(due_date, 'Ongoing') FROM projects; > > Also, on page 81 the

RE: [sqlite] Functions embedded in SQL statements

Thank you, but I am not looking for C/C++ functions. I am using Tcl. I am looking for the functions that appear to extend the SQL syntax. I did not see either of the two functions I mentioned (ifnull, strftime) on those pages. bb --- Christopher Smith <[EMAIL PROTECTED]> wrote: > The C/C++

RE: [sqlite] Functions embedded in SQL statements

The C/C++ documentation can be found here: http://sqlite.org/capi3ref.html#sqlite3_create_function For those of us in the mortal category, various wrappers can make life better. For example, http://initd.org/pub/software/pysqlite/doc/usage-guide.html#creating-user-defined-functions HTH,

[sqlite] Functions embedded in SQL statements

I have the book SQLite by Chris Newman and it has examples of functions embedded within SQL statements. For example on page 38 the ifnull() function is used. SELECT code, ifnull(due_date, 'Ongoing') FROM projects; Also, on page 81 the strftime() function is used. SELECT strftime('%m/%d/%Y',

Re: [sqlite] Functions

> Was looking on the functions code. Wondered if their's any way I can > do something like > > for select from table > > do something here > > loop > > the field have a array of data may be single row but only single column Hi Vishal -- I'm not sure I understand your syntax. Maybe a more

[sqlite] Functions

Dear All , Was looking on the functions code. Wondered if their's any way I can do something like for select from table do something here loop the field have a array of data may be single row but only single column -- With Best Regards, Vishal Kashyap. http://vishalkashyap.tk

Re: [sqlite] functions that return tables

On Fri, Nov 18, 2005 at 04:25:12PM -0700, Dennis Cote wrote: > >Is there any reasonable way to accomplish this? Or am I left with > >defining a new function type that returns a handle to a temp table, > >and new parsing logic to wrap the right OP codes around that function? > > I don't know of a

Re: [sqlite] functions that return tables

Nathan Kurz wrote: Perhaps related to the recent questions about converting rows to columns, I'm finding the need for user defined aggregate functions that can return multiple values, or ideally multiple rows of values. Assume you to determine the highest N values from column. You'd want a

Re: [sqlite] functions that return tables

On Fri, Nov 18, 2005 at 05:43:01PM +0100, Noel Frankinet wrote: > >My current workaround is to have my function return a comma separated > >list of values ("10,9,8"), parse this string in my application, and > >generate a new query, but ideally I'd like to do this in one step. > > why not a vector

Re: [sqlite] functions that return tables

Nathan Kurz wrote: Perhaps related to the recent questions about converting rows to columns, I'm finding the need for user defined aggregate functions that can return multiple values, or ideally multiple rows of values. Assume you to determine the highest N values from column. You'd want a

[sqlite] functions that return tables

Perhaps related to the recent questions about converting rows to columns, I'm finding the need for user defined aggregate functions that can return multiple values, or ideally multiple rows of values. Assume you to determine the highest N values from column. You'd want a aggregate function like

Re: [sqlite] Functions

marco wrote: Hi *, Where I can find the list of the internal functions? for example: datetime() strftime() All but the date/time functions are listed in func.c in a table that's part of sqlite3RegisterBuiltinFunctions(); the date/time functions are listed in a similar table in

[sqlite] Functions

Hi *, Where I can find the list of the internal functions? for example: datetime() strftime() tks -- Marco Antonio J. Victor Fone: 11 6977-5406 Fax: 11 6973-9772 www.tactor.com.br

RE: [sqlite] Functions & Keywords

> -Original Message- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 22, 2004 5:57 PM > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] Functions & Keywords > > > Williams, Ken wrote: > > > > Hmm - al

RE: [sqlite] Functions & Keywords

> -Original Message- > From: Dennis Cote [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 22, 2004 5:23 PM > To: Williams, Ken; [EMAIL PROTECTED] > Subject: Re: [sqlite] Functions & Keywords > > > Again, see the SQLite source, in particular the file func

Re: [sqlite] Functions & Keywords

> So after I write & compile the code, how can I tell SQLite to load it? Or > do I need to compile it into the sqlite libraries? No, you install your user defined function using the sqlite_create_function() or sqlite_create_aggreate() calls at runtime. These calls require function pointer

RE: [sqlite] Functions & Keywords

> -Original Message- > From: Dennis Cote [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 22, 2004 1:58 PM > To: Williams, Ken; 'Drew, Stephen'; [EMAIL PROTECTED] > Subject: Re: [sqlite] Functions & Keywords > > > > Please excuse the silly

Re: [sqlite] Functions & Keywords

> Please excuse the silly question, but how is that done? It can't be done in SQL code. You can do it quite easily using C language API calls. These are documented in section 4 of the API documentation at http://www.hwaci.com/sw/sqlite/c_interface.html All of the built in functions in SQLite

[sqlite] Functions & Keywords

Hello,   It is straightforward to define a function in SQLite...such as MY_FUNCTION( ).   Is there an equally simple way to define a keyword, i.e. exactly like the function above but without the parentheses?   I am trying to expand SQLite, using user-defined functions, to more closely

Re: [sqlite] implement a few sqlite functions...

> Whats wrong? Problem solved: I have compiled sqlite from source and compiled the example like this: g++ sqltest.cpp -L/usr/local/lib -lsqlite ;) Greets -- Linux is like a wigwam - no gates, no windows and an apache inside.