Thank's for help!!!



Resolved the problem, but now I don't find registers that began with the
letter Y and Z.



Is that a problem of FB 2.0 or of the component TIB_IncSearsh?





Nelson Vechini



_____

De: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] Em nome de
Nelson - Terra
Enviada em: sexta-feira, 20 de abril de 2007 11:30
Para: IBObjects@yahoogroups.com
Assunto: RES: [IBO] FB 2.0 com IBO 4.7.16 - Order of the null fields



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
"HYPERLINK
"http://www.firebirdsql.org/manual/nullguide-sorts.html"http://www.firebird-
sql.org/manual/-nullguide--sorts.html"HYPERLINK
"http://www.firebird-"http://www.firebird--
sql.org/manual/--nullguide---sorts.html

Hope this helps,
Paul Vinkenoog

_____

Esta mensagem foi verificada pelo HYPERLINK
"HYPERLINK "http://mail.terra.com.br/"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
"HYPERLINK "http://mail.terra.com.br/"http://mail.-terra.com.-br/"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]




_____

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.463 / Virus Database: 269.5.9/773 - Release Date: 22/4/2007
20:18



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