Walter, conosco tu pagina me encanta, siempre compartiendo información de los
problemas cotidianos.En general es el primer lugar a consultar, esta vez no fue
así. Te pido disculpas . no volverá a pasar.Para tu tranquilidad al recivir la
respuesta Karol, lo primero que hice fue buscar "ORDER BY CASE" y adivina a
donde fui a caer. Si a Firebird21.
Muchas gracias por tu dedicación.
Te saludo desde Buenos AiresGermán
El Martes, 6 de octubre, 2015 21:02:31, "'Walter R. Ojeda Valiente'
sistemas2000profesio...@gmail.com [firebird-support]"
<firebird-support@yahoogroups.com> escribió:
Germán, as you can read Spanish, this article can be useful:
https://firebird21.wordpress.com/2014/11/20/mostrando-los-resultados-ordenados-por-cualquier-criterio/
Greetings.
Walter.
On Tue, Oct 6, 2015 at 6:17 PM, Germán Balbi bal...@yahoo.com
[firebird-support] <firebird-support@yahoogroups.com> wrote:
Excellent, very simple. Thank Karol
El Martes, 6 de octubre, 2015 16:32:08, "liviusliv...@poczta.onet.pl
[firebird-support]" <firebird-support@yahoogroups.com> escribió:
Hi, ORDER BY CASE USER_NAME WHEN ‘PAUL’ THEN 1 WHEN ‘JOHN’ THEN 2 .. END
regards,Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent:
Tuesday, October 06, 2015 5:20 PMTo: Firebird Support Subject:
[firebird-support] Order by Hello everyone There is the possibility of
ordering the result of a SELECT in an order specified by the user.For
examplehaving a field NAMEin the clause ORDER BY 'PAUL, JOHN, PETER, MARIA' Of
course, that should be all the options set
Thank you.
Hola a todos Existe la posibilidad de ordenar el resultado de un SELECT en un
order especificado por el usuario.Por ejemploteniendo un campo NOMBREen la
clausula ORDER BY 'PABLO, JUAN, PEDRO, MARIA' Claro esta, que se deben tener
todas las opciones establecidas gracias.
#yiv9527526986 -- #yiv9527526986ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9527526986
#yiv9527526986ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9527526986
#yiv9527526986ygrp-mkp #yiv9527526986hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9527526986 #yiv9527526986ygrp-mkp #yiv9527526986ads
{margin-bottom:10px;}#yiv9527526986 #yiv9527526986ygrp-mkp .yiv9527526986ad
{padding:0 0;}#yiv9527526986 #yiv9527526986ygrp-mkp .yiv9527526986ad p
{margin:0;}#yiv9527526986 #yiv9527526986ygrp-mkp .yiv9527526986ad a
{color:#0000ff;text-decoration:none;}#yiv9527526986 #yiv9527526986ygrp-sponsor
#yiv9527526986ygrp-lc {font-family:Arial;}#yiv9527526986
#yiv9527526986ygrp-sponsor #yiv9527526986ygrp-lc #yiv9527526986hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9527526986
#yiv9527526986ygrp-sponsor #yiv9527526986ygrp-lc .yiv9527526986ad
{margin-bottom:10px;padding:0 0;}#yiv9527526986 #yiv9527526986actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9527526986
#yiv9527526986activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9527526986
#yiv9527526986activity span {font-weight:700;}#yiv9527526986
#yiv9527526986activity span:first-child
{text-transform:uppercase;}#yiv9527526986 #yiv9527526986activity span a
{color:#5085b6;text-decoration:none;}#yiv9527526986 #yiv9527526986activity span
span {color:#ff7900;}#yiv9527526986 #yiv9527526986activity span
.yiv9527526986underline {text-decoration:underline;}#yiv9527526986
.yiv9527526986attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9527526986 .yiv9527526986attach div a
{text-decoration:none;}#yiv9527526986 .yiv9527526986attach img
{border:none;padding-right:5px;}#yiv9527526986 .yiv9527526986attach label
{display:block;margin-bottom:5px;}#yiv9527526986 .yiv9527526986attach label a
{text-decoration:none;}#yiv9527526986 blockquote {margin:0 0 0
4px;}#yiv9527526986 .yiv9527526986bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9527526986
.yiv9527526986bold a {text-decoration:none;}#yiv9527526986 dd.yiv9527526986last
p a {font-family:Verdana;font-weight:700;}#yiv9527526986 dd.yiv9527526986last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9527526986
dd.yiv9527526986last p span.yiv9527526986yshortcuts
{margin-right:0;}#yiv9527526986 div.yiv9527526986attach-table div div a
{text-decoration:none;}#yiv9527526986 div.yiv9527526986attach-table
{width:400px;}#yiv9527526986 div.yiv9527526986file-title a, #yiv9527526986
div.yiv9527526986file-title a:active, #yiv9527526986
div.yiv9527526986file-title a:hover, #yiv9527526986 div.yiv9527526986file-title
a:visited {text-decoration:none;}#yiv9527526986 div.yiv9527526986photo-title a,
#yiv9527526986 div.yiv9527526986photo-title a:active, #yiv9527526986
div.yiv9527526986photo-title a:hover, #yiv9527526986
div.yiv9527526986photo-title a:visited {text-decoration:none;}#yiv9527526986
div#yiv9527526986ygrp-mlmsg #yiv9527526986ygrp-msg p a
span.yiv9527526986yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9527526986
.yiv9527526986green {color:#628c2a;}#yiv9527526986 .yiv9527526986MsoNormal
{margin:0 0 0 0;}#yiv9527526986 o {font-size:0;}#yiv9527526986
#yiv9527526986photos div {float:left;width:72px;}#yiv9527526986
#yiv9527526986photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9527526986
#yiv9527526986photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9527526986
#yiv9527526986reco-category {font-size:77%;}#yiv9527526986
#yiv9527526986reco-desc {font-size:77%;}#yiv9527526986 .yiv9527526986replbq
{margin:4px;}#yiv9527526986 #yiv9527526986ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9527526986 #yiv9527526986ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9527526986
#yiv9527526986ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9527526986
#yiv9527526986ygrp-mlmsg select, #yiv9527526986 input, #yiv9527526986 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9527526986
#yiv9527526986ygrp-mlmsg pre, #yiv9527526986 code {font:115%
monospace;}#yiv9527526986 #yiv9527526986ygrp-mlmsg *
{line-height:1.22em;}#yiv9527526986 #yiv9527526986ygrp-mlmsg #yiv9527526986logo
{padding-bottom:10px;}#yiv9527526986 #yiv9527526986ygrp-msg p a
{font-family:Verdana;}#yiv9527526986 #yiv9527526986ygrp-msg
p#yiv9527526986attach-count span {color:#1E66AE;font-weight:700;}#yiv9527526986
#yiv9527526986ygrp-reco #yiv9527526986reco-head
{color:#ff7900;font-weight:700;}#yiv9527526986 #yiv9527526986ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9527526986 #yiv9527526986ygrp-sponsor
#yiv9527526986ov li a {font-size:130%;text-decoration:none;}#yiv9527526986
#yiv9527526986ygrp-sponsor #yiv9527526986ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9527526986
#yiv9527526986ygrp-sponsor #yiv9527526986ov ul {margin:0;padding:0 0 0
8px;}#yiv9527526986 #yiv9527526986ygrp-text
{font-family:Georgia;}#yiv9527526986 #yiv9527526986ygrp-text p {margin:0 0 1em
0;}#yiv9527526986 #yiv9527526986ygrp-text tt {font-size:120%;}#yiv9527526986
#yiv9527526986ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9527526986
