[sqlite] cannot compile sqlite3 with intel compiler (ICC) - log and hints for a possible solution

2017-07-08 Thread Roberto C.
Hi, while trying to install and sqlite package for R statistical language (Rsqlite) I came across I bug: i could not compile the package with the intel compiler ICC / ICPC. You can find the whole discussion (and the solution) here - https://github.com/rstats-db/RSQLite/issues/223 However, the

Re: [sqlite] C API - Parameterized Atomic Transactions

2016-08-10 Thread Paulo Roberto
Thank you very much, it worked! On Tue, Aug 9, 2016 at 11:49 PM, Richard Hipp <d...@sqlite.org> wrote: > On 8/9/16, Paulo Roberto <betobran...@gmail.com> wrote: > > > > I found your solution pretty elegant and I tried to implement it. > > But after

Re: [sqlite] C API - Parameterized Atomic Transactions

2016-08-09 Thread Paulo Roberto
: const sqlite3_api_routines *pApi No matter what value I pass I keep receiving the signal SIGSEV i.e. Segmentation fault. Do you have another reference to give to me? Thanks for your help. Regards. Paulo Roberto. On Tue, Aug 9, 2016 at 9:07 PM, Keith Medcalf <kmedc...@dessus.com>

[sqlite] C API - Parameterized Atomic Transactions

2016-08-09 Thread Paulo Roberto
ing to what remains uncompiled*" My question is: Preparing 4 statements, binding then and calling *sqlite3_step *for each one of then in order, would have the expected atomic operation behavior or not? If not, how could I achieve this? Thank you in advance. Regards. Paulo Roberto.

Re: [sqlite] Custom Collation comparing only firt character?

2011-08-26 Thread Roberto Colnaghi
11 13:30:57 +0200 To: colna...@msn.com From: j...@antichoc.net Subject: Re: [sqlite] Custom Collation comparing only firt character? Hi Roberto, It all depends on your data source(s). If you're sure you have all accented codepoints dealt whith in your custom collation, then it may be enough. But i

[sqlite] Custom Collation comparing only firt character?

2011-08-25 Thread Roberto Colnaghi
Hi, I'm using iOS SQLite with a custom collation. I've registered it: sqlite3_create_collation(sqlDatabase, "anyCIAI", SQLITE_UTF16, nil,

Re: [sqlite] Ticks to unixepoch date

2010-07-13 Thread Roberto Dalmonte
, but I receive a floating point error. Can you please take a look at it? Best Regards Roberto Dalmonte ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Ticks to unixepoch date

2010-07-13 Thread Roberto Dalmonte
Thanks for pointing that out Israel. I had the right value (-62135596800) but I mistakenly pasted something else. Nonetheless I get the following error: invalid floating point operation Any idea to make that statement work? Best Regards Roberto Dalmonte Il 13/07/2010 16:46, Israel Lins

[sqlite] Ticks to unixepoch date

2010-07-13 Thread Roberto Dalmonte
a normal date instead of ticks. Any idea? Roberto ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SELECT TicksToDateTime(AppointmentStart)

2010-07-13 Thread Roberto Dalmonte
to build it? Best Regards Roberto Dalmonte ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Repost: Accessing a DB while copying it causes Windows to eat virtual memory

2009-07-07 Thread Roberto
Haven't seen your previous post but just a WAG, have you selected the VM Size column in task manager to show you per process VM usage. In XP TM, it is under Tools Menu/Select Columns/Virtual Memory Size. This should indicate which process is hogging VM. 2009/7/7 Stan Bielski

Re: [sqlite] out of memory with sqlite3 shell

2009-02-11 Thread Roberto Lumbreras
is doing different things (working/not working) depending on which filesystem the database file is located. Salud, Roberto Lumbreras On Tue, Feb 10, 2009 at 9:42 PM, Roger Binns <rog...@rogerbinns.com> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Rober

[sqlite] out of memory with sqlite3 shell

2009-02-10 Thread Roberto Lumbreras
trace logs. Regards, Roberto Lumbreras 117 execve("/nfs/sqlite3", ["/nfs/sqlite3", "/flash/config.db"], [/* 8 vars */]) = 0 117 ioctl(0, SNDCTL_TMR_TIMEBASE, {B9600 opost isig icanon echo ...}) = 0 117 ioctl(1, SNDCTL_TMR_TIMEBASE, {B9600 opost isig icanon echo ..

Re: [sqlite] Sqlite 3.6.0 across dll

2008-07-25 Thread Roberto
You need to clarify what you mean by 'module'. Data is not shared in DLL's (sperate memory space and all that..), each calling application will need their own copy of data initialized by a shared library. If you have a global variable in a dll and need to share this data across multiple processes,

Re: [sqlite] Problem loading extension in Delphi (FTS2)

2007-08-13 Thread Roberto
Might be a typo, but your declaration defines the calling convention as 'stdcall' (instead of 'cdecl'), was your sqlite3.dll custom built with this calling convention? I don't think much of sqlite would work with stdcall. On 13/08/07, Andre du Plessis <[EMAIL PROTECTED]> wrote: > >

[sqlite] problems with .dump procedure

2007-06-19 Thread Roberto Davico
Hi all, I am Roberto and I find a problem using sqlite3 (version: SQLite version 3.3.8). I make a sample db to explain the situation: 1) Create the sample database using command line tool: sqlite> .schema CREATE TABLE LOG (ID INTEGER PRIMARY KEY AUTOINCREMENT, MSG TEXT ); CREATE TA

Re: [sqlite] Usage of special characters in insert query

2006-12-13 Thread Roberto
Escape you input strings: insert into foo values ('I haven''t done that'); On 13/12/06, Kirrthana M <[EMAIL PROTECTED]> wrote: Hi, In my query for inserting values into the database i have a statement as given below insert into table_name values('I haven't done that'); table is created with

Re: [sqlite] sqlite3 close() run time errors

2006-12-12 Thread Roberto
On 12/12/06, Michele Santucci <[EMAIL PROTECTED]> wrote: this's a run-time error not a linker error. It's a runtime error cos it is linked incorrectly! Specify the sqlite.def file (which IIRC lists the undecorated aliases of the sqlite functions) as an option to the command line of implib.

Re: [sqlite] sqlite3 close() run time errors

2006-12-11 Thread Roberto
You are probably linking against exports with a leading underscore. (The exports of sqlite3.dll don't have the _underscore). Does your dev environment/linker have the option to disable this underscore generation? On 11/12/06, Michele Santucci <[EMAIL PROTECTED]> wrote: Hello, I'm trying to use

Re: [sqlite] about call back of sqlite.

2006-12-08 Thread Roberto
On 08/12/06, hongsion <[EMAIL PROTECTED]> wrote: Hi sqlite, I want to using sqlite this way. Application A register callback to sqlite db. And application B will modify sqlite db. I want each time sqlite was modified by B, A is notified by callback. Is this possible in sqlite? A and

Re: [sqlite] C++ SQLite

2006-11-28 Thread Roberto
Check that the version of VB, or VB itself supports calling external functions using 'cdecl' calling convention (instead of WINAPI stdcall). On 28/11/06, RB Smissaert <[EMAIL PROTECTED]> wrote: Yes, that looks to be the way to do it. Basically will have to learn how to translate C defines to VB

[sqlite] Disabling locking?

2006-09-21 Thread Roberto Edwins
I want to use SQLite with only one user executing queries sequentially , so I don't need locking. Is there a simple way to completely disabling locking? Specific instructions if possible please, thanks...

Re: [sqlite] About Triggers

2006-08-08 Thread Roberto
On 07/08/06, chetana bhargav <[EMAIL PROTECTED]> wrote: Can you elobarate more on this. ( For me if two threads register for the same trigger condition, with different callback functions, do both the functions get called) The short answer to your question is no. (But I could be wrong) If I

Re: [sqlite] Multibyte

2006-06-27 Thread Roberto
I am confused what are you trying to acheive by building a Unicode DLL? On 27/06/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hi to all I have created my own 2 SQLite-DLL's, one as a Unicode-DLL and the other one as Multibyte-DLL. If I create a Test-App with Unicode selected and

Re: [sqlite] Where is the sqlite3.h file?

2006-06-26 Thread Roberto
The .h file is in the preprocessed source. The def file lists the exports from the dll, which is useful when some new experimental functions get defined in the .h file, but are not yet exported form the Dll. On 25/06/06, onemind <[EMAIL PROTECTED]> wrote: Hi, I am trying to use the .dll with

Re: [sqlite] Extra functions - New Project?

2006-05-24 Thread Roberto
On 24/05/06, Christian Smith <[EMAIL PROTECTED]> wrote: Attach a patch to the ticket that implements your new functions. Send your declaration of dedication of the code to the public domain to the list, and hope DRH includes the patch in the next release. IIRC, That has been suggested in the

Re: [sqlite] Extra functions - New Project?

2006-05-24 Thread Roberto
On 24/05/06, Mikey C <[EMAIL PROTECTED]> wrote: Hi, I am in need of some new SQL functions and wanted to ask advice on the best way to integrate these functions into SQLite 3. I am not a proficient C coder unfortunately. What is the best way forward? Have someone develop these and add them

Re: [sqlite] calling convention ...

2006-05-17 Thread Roberto
cdecl throughout, and remember your callback & SQL function definitions as well ;-) On 17/05/06, Marten Feldtmann <[EMAIL PROTECTED]> wrote: I wanted to use the prebuild dll of sqlite - and I was looking for the information, what calling convention was used within the sqlite.dll. It seems to

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

2006-04-25 Thread Roberto
Windows (NT, 2000, XP etc..) unicode strings are in UCS-2 (!= UTF-16) You should be calling SHGetSpecialFolderPathW (note the W at the end) with a 'wide' buffer for the "My Documents" directory, before converting this to UTF-8 and passing it to sqlite_open(). HTH. On 24/04/06, COS <[EMAIL

Re: [sqlite] future of sqlite

2006-02-08 Thread Roberto
Never seen such a list, but if you have the time & effort to look at he CVS source, it might give you a clue about what's coming up in the next release. On 08/02/06, Miguel Angel Latorre Díaz <[EMAIL PROTECTED]> wrote: > Is there any list of future enhancements, new features, etc on sqlite we can

Re: [sqlite] Prevent the error message box from popping up?

2006-01-05 Thread Roberto
You will need to be clearer on what error message you are seeing. AFAIK SQLite does not display any error messages, is this a feature of your development environment? On 02/01/06, Tsolakos Stavros <[EMAIL PROTECTED]> wrote: > Hi all. > > I am new both to this list and sqlite. Great tool. > > I

[sqlite] How to deal with Filesize-Limit of 2GB on Windows 95

2004-06-18 Thread Roberto Saccon
for old MS Windows systems ? regards Roberto P.S. if this qustion has been anwsered before, this is my first post to the list, and I really googeled a lot about the topic, but didn't found anything. - To unsubscribe, e-mail: [EMAIL