Is there some form of being how default, and not to need to place in each
clause order by?



For the database or for the component?



Thankful



Hello Nelson,

> I don't know it is if the bank or the access component, IBO, but in
> it consults them that I accomplish for a field that has null, I
> register them with null they appear first, before updating it was
> not like this.

I guess you mean: before updating to Firebird 2?

That's right: in Firebird 2 nulls appear at the "smallest" end of the
sort (unless overridden by NULLS FIRST/LAST). In Firebird 1.5 they
appeared at the tail end (unless etc.)

It's not a problem, it's a solution :-)
And you can always override the placement in your ORDER BY clause.

See HYPERLINK
"http://www.firebirdsql.org/manual/nullguide-sorts.html"http://www.firebird-
sql.org/manual/-nullguide--sorts.html

Hope this helps,
Paul Vinkenoog




_____

Esta mensagem foi verificada pelo HYPERLINK
"http://mail.terra.com.br/"E-mail Protegido Terra.
Scan engine: McAfee VirusScan / Atualizado em 19/04/2007 / Versão:
5.1.00/5013
Proteja o seu e-mail Terra: HYPERLINK
"http://mail.terra.com.br/"http://mail.terra.com.br/


--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 269.5.5/769 - Release Date: 19/4/2007
17:56



--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 269.5.5/769 - Release Date: 19/4/2007
17:56



[Non-text portions of this message have been removed]