Hi list,
sqlite version: 3.3.8
I have 2 tables:
---
CREATE TABLE kereset (realid INTEGER NOT NULL, id INTEGER NOT NULL, datum
DATETIME, jogcim CHAR(1) NOT NULL, brutto INT NOT NULL, ado INT NOT NULL,
adoalap INT NOT NULL);
CREATE TABLE szemely (id INTEGER NOT NULL, nev VARCHAR(128) NOT NULL COLLATE
MAGYAR, leanynev VARCHAR(128) COLLATE MAGYAR, anyanev VARCHAR(128) COLLATE
MAGYAR, szulhely VARCHAR(128) COLLATE MAGYAR, szuldat DATETIME, adoszam
VARCHAR(10), irszam INT, varos VARCHAR(64) COLLATE MAGYAR, cim VARCHAR(128)
COLLATE MAGYAR, telefon VARCHAR(64), adoalap INT, adosav INT, szolgdij INT,
torolve BOOLEAN DEFAULT FALSE);
---
my query:
---
SELECT szemely.nev, szemely.anyanev, szemely.szulhely, szemely.adoszam,
kereset.datum,szemely.id FROM szemely,kereset WHERE (kereset.datum >=
19950101 AND kereset.datum <= 19951231) AND (szemely.nev >= '0000000' AND
szemely.nev <= 'zzzzzzz') AND kereset.id = szemely.id ORDER BY
szemely.nev,szemely.anyanev
---
This query works fine (I think my collate function too), but if I accomodate
it with "ORDER BY szemely.nev,szemely.anyanev,kereset.datum", then sorting
is in wrong order.
If you need it, I send my collate function.
regards
---
kiru
----
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
