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
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
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
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
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
>>
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:
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:
>
>
, 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
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() ,
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
___
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:
>
>
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
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' ...
>
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
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
"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.
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
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
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
[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
[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
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
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?
>
-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
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
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
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++
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,
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',
> 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
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
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
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
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
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
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
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
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
> -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
> -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
> 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
> -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
> 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
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
> 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.
45 matches
Mail list logo