On Fri, Aug 30, 2019 at 3:35 PM Keith Medcalf wrote:
> Seems fine, other than that event.first_seen and event.last_seen can be NULL,
> in which case that field will never be updated. So while you may claim that
> you never store NULL in those fields, doing so will cause non-workage due to
> in
First off, if this sort of "code review" style question is
inappropriate for this list, please feel free to reply to me directly
and tell me to stop, and I'll know to not do this again.
That said, I have a question on the use of SQLite. At the risk of
falling into the XY problem, I'll give some d
On Tue, Mar 5, 2019 at 2:30 PM Kyle wrote:
> I have downloaded both sqlite3 and mod_spatialite.dll (the extension) and
> copied them to C:\Windows\System32.
>
> When I run
> SELECT load_extension('mod_spatialite')
> sqlite returns "Error: the specified module could not be found"
Helpfully, on
On Wed, Oct 10, 2018 at 3:45 PM Warren Young wrote:
> Fossil currently has no restrictions on password length[1] or content. The
> input text is simply salted, hashed, and inserted into the user table:
> [...]
> The salt is the project code combined with the user ID, not a secret per-user
> sal
On Thu, Apr 6, 2017 at 2:07 PM, David Raymond wrote:
> Before opening the connection you could do something along the lines of
>
> if not os.path.isfile(fi) or not os.access(fi, os.W_OK):
> print "File isn't there or isn't writable"
> return 1
> with open(fi, "r") as f:
> if f.read(16)
On Tue, Feb 14, 2017 at 1:23 PM, Bart Smissaert
wrote:
> C:\Program Files (x86)\Microsoft Visual Studio
> 12.0\VC\vcprojects\Win32\SQLite\s
> qlite-autoconf-317>nmake /f Makefile.msc
What?!
You're building from the installation directory?
There's no way to do this on a normal installation t
On Feb 4, 2017, at 12:47 PM, Drago, William @ CSG - NARDA-MITEQ
wrote:
>> -Original Message-
>> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
>> Behalf Of Clyde Eisenbeis
>> Sent: Saturday, February 04, 2017 2:58 PM
>> To: SQLite mailing list
>> Subject: [s
On Wed, Jan 11, 2017 at 10:28 AM, Rael Bauer wrote:
> 1) Should the howtocompile.html webpage not include this in the "Building A
> Windows DLL" instructions?
Tough question. Normally, I'd say this is toolset knowledge, and
really doesn't belong in those sort of directions. But since you're
not
On Wed, Jan 11, 2017 at 2:11 AM, Rael Bauer wrote:
> I am trying to compile the latest amalgamation (3160200) as a dll on Windows
> 10 x64, using VS2015 x86 Native Tools Command Prompt. The dll compiles fine,
> however trying to use this dll in various tools (Delphi) results in the
> error "sqlite
Sorry about that, fixed.
On Sat, Aug 13, 2016 at 11:38 AM, Rousselot, Richard A
wrote:
> Your link says I do not have permission to open.
>
> -Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
> Behalf Of Random Coder
&
On Sat, Aug 13, 2016 at 8:39 AM, Rousselot, Richard A
wrote:
> Thanks, this does allow the library to load and process. The thing is your
> build is by far the slowest I have received, slower even than the 32-bit
> version.
Sorry about that, it was a debug build.
https://new-bucket-2a9cf983.s
On Fri, Aug 12, 2016 at 10:06 AM, Rousselot, Richard A
wrote:
> I, and others, have tried to compile this as a 64-bit library but it will not
> load from the command line (using .load) and gives the "Error: The specified
> module could not be found."
>
> Anyone have tips on how to resolve this?
On Wed, Feb 3, 2016 at 3:53 PM, Howard Chu wrote:
> No. Windows will toss clean pages out even in the total absence of memory
> pressure. It is moronic, but true. You can repeat the steps I outlined for
> yourself and see.
>
> https://groups.google.com/d/msg/comp.os.ms-windows.nt.misc/449tdNYPoX0/
On Wed, Dec 9, 2015 at 10:14 AM, Adam Devita wrote:
> To run MS-excell from the command line, you can call it from the full
> path (check version):
>
> "C:\Program Files\Microsoft Office\Office15\Excel.exe"
You can also run "start excel" to launch the current version of Excel.
Both of these are n
On Tue, Dec 8, 2015 at 4:30 PM, Bart Smissaert
wrote:
> So, what/where is that standard output channel?
> This is on a Win7 machine. How do I bring up that console window?
> There is no development environment here. I am running this from Excel.
> So, I have a standard Windows sqlite3.dll, a std_
On Mon, Nov 16, 2015 at 3:02 AM, Nader Lavasani
wrote:
> Bug? or my silly mistake?!
>From the documentation for sqlite3_prepare_v2:
"The calling procedure is responsible for deleting the compiled SQL
statement using sqlite3_finalize() after it has finished with it."
You're not doing this. Also
On Fri, Nov 13, 2015 at 1:46 PM, A. Mannini
wrote:
> 2) why there are SERVERLESS database (MS Access or VistaDB) that works
> without FS restrictions?
If you think Access works reliably on a network share, you're going to
run in to trouble sooner or later:
https://support.microsoft.com/en-us/kb
On Wed, Oct 14, 2015 at 9:55 AM, jose isaias cabrera
wrote:
> "The procedure entry point sqlite3_finalize could not be located in the
> dynamic link library SQLITE3.DLL."
>
> and the program aborts. I had to go back to v3.8.11.1 to make the program
> work again. Any thoughts? I thought that thi
On Fri, Aug 14, 2015 at 8:38 AM, Simon Slavin wrote:
> I have seen a problem like this only in one context, and it had nothing to do
> with SQLite. When an iDevice's power starts running low, it sends out
> notifications to all running Apps and expects their cooperation in shutting
> down. An
On Mon, May 18, 2015 at 9:43 AM, sonypsx wrote:
> may i kindly ask again about REGEX pcre DLL for Windows?
>
> Do someone have an idea or even a precompiled DLL which works under sqlite?
As you've found, you don't just need a pcre dll for windows, you need
a sqlite3 module to implement the callba
On Thu, Apr 2, 2015 at 10:58 AM, wrote:
>
> This are basically compiler switches as far as I understand.
>
> I am not a C programmer, so also quite difficult for me to link the library
> statically.
These tests basically map to the /SAFESEH, /DYNAMICBASE, and /NXCOMPAT
linker flags. Though, as
On Fri, Jan 16, 2015 at 2:21 PM, James K. Lowden
wrote:
> 5. The 32-bit windows sqlite3 shell supports extensions?
Yes, it does. The version on sqlite.org is compiled with that support.
> 6. The above messages come from the OS, and result from LoadLibrary
> failing? IOW, I didn't build a pro
On Fri, Jan 16, 2015 at 2:02 PM, Dave Dyer wrote:
> the input side of the pipe. Perhaps there is some windows conditioning
> that ought to be done by sqlite, on STDIN, to make it into a binary data
> source ?
You should be able to do a freopen(NULL, "rb", stdin); to change stdin
to be in binary
Could you not do something like this to handle the nullable types?
T GetValue(string field)
{
object obj = reader[field];
if (obj is System.DBNull)
return default(T);
else
return (T)obj;
}
Assuming the type is nullable, it should do the
On Tue, Apr 23, 2013 at 8:47 PM, Igor Korot wrote:
> query = wxString::Format(...);
> if( ( result = sqlite3_prepare_v2( m_handle, query, -1, &stmt, 0 ) ) !=
> SQLITE_OK )
>
It's been a while since I've worked with wxWidgets, but when I did,
wxString didn't support an implicit conversion like yo
On Wed, Mar 13, 2013 at 1:14 PM, Dominique Devienne wrote:
> On Mon, Mar 11, 2013 at 5:21 PM, Bert Huijben wrote:
>> Since Visual C++ 2005 the limit in PDB files was increased to 24 bit. You
>> might still get a warning for compatibility with older tools, but the 'well
>> known limitation' was re
On Tue, Jun 26, 2012 at 8:55 AM, wrote:
> I do realize and appreciate the public domain source is available. My best
> option is recompiling the DLL but since the project and make files aren't
> designed for Visual Studio it will require time that like everyone her I
> cherish.
To me the best op
On Fri, May 25, 2012 at 9:40 AM, Pavel Ivanov wrote:
> Except that 64-bit executable cannot load 32-bit DLL and vice versa.
> I'm not sure how this rule is applied to managed executables and DLLs
> loading unmanaged DLLs.
On a 64-bit machine managed executables run as 64-bit assemblies (and
thus
On Thu, Feb 9, 2012 at 2:34 PM, Tim Leland wrote:
> I can use CE if that's the problem. Can someone get sqlite3.exe shell to run
> on windows CE?
I'm sure someone can, but they'll need to know which architecture
you're running on, and possibly what CE components are in that
platform.
Depending o
On Thu, Feb 9, 2012 at 10:17 AM, Tim Leland wrote:
> Ok now I understand. I need the shell for windows mobile. The reason why im
> doing this is the application running on windows mobile is really just an
> html5 browser storing data in a sqlite database. I need to convert the
> sqlite database to
On Thu, Feb 9, 2012 at 10:07 AM, Tim Leland wrote:
> What software would I need to compile?
Persumably whatever software you're using to compile the rest of your
application. Visual Studio is the common way to compile Windows
Mobile applications.
SQLite is a library meant to be used in another
On Thu, Feb 9, 2012 at 9:57 AM, Tim Leland wrote:
> Ok so what would be the process of compiling the c#? Ive never done anything
> like that before.
Unless you have a need for the C# library, you should skip it. Just
bring in the C source file and header from the amalgamation from
http://www.sql
On Thu, Jun 23, 2011 at 9:27 AM, Cyrille wrote:
> Thank you for these guidelines. Unfortunately, it seems that Visual
> Studio is necessary and I just have the Express version. Do you confirm
> that with the Express version, rebuilding is not possible?
Sorry, I'd think Visual C++ 2010 Express is
On Wed, Jun 22, 2011 at 10:48 PM, Cyrille wrote:
>> Alternatively, you could recompile SQLite.Interop.dll to use the
>> static CRT library (/MT).
> Could you please let me know how to proceed to do this?
Download the source from
http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wik
On Wed, Jun 22, 2011 at 1:11 PM, Cyrille wrote:
> I confirm also that my project was set to "anycpu". If I change the
> setting to "x86", is the VS 2010 C++ Redistributable package still
> necessary?
Yes.
___
sqlite-users mailing list
sqlite-users@sqlit
On Wed, Jun 22, 2011 at 10:57 AM, Cyrille wrote:
> As you said, I have been surprised by the result. One of my users copied
> the missing DLL indicated by Depends (IEShims.dll) to the application
> folder and Depends indicates now another missing DLL: ieframe.dll which
> seems to be again linked t
On Fri, Apr 22, 2011 at 8:18 AM, Maurice Marinus
wrote:
> On a windows platform I have the following:
> schema.sql (contains the sql scripts)
> sqlite3.exe (command shell for sqlite -> downloaded from sqlite.org)
> build.bat : A batch file containing the line : sqlite3.exe -init
> schema.sql defau
On Feb 13, 2011, at 3:38 PM, BareFeetWare wrote:
> On 13/02/2011, at 1:04 AM, Yuzem wrote:
>
>> I am grabbing the data from the each movie imdb webpage.
>
> Does IMDB allow use of their data this way? After my brief reading of their
> site, I thought they charge a $15k minimum per year for dat
On Tue, Dec 21, 2010 at 10:06 AM,
wrote:
> I wonder about something : those functions are in kernel32.dll on a XP
> computer. Is it possible (I never do that before), to take the file
> "kernel32.dll" on my XP computer, to put it on the Win95 computer in the
> directory of my SQLite application, a
On Tue, Mar 16, 2010 at 6:21 PM, Rashed Iqbal wrote:
> Has anyone compiled and used SQLite on 64-bit Windows? Are there any
> code changes that would be needed before compiling? Would the same DB
> file work on 32-bit and 64-bit Windows platforms?
I routinely run SQLite on 64 bit and 32 bit windo
40 matches
Mail list logo