RE: [sqlite] Can't order a view with joins

2003-12-04 Thread Fitzharris, Jason
rds, Jason. -Original Message- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: 04 December 2003 13:20 To: Fitzharris, Jason Cc: [EMAIL PROTECTED] Subject: Re: [sqlite] Can't order a view with joins Fitzharris, Jason wrote: > Hi, > I am getting an error when trying to do an order by

Re: [sqlite] Can't order a view with joins

2003-12-04 Thread D. Richard Hipp
Fitzharris, Jason wrote: Hi, I am getting an error when trying to do an order by on a view which has a join. To replicate, create the following two tables and the view. CREATE TABLE tabTest_1 ( Field_1_1 CHAR(10), Field_1_2 CHAR(10), Field_1_3 CHAR(10), Field_1_4 CHAR(10) ) CREATE TABLE t

RE: [sqlite] Can't order a view with joins

2003-12-04 Thread Fitzharris, Jason
on a view allows the user maximum flexibility when customising the product. Regards, Jason. -Original Message- From: George Gensure [mailto:[EMAIL PROTECTED] Sent: 04 December 2003 11:12 To: Fitzharris, Jason Cc: [EMAIL PROTECTED] Subject: Re: [sqlite] Can't order a view with joins

Re: [sqlite] Can't order a view with joins

2003-12-04 Thread George Gensure
ield_1_1 = Field_2_1 ORDER BY Field_1_1 However, this defeats the point of having views in the first place. Regards, Jason. -Original Message- From: George Gensure [mailto:[EMAIL PROTECTED] Sent: 02 December 2003 16:40 To: Fitzharris, Jason Cc: [EMAIL PROTECTED] Subject: Re: [sqlite] Can'

RE: [sqlite] Can't order a view with joins

2003-12-04 Thread Fitzharris, Jason
ct: Re: [sqlite] Can't order a view with joins One way I get around this sort of problem is to have the view order itself by specifying an ORDER BY in the CREATE VIEW. This is limited, obviously, since the only times I want data out of this view, I want it in order, but if this is the cas

Re: [sqlite] Can't order a view with joins

2003-12-02 Thread George Gensure
One way I get around this sort of problem is to have the view order itself by specifying an ORDER BY in the CREATE VIEW. This is limited, obviously, since the only times I want data out of this view, I want it in order, but if this is the case with your work, it should do nicely. -George [EMAIL P