FiveTech Software tech support forums

Ahora, sí, Manuel. Perfecto.
El caso es que estaba manejando el JOIN para unir las consultas, pero con UNION ALL ha salido perfecto.

Gracias a todos.
Saludos

Creo que esto también debe funcionar:
(SELECT NUMERO
FROM EMPRESA NUMERO Like "*CV"
ORDER BY NUMERO )
UNION ALL
(SELECT NUMERO
FROM EMPRESA
WHERE NUMERO Not Like "*CV"
ORDER BY NUMERO);
Ya que tu haces la distinción con el LIKE

... va un poco mejor... Prueba esto: (SELECT NUMERO. FROM EMPRESA (((NUMERO) Like "*CV")) ORDER BY Right(String(7,'0') & NUMERO,'7') ) UNION ALL (SELECT NUMERO FROM EMPRESA WHERE (((NUMERO) Not Like "*CV")) ORDER BY Right(String(7,'0') & NUMERO,'7')); Mira el UNION ALL :P

... cursor is used if the SELECT statement does not contain any of the following: · • DISTINCT in the SELECT clause · • Joins (inner, outer, self, or UNION) · • Any aggregate function · • GROUP BY or HAVING clauses · • Subqueries · • Certain scalar functions (see Scalar Functions in a WHERE Clause) ...

... settings. Once you're ready I'll post here. -What can we import with the menu “Form” “Import…” This option is to import the project "Visual Union." It is not yet finished. -I tryed to select code inside the “prg” window to copy parts of the prg-code. But this does not work. At first ...

Also copied to:

http://code.google.com/p/fivewin-contributions/downloads/detail?name=union.zip&can=2&q=

Antonio,

imagino que se refiere a Visual Union.

http://www.pctoledo.com.br/forum/filebase.php?d=1&id=143&c_old=0&what=c&page=1

Saludos,

Félix

In my prior Job I had to make the scheduling work in many big Construction Projects were Union Companies had to be scheduled, and I used MicroSoft Projects, but I don't see any other use ratter than to build scheduling software, I never even used it in the small construction ...

Hola amigos del foro

Desearia saber com puedo hacer la union de varias celdas usando TExcelScript() para que al colocar un texto en dicha celda quede centrado...
No se como decirlo de otra forma, espero que me entiendan...

Ademas, como usar colores para el texto y para el fondo de la celda

Gracias

En la union esta la fuerza y el que persevera vence...palabras de alguien, pero muy ciertas, ya te montastes en el tren FWH, ahora disfrute el viaje, recomendaciones, xEDIT, PELLEC C, VERCE, PROMETHEUS, utilizades gratuitas y ...

Boa Tarde..
A pagina do CentralXbase saiu do ar. tente falar com o Ricardo M Marques. ele é o criador do Visual Union, talvez ele possa te ajudar no que vc. precisa..

ricardomouramarques@hotmail.com

Abraços..

Antonio,
the link was:
vrmm.com.br
But it seems that this is not working at the moment.
Best regards,
Otto

Otto,

Is there a URL to download it ? or a demo version ? thanks

Hello Antonio,

It is a visual IDE for Fivewin.

The manual shows:

DeDesenvolvimento:
Ricardo de Moura Marques
Dúvidas, críticas e sugestões:
union@vrmm.com.br
as author.

Best regards,
Otto

Otto,

What is Visual Union ?