Many thanks to all those who have given me great tips.
*Sintoni Stefano*
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
2011/7/22 Sintoni Stefano (GMAIL) :
> More thanks,
> I understand that but why the same query, with the same data, return two
> different result using different SQLite-based Win32 applications ?
>
> In any case how I can take the result I need ? I not have other column
> right for made one ORDER BY
On Fri, Jul 22, 2011 at 03:37:34PM +0200, Sintoni Stefano (GMAIL) scratched on
the wall:
> More thanks,
> I understand that but why the same query, with the same data, return two
> different result using different SQLite-based Win32 applications ?
My best guess is that they're using different v
tics Directorate
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Sintoni Stefano (GMAIL) [stefano.sintoni.cnigr...@gmail.com]
Sent: Friday, July 22, 2011 8:54 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] Strange result using JOIN
I don't have other column good for use the SELECT.
Now I don't have good columns to use the SELECT, now I'm afraid my only
solution is to create a new column with a value of the order generated
by my application.
Stefano
On 07/22/2011 03:45 PM, Simon Slavin wrote:
> On 22 Jul 2011, at 2:37pm, S
>I understand that but why the same query, with the same data, return two
>different result using different SQLite-based Win32 applications ?
SQL is essentially based on set theory. Sets don't have intrinsic
ordering and may be enumerated in whatever order. What you think are
distinct results
On 22 Jul 2011, at 2:37pm, Sintoni Stefano (GMAIL) wrote:
> In any case how I can take the result I need ? I not have other column
> right for made one ORDER BY and I need to respect the sequence or CODE
> table like
>
> The table CODE.
> CODE;VALUE;
> 61311;18462F;
> 61311;18461F;
SQL has no c
More thanks,
I understand that but why the same query, with the same data, return two
different result using different SQLite-based Win32 applications ?
In any case how I can take the result I need ? I not have other column
right for made one ORDER BY and I need to respect the sequence or CODE
tab
On Fri, Jul 22, 2011 at 09:23:36AM +0200, Sintoni Stefano (GMAIL) scratched on
the wall:
> Hi,
> I get a strange result using JOIN on one very simple application using
> SQLite.
> The table ELAB are populated with the follow SQL query:
> INSERT INTO ELAB SELECT CODE.* FROM JOB JOIN CODE ON CO
Hi,
I get a strange result using JOIN on one very simple application using
SQLite.
I have made one Win32 custom application (made with MS Visual Studio 6)
using sqlite3.dll rel. 3.7.2.
On my situation I have three table like follow.
Table CODE made with:
CREATE TABLE CODE (CODE TEXT DEFAULT
10 matches
Mail list logo