Re: Accuracer Database

Lauchlan,

> For a start, take the first example where NexusDB 'failed':
>
> "SELECT First_Name, Last_Name FROM coders ORDER BY Salary"
>
> Does standard SQL allow you to order by a field not in the result set? I
> don't know, I don't think so, but it appears NexusDb wasn't designed to
> work
> that way. Is this a bad thing? Probably not. Perhaps it's more efficient
> to
> only order by the fields in the result set. I don't know.

Yes, the latest standard, SQL:1999 and SQL:2003, allow source columns that
are not referenced in the select list to be specified in the ORDER BY
clause, and in the GROUP BY clause as well. NexusDB V2, which conforms to
SQL:2003, supports this.

Regards
Ole Willy Tuv


.

Relevant Pages

  • Re: Accuracer Database
    ... >> Does standard SQL allow you to order by a field not in the result set? ... > clause, and in the GROUP BY clause as well. ... NexusDB V2, which conforms to ... Prev by Date: ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Accuracer Database
    ... I am using it in my multi-user application right now but I won't have any ... If you want my PERSONAL advice, I would recommend using NexusDB ... Shane ... >> Best Regards, ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Robust single file database
    ... Best regards ... NexusDB can have "child" tables, ... single file that contains multiple tables [FinalBuilder works in this ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Database replicator
    ... Yes, NexusDB too:-) ... With best regards, Mike Shkolnik ... Prev by Date: ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Does anyone know a good "blocking" alternative to FastNet
    ... >> IMHO, question is not about RemObjects, NexusDB and ... > original poster asked. ... I will consider NexusDB ... best regards ...
    (borland.public.delphi.thirdpartytools.general)