The command prompt here means your CMD.EXE (Windows) or *nix shell... you
must use sqlite3.exe [dbfile] to get the sqlite shell to use PRAGMA
*command prompt>* sqlite3 [database filename]
sqlite3> PRAGMA integrity_check;
On Tue, May 23, 2017 at 7:40 PM, Leona
> > I can't confirm this behaviour on anything other than 2010. But I seem to
> recall the same business a few months ago, when I must have been on 2008.
> > -Original Message-
> > From: sqlite-users-boun...@sqlite.org [mailto:
Which MSVC compiler has this bug? There's a link to information on that ?
On Thu, Sep 23, 2010 at 10:17, Ben Harper wrote:
> I just discovered the MSVC compiler generates bad debug info for source
> files larger than 64k lines, which is the case with the Sqlite amalgamation.
Sure (com certeza!), because it depends on the hardware and software of your
2010/2/10 Alberto Simões <hashas...@gmail.com>
> On Wed, Feb 10, 2010 at 5:42 PM, Virgilio Fornazin
> <virgilioforna...@gmail.com> wrote:
> > I think you should be asking 'How
I think you should be asking 'How fast is SQLite locating a key in a integer
column index vs a string index'...
Generally, integer keys are faster in key lookups than string keys, because
comparing a integer value is a
single CMP CPU instruction versus a more-complicated string comparison (that
You should read http://www.sqlite.org/datatype3.html , may help you.
On Tue, Nov 24, 2009 at 10:48, Virgilio Fornazin <virgilioforna...@gmail.com
> SQL does not have a specific datetime field type and also does not store it
> in binary format.
> You should perfor
SQL does not have a specific datetime field type and also does not store it
in binary format.
You should perform the data type conversions by yourself.
On Tue, Nov 24, 2009 at 09:50, Renato Oliveira wrote:
> Hello, I'm new to SQLite, and need a query to convert a number
field as NAME
does not work?
On Fri, Nov 13, 2009 at 12:07, Marco Bambini wrote:
> sqlite 3.6.19
> CREATE TABLE foo (col1 INTEGER PRIMARY KEY, col2 TEXT);
> SELECT rowid, col1, col2
> returns the following column names with sqlite3_column_name:
> col1, col1,
Because there are many platforms that sqlite runs (and can run at some time)
that doesn't have a C++ compiler available, but they always have a C
On Tue, Jun 2, 2009 at 12:33, Sylvain Pointeau
> I didn't mean to program with sqlite in C++ ...
Eclipse perform better for me than other all (Tortoise, WinCVS, etc).
Cross platform, excelent branching / merging support, visual list of
modified files, etc.
On Fri, Feb 27, 2009 at 03:51, J Jayavasanthan wrote:
> You can also use GNU WinCVS,
You can use SQLite ODBC Driver and SQL Management Studio Data Transfer
Wizard to perform this action.
On Wed, Nov 12, 2008 at 12:45 PM, Baskaran Selvaraj <
[EMAIL PROTECTED]> wrote:
> Hi All,
> This is Baskaran and I am looking for a vendor tool to automate the import
Patch posted to CVSTRAC timeline. Please take a look.
Ticket n# 3218
On Sun, Jul 13, 2008 at 11:04 AM, Virgilio Fornazin <
[EMAIL PROTECTED]> wrote:
> Thanks for your quick answer... I'll take a look at it to see and submit a
> patch to cvstrac if needed.
> Also, thanks ag
Thanks for your quick answer... I'll take a look at it to see and submit a
patch to cvstrac if needed.
Also, thanks again for this great library.
On Sun, Jul 13, 2008 at 12:47 AM, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
> On Jul 12, 2008, at 5:34 PM, Virgilio Fo
These mutex changes, with sqlite3_initialize() / finalize() calls, will
solve that problem reported that SQlite3 doesn't delete Critical Sections
under MS-Windows VFS ?
On Sat, Jul 12, 2008 at 6:00 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
> The current plan is to release SQLite version
IF you are using SQLite with eVC, you must enabled function level linking,
ARM linkers had a bug before eVC SP4 that generated corrupt image files.
On Thu, Jun 12, 2008 at 9:39 AM, sqlite <[EMAIL PROTECTED]> wrote:
> Dear All,
> We are using SQLite for our application development
what about creating a VFS for such task ? Can be accomplished in many ways,
using heap memory, shared memory... not so easy to do, but not much
complicated too... locking can be provided by multiple-readers
single-writers locks strategies, etc...
On Sat, Apr 19, 2008 at 2:29 PM, James Gregurich
DATEDIFF should compute the difference by arithmetic subtracting M/Y in
month case, if I'm not wrong
DateDiff (month, 1-1-2007, 3-30-2007) will return 2
Its that right ?
A good reference for trying implementing it should be:
I always create and XXX_Initialize() (and also XXX_Finalize() for resources
all libraries I created, because:
- You can perform initializations that cannot be done at compile time;
- You can create your internal structures in the required order (C++ has the
problem of initialization
I'm thinking about this.. to get a 'exact' copy of a sqlite database we
should implement a new public API:
sqlite3 * sqlite3_clonedb(sqlite3 * db, const char * szOutput);
sqlite3 * sqlite3_clonedb16(sqlite3 * db, const void * szOutput); // utf-16
this api can do the real file copy
(at least in my last builds)
On 9/18/07, Olaf Beckman Lapré <[EMAIL PROTECTED]> wrote:
> I'm trying to compile the amalgamation on Xubuntu Linux with G++ but I'm
> getting linking errors: several about pthread and others about dlopen() etc.
> Is there anything I need to add
Mail list logo