> But If I do "select data from pictures where (x between high_x and low_x)
> and (y between high_y and low_y) then this takes ca. 8 seconds (!) on
> wince.
My sql knowledge may be a little bit rusty and I have really no idea how
sqlite is doing "between" querys. Anyway, once I have learned never
On Tue, 12 Sep 2006 14:29:12 -0400
<[EMAIL PROTECTED]> wrote:
> files on your computer and this database file accidently got snagged?>
>
> Thanks, but this application resides on a PDA and my customer is
> reporting this issue on several PDA's. No search/replace operations are
> being performed
> This is not realy for this forum, but maybe somebody can tell me what I am
> doing wrong. I am using CppSQLite wrapper.
>
> Code 1 : With this code "Segmentation fault"
>
> const unsigned char* putBLOBInBinary(CppSQLite3DB , int ) {
> CppSQLite3Query q;
> CppSQLite3Binary blobGet;
>
>
I don't understand how this belongs to the thread "Request for comment:
Proposed SQLite API changes".
Gerald
On Fri, 4 Nov 2005 20:20:12 +0100
Marco Bambini <[EMAIL PROTECTED]> wrote:
> If table_A has mutiple rows (say like)
>
> column1 column2
> 1 B
> 2
> Hi,
>
> I want to select the records which have both columns Text and Comming
> empty.
>
> I have found that the problem is the column name "Text".
> If I replace the column name "Text" by another all works fine.
> So I wonder : is "Text" a keyword for sqlite ?
Why do you wonder? You used it
>
> Hi sqlite-users
>
> Works fine : select Id from Data where ( ( Text = '' ) or ( Comming = ''
> ) )
> But NOT: select Id from Data where ( ( Text = '' ) and ( Comming '' )
> )
What about this: select Id from Data where ( ( Text = '' ) and ( Comming =
'' ))
Gerald
>
>
> --- [EMAIL PROTECTED] wrote:
>
>> "Gerald Dachs" <[EMAIL PROTECTED]> wrote:
>> > > 2005-11-08 Frankfort, Germany
>> >
>> > I guess you mean Frankfurt ;). Be aware that the are two cities in
>> Germany
>> > that ar
> 2005-11-08 Frankfort, Germany
I guess you mean Frankfurt ;). Be aware that the are two cities in Germany
that are named Frankfurt. I expect that the Conference will be in Frankfurt
am Main and not in Frankfurt an der Oder.
Gerald
> I tested with:
>
> extern "C"
> {
> #include
> }
>
> but I always have the following error:
>
> ZeroLink: unknown symbol '__Z21sqlite3OsFullPathnamePKc'
>
> What to make?
I have expected that the definition is in sqlite3.h, what is not
the case. Try it with "os.h".
Anway, I believe that
> I added:
>
> extern "C"
> {
> #include
> }
I wrote this in the moment when the loudspeakers at the walls
told us all to leave the building, because of a technical problem.
> and I have a problem of compilation:
>
> sqlite.h: No such file or directory
>
>
> I tested with:
>
> extern "C"
> {
>
> Hello,
>
> I receive this error:
>
> ZeroLink: unknown symbol '__Z21sqlite3OsFullPathnamePKc'
>
> Why?
name mangling, use:
extern "C" {
#include
}
Gerald
> Hi,
>
> Could someone please shed some light what I should do?
> I've got the following errors.
>
> Thank you,
> Isarin
>
> gums-sun% make
> ./libtool --mode=compile gcc -g -O2 -DOS_UNIX=1 -DHAVE_USLEEP=1 -I.
> -I../sqlite-3.2.2/src -DNDEBUG -DSQLITE_OM\
> IT_CURSOR -c
> Hmm... nobody has an answer? Or did my message get eaten by a spam filter
> :(
>
> On Apr 4, 2005 8:02 PM, Cory Nelson <[EMAIL PROTECTED]> wrote:
>> Using the following:
>>
>> create table t_history(time real, ...);
>> create index i_time on t_history(time);
>> select count(*) from t_history
On Thu, 17 Mar 2005 06:56:04 -0500
"D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
> On Thu, 2005-03-17 at 12:39 +0100, Gerald Dachs wrote:
> > Why do you not use my patch? Do you not agree that this is a bug?
> >
>
> No I do not. The arch.png image is
Why do you not use my patch? Do you not agree that this is a bug?
'make doc' on linux is still broken, attached patch for 3.1.3 still
works.
Gerald
--- sqlite-3.1.3/Makefile.in.orig 2005-03-07 22:56:04.833954328
+0100 +++ sqlite-3.1.3/Makefile.in2005-03-07 22:56:41.189427456
+0100 @@
On Fri, 11 Mar 2005 13:07:40 -0500
"D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
> Version 3.1.5 is now available on the website. This release
> fixes a typo in the previous release that caused problems
> for OS-X users.
> --
> D. Richard Hipp <[EMAIL PROTECTED]>
>
'make doc' on linux is still
> SQLite version 3.1.4 is now available on the website.
> http://www.sqlite.org/
>
'make doc' on linux is still broken, attached patch for 3.1.3 still
works.
Gerald
--- sqlite-3.1.3/Makefile.in.orig 2005-03-07 22:56:04.833954328 +0100
+++ sqlite-3.1.3/Makefile.in2005-03-07
On Mon, 7 Mar 2005 17:30:07 -0500
"Griggs, Donald" <[EMAIL PROTECTED]> wrote:
> Hi Gerald,
>
> I don't think attachments are allowed on the list.
Thank you, I noticed it only now.
> You may want to check
> the contributions section of the wiki, or perhaps the version tracking
> system.
I
18 matches
Mail list logo
