ORDER BY "Date" does not work in 1.07

Hi the following query used to work in 1.06 and it does not work in 1.07.
If the ORDER BY "Date" the query runs fine.

SELECT "Date",
"Client_Code_Adresse",Client,"PO_PPD","PO_Client", "Piece_PPD","Piece_Client"
,"Qty_Ord","Qty_Ship", ("Qty_Ord" -"Qty_Ship") AS QtyBO, Comment FROM
"Shipping_Planning"
ORDER BY "Date"

The error is: Unknown column: "Date"

Thanks.



--
Regards from Quebec.

David Charron

David Charron wrote:

>Hi the following query used to work in 1.06 and it does not work in 1.07.
>If the ORDER BY "Date" the query runs fine.
>
>SELECT "Date",
>"Client_Code_Adresse",Client,"PO_PPD","PO_Client" ,"Piece_PPD","Piece_Client"
>,"Qty_Ord","Qty_Ship", ("Qty_Ord" -"Qty_Ship") AS QtyBO, Comment FROM
>"Shipping_Planning"
>ORDER BY "Date"
>
>The error is: Unknown column: "Date"
>
>Thanks.
>
>
>
>
>
See the patch in Per's response to RE: burned .... by David Guest. I
think it might solve your problem

David Guest <dpguest@bestweb.net> wrote in <40eeff42@wic040d.>:

> See the patch in Per's response to RE: burned .... by David Guest. I
> think it might solve your problem
>
Thanks. I'll wait for the next update then.
We only use "official" binaries compiled by nexusdb for our production
server.


--
Regards from Quebec.

David Charron

David Charron wrote:

>David Guest <dpguest@bestweb.net> wrote in <40eeff42@wic040d.>:
>
>
>
>>See the patch in Per's response to RE: burned .... by David Guest. I
>>think it might solve your problem
>>
>>
>>
>Thanks. I'll wait for the next update then.
>We only use "official" binaries compiled by nexusdb for our production
>server.
>
>
>
>
You might apply the patch and create a test server to determine if in
fact it solves your problem ... Then you can wait for the official
release ... or if it does not, you can advise Nexus of that fact.

David,
You may want to try

ORDER BY Shipping_Planning."Date"

Srini.

"David Charron" <davchaNO@SPAMppdgroup.com> wrote in message
news:Xns9521A7F1F2669davchappdgroupcom@203.147.131 .213...
> David Guest <dpguest@bestweb.net> wrote in <40eeff42@wic040d.>:
>
> > See the patch in Per's response to RE: burned .... by David Guest. I
> > think it might solve your problem
> >
> Thanks. I'll wait for the next update then.
> We only use "official" binaries compiled by nexusdb for our production
> server.
>
>
> --
> Regards from Quebec.
>
> David Charron

> Thanks. I'll wait for the next update then.
> We only use "official" binaries compiled by nexusdb for our production
> server.

Please try applying the change to a test server and see if it helps with
your problem. We try to avoid releasing new updates every week. :-)

--

Eivind Bakkestuen [NDD]
Please, no email unless requested.
Search Borland and third-party newsgroups here: www.tamaracka.com