Re: [sqlite] Is this a problem?

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 integrity_check; *command prompt>* sqlite3 [database filename] sqlite3> PRAGMA integrity_check; sqlite3> .quit On Tue, May 23, 2017 at 7:40 PM, Leona

Re: [sqlite] Breakpoints uncorrelated on MSVC amalgamation build

qs.co.za> wrote: > > 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: > sqlite-users-

Re: [sqlite] Breakpoints uncorrelated on MSVC amalgamation build

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. >

Re: [sqlite] String Vs Integer Index

Sure (com certeza!), because it depends on the hardware and software of your target platform. 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

Re: [sqlite] String Vs Integer Index

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

Re: [sqlite] Data converting

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 > wrote: > SQL does not have a specific datetime field type and also does not store it > in binary format. > You should perfor

Re: [sqlite] Data converting

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

Re: [sqlite] sqlite3_column_name

SELECT 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); > a > SELECT rowid, col1, col2 > > returns the following column names with sqlite3_column_name: > col1, col1,

Re: [sqlite] sqlite programmed in C++

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 compiler. []'s On Tue, Jun 2, 2009 at 12:33, Sylvain Pointeau wrote: > I didn't mean to program with sqlite in C++ ... >

Re: [sqlite] A bit OT: Good CVS client for Windows

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,

Re: [sqlite] SQLite Import Tool

Hi 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 > process. > We

Re: [sqlite] SQLite 3.6.0 coming soon...

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

Re: [sqlite] SQLite 3.6.0 coming soon...

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

Re: [sqlite] SQLite 3.6.0 coming soon...

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

Re: [sqlite] sqlite3.lib for ARMV4T processor

IF you are using SQLite with eVC, you must enabled function level linking, because 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

Re: [sqlite] multiple writers for in-memory datastore

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

Re: [sqlite] Date arithmetic question

DATEDIFF should compute the difference by arithmetic subtracting M/Y in month case, if I'm not wrong ex: DateDiff (month, 1-1-2007, 3-30-2007) will return 2 Its that right ? A good reference for trying implementing it should be: http://www.sqlteam.com/article/datediff-function-demystified

Re: [sqlite] Proposed sqlite3_initialize() interface

I always create and XXX_Initialize() (and also XXX_Finalize() for resources cleanup) in 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

Re: [sqlite] how to get file handle from sqlite3 object?

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 version this api can do the real file copy

Re: [sqlite] Compiling amalgamation with G++

-ldl -lpthread (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