Search found 98 matches: union

Searched query: union

by JoseAlvarez
Mon Feb 10, 2025 9:58 pm
Forum: FiveWin para Harbour/xHarbour
Topic: Incompatibilidad tDolphin - IA - MySQl
Replies: 4
Views: 456

Incompatibilidad tDolphin - IA - MySQl

... doc_pagado) AS total_doc_pagado,
SUM(monto) AS total_monto,
0 AS orden
FROM temp_resultados
GROUP BY fecha_pago, codigo_medio, nombre_medio

UNION ALL

-- Filas de subtotales (colocadas después)
SELECT
fecha_pago,
'SUBTOTAL' AS nombre_medio,
NULL AS codigo_medio,
NULL AS numero_recibos ...
by Antonio Linares
Fri Oct 11, 2024 3:57 pm
Forum: FiveWin para Harbour/xHarbour
Topic: Cambiar Prompt de Mensage
Replies: 11
Views: 1553

Re: Cambiar Prompt de Mensage

Haz esto:

oMsg:cMsgDef := "nuevo mensaje"
oMsg:Refresh()

Puedes actualizar desde nuestra web usando la tarjeta de crédito ó por Western Union ó PayPal a alinares@fivetechsoft.com

gracias!
by TOTOVIOTTI
Mon Sep 09, 2024 12:13 pm
Forum: FiveWin para Harbour/xHarbour
Topic: Propuesta para que hagan un curso virtual FW
Replies: 302
Views: 78393

Re: Propuesta para que hagan un curso virtual FW

Hola!!

Acabo de realizar el pago. Ya le envío el comprobante a Antonio.
Lo hice por Western Union...

Roberto
by Antonio Linares
Mon Jan 15, 2024 7:55 am
Forum: FiveWin for Harbour/xHarbour
Topic: Fine tune Phi2 from Microsoft with your own data
Replies: 11
Views: 2913

Re: Fine tune Phi2 from Microsoft with your own data

... the purusha and the prakriti. Karma can be overcome by knowledge, wisdom, and devotion.

- Moksha: This is the liberation, the release, and the union that the jiva can attain by realizing its true nature, which is Brahman. Moksha is the cause of all happiness, and the obstacle to all suffering ...
by Antonio Linares
Wed May 03, 2023 6:44 am
Forum: FiveWin for Harbour/xHarbour
Topic: Protecting certain functions to be used
Replies: 6
Views: 672

Re: Protecting certain functions to be used

I just realized that scope.pointer is member of an union and not a member of a struct, so modifying scope.pointer will be affecting the scope of the symbol.

This would be the right way to do it:
function Main()

local pFunPtr := HB_Protect( "memoWrit" )

memoWrit()

// later on
// HB_Unprotect ...
by reinaldocrespo
Sat May 14, 2022 12:53 pm
Forum: FiveWin for Harbour/xHarbour
Topic: ADS - The future is <sadly> now so where do you go ?
Replies: 26
Views: 5320

Re: ADS - The future is <sadly> now so where do you go ?

... Tb01.nAtoLivro ,
Tb01.nAtoFolha FROM N_AUT_DOCUMENTOS AS Tb01
Where Tb01.nAtoLivro = _nLivro_Lanca_ and Tb01.cAgeCompareceuNome <> ''
Union Select
Tb02.cAgeCompareceuDoc ,
Tb02.nAtoNumero ,
Tb02.nAtoLivro ,
Tb02.nAtoFolha FROM CartDistribuidor.N_AUT_DOCUMENTOS AS Tb02
Where Tb02 ...
by Giovany Vecchi
Tue Apr 26, 2022 1:57 am
Forum: FiveWin for Harbour/xHarbour
Topic: ADS - The future is <sadly> now so where do you go ?
Replies: 26
Views: 5320

Re: ADS - The future is <sadly> now so where do you go ?

... I will explain a situation.
1-Open the data dictionary of the present registry office. Ex: \\Server\UNC\Folder\MyDictionary.add
2-I'm going to UNION the AGENT's Document linking it to another data dictionary that is in the central registry office on the internet. Ex: \\201.64.98.121:2660\UNC ...
by JoseAlvarez
Fri Dec 24, 2021 4:20 pm
Forum: FiveWin para Harbour/xHarbour
Topic: FELIZ NAVIDAD A TODOS!!!
Replies: 11
Views: 795

Re: FELIZ NAVIDAD A TODOS!!!

¡ FELIZ NAVIDAD Y NOCHEBUENA PARA TODOS!

La Bendición de Dios para todos Uds., hermanos, amigos y colegas... en union de todos los suyos.

Una abrazo...
by Antonio Linares
Tue Nov 30, 2021 10:38 pm
Forum: WhatsNew / Novedades
Topic: New FTDN November/Noviembre (FWH 21.11)
Replies: 2
Views: 2505

Re: New FTDN November/Noviembre (FWH 21.11)

... funciona bien donde cTable es una tabla, vista o una consulta SQL simple
pero falla con consultas complejas, por ejemplo, conteniendo la cláusula UNION. Ahora cTable también puede ser
una consulta compleja.

* La función MemoryBufferType() ahora reconoce también ficheros DOC,PDF.

* Cuando se ...
by Antonio Linares
Tue Nov 30, 2021 7:19 am
Forum: WhatsNew / Novedades
Topic: New FTDN November/Noviembre (FWH 21.11)
Replies: 2
Views: 2505

New FTDN November/Noviembre (FWH 21.11)

... Method PivotArray( cTable, ... ) works well where cTable is a table,
view or a simple Sql query but failing with complex queries eg.,
contaiting UNION clause. Now cTable can be a complex query also.

* function MemoryBufferType() now recognizes DOC.PDF also.

* When CenterMsgs( .t. ) is set, now ...
by jose_murugosa
Fri May 07, 2021 4:31 pm
Forum: FiveWin para Harbour/xHarbour
Topic: *** Curso de C para programadores Harbour.
Replies: 141
Views: 28771

Re: *** Curso de C para programadores Harbour.

Parece que me dormí en los laureles.

¿Me podrían indicar como iniciar mi participación del curso y como hacer el pago correspondiente?

En uruguay la forma más practica que tengo es Giros Western Union.

Gracias.
by Silvio.Falconi
Fri Apr 02, 2021 9:07 am
Forum: FiveWin for Harbour/xHarbour
Topic: Help checking these forums cookies
Replies: 22
Views: 3101

Re: Help checking these forums cookies

Antonio,
I had the same problem in a forum of a workers' union
there is an problem on phpbb

Please Read my notice look this


m

1 . The ACP
phpBB3 has the option to manually change your Cookie settings in the ACP.

First go to the window to edit your settings.
You can find it here: ACP ==> Tab ...
by joseluisysturiz
Tue Feb 23, 2021 11:58 pm
Forum: FiveWin para Harbour/xHarbour
Topic: Sistema multi empresa con mysql
Replies: 16
Views: 2860

Re: Sistema multi empresa con mysql

... que anteponer el nombre de la base de datos a cada tabla (ya que todas las tablas se llaman igual en las distintas bases de datos) y hacer el UNION de los datos que quieres sacar.
Ejemplo :
SELECT res.* FROM ( SELECT SUM(importe ) as importe, 1 as empresa FROM base1.ventas WHERE fecha BETWEEN ...
by cmsoft
Tue Feb 23, 2021 11:32 pm
Forum: FiveWin para Harbour/xHarbour
Topic: Sistema multi empresa con mysql
Replies: 16
Views: 2860

Re: Sistema multi empresa con mysql

... que anteponer el nombre de la base de datos a cada tabla (ya que todas las tablas se llaman igual en las distintas bases de datos) y hacer el UNION de los datos que quieres sacar.
Ejemplo :
SELECT res.* FROM ( SELECT SUM(importe ) as importe, 1 as empresa FROM base1.ventas WHERE fecha BETWEEN ...
by
Fri Dec 04, 2020 11:52 pm
Forum: FiveWin para Harbour/xHarbour
Topic: consultar 2 tablas
Replies: 3
Views: 558

Re: consultar 2 tablas

Pude hacerlo:

select descrip, cantidad, codigo from remito union select descrip, cantidad, codigo from compras

Saludos.
Gracias