"Allan, Mark" <[EMAIL PROTECTED]> wrote:
> Have you been able to investigate this yet?
I have investigated and I found nothing wrong. I am unable
to reproduce the problem.
--
D. Richard Hipp <[EMAIL PROTECTED]>
"Eggert, Henri" <[EMAIL PROTECTED]> wrote:
> Hi sqlite-users
>
> Works fine : select Id from Data where ( ( Text = '' ) or ( Comming = ''
> ) )
> But NOT: select Id from Data where ( ( Text = '' ) and ( Comming =
> '' ) )
>
Both work fine when I try them. Why do you think the second one
is
> Hi Henri,
>
> On 18.10.2005, at 14:56, Eggert, Henri wrote:
>
> > 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 ?
> >
>
> It indeed is [1]. :)
>
>
> -Markus
>
> [1]
> >However I will look at using the reinterpret method and I will look more
> >at Jay's C++ wrapper (any chance of a peek at the src definitions?)
> >
> >
> >
> >
> Terry,
>
> You might want to check out the C++ wrapper classes at
> http://www.codeproject.com/database/CppSQLite.asp. There are also
Terence MacDonald wrote:
However I will look at using the reinterpret method and I will look more
at Jay's C++ wrapper (any chance of a peek at the src definitions?)
Terry,
You might want to check out the C++ wrapper classes at
http://www.codeproject.com/database/CppSQLite.asp. There
Hi Henri,
On 18.10.2005, at 14:56, Eggert, Henri wrote:
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 ?
It indeed is [1]. :)
-Markus
[1]
> 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,
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 ?
Thank's
Henri
-Ursprüngliche
>
> 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
Hi sqlite-users
Works fine : select Id from Data where ( ( Text = '' ) or ( Comming = ''
) )
But NOT: select Id from Data where ( ( Text = '' ) and ( Comming =
'' ) )
Any help would be appreciated.
Thanks's
Henri
PS : The table has been created with :
CREATE TABLE Data
(
Id integer
> delimited identifiers. Alternate output
> behaviour can be accomplished by a connection or
> statement specific pragma, or a wrapper.
IMHO a very good Delphi-wrapper
http://www.aducom.com/sqlite/
>
> -- Darren Duncan
--
Met vriendelijke groet
Bert Verhees
ROSA Software
At 9:50 PM -0300 10/17/05, [EMAIL PROTECTED] wrote:
I need to use a quoted identifiers and sqlite
support it well but when i obtain
the data from the database the cursos give to me
the fields with quotes. When i
do this directly there is no problem because i can remove the quotes, but i
access
Dan Kennedy wrote:
My hunch is that you need to change the while() line to:
while ( (rc = sqlite3_step(pStmt)) != SQLITE_DONE )
But I could be wrong, and I don't have a computer with a C compiler to test
this right now.
Terence MacDonald <[EMAIL PROTECTED]> wrote:
The following code is
Have you been able to investigate this yet? Any ideas or recommendations? I
sent you the analyzer output to [EMAIL PROTECTED] as it was too large to post
on here.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 12 October 2005 14:58
To:
14 matches
Mail list logo