Radicore Forum: How To » How to make a list2 on a non existing child table

Home » RADICORE » How To » How to make a list2 on a non existing child table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: How to make a list2 on a non existing child table [message #1907 is a reply to message #1906]

Tue, 09 December 2008 08:11

bonzo_bcn
Messages: 152
Registered: June 2008

Senior Member

Ok, the problem is that my sql_from is like this:

(SELECT entidad.entidad_id ,'Esportistes' as concepto, 1 as importe
		FROM participante 
		JOIN part_equipo_xref  ON participante.participante_id=part_equipo_xref.participante_id
		JOIN equipo  ON part_equipo_xref.equipo_id = equipo.equipo_id
		JOIN entidad  ON equipo.entidad_id= entidad.entidad_id
		JOIN temporada  ON temporada.temporada_id = equipo.temporada_id
		WHERE tippart='E'
		SELECT entidad.entidad_id ,'Equips' ,  1
		FROM participante 
		JOIN equipo  ON participante.participante_id = equipo.delegado_id
		JOIN entidad  ON equipo.entidad_id= entidad.entidad_id
		JOIN temporada  ON temporada.temporada_id = equipo.temporada_id
		UNION ALL
		SELECT entidad.entidad_id ,'Entitat',   1
		FROM entidad) as entidad_s02

so the function extractTableNames returns an incorrect value:'SELECT'
and then qualifyField turns $where to null.

Do you know how can I solve this?

Report message to a moderator

[Message index]

		How to make a list2 on a non existing child table By: bonzo_bcn on Tue, 09 December 2008 06:59
		Re: How to make a list2 on a non existing child table By: AJM on Tue, 09 December 2008 07:45
		Re: How to make a list2 on a non existing child table By: bonzo_bcn on Tue, 09 December 2008 08:11
		Re: How to make a list2 on a non existing child table By: AJM on Tue, 09 December 2008 08:15
		Re: How to make a list2 on a non existing child table By: bonzo_bcn on Tue, 09 December 2008 08:35
		Re: How to make a list2 on a non existing child table By: AJM on Tue, 09 December 2008 09:12
		Re: How to make a list2 on a non existing child table By: bonzo_bcn on Tue, 09 December 2008 10:15
		Re: How to make a list2 on a non existing child table By: AJM on Tue, 09 December 2008 10:43
		Re: How to make a list2 on a non existing child table By: bonzo_bcn on Tue, 09 December 2008 10:50
		Re: How to make a list2 on a non existing child table By: AJM on Tue, 09 December 2008 11:31
		Re: How to make a list2 on a non existing child table By: bonzo_bcn on Tue, 09 December 2008 11:37
		Re: How to make a list2 on a non existing child table By: AJM on Tue, 09 December 2008 11:52
		Re: How to make a list2 on a non existing child table By: bonzo_bcn on Tue, 09 December 2008 11:59
		Re: How to make a list2 on a non existing child table By: AJM on Tue, 09 December 2008 12:39
		Re: How to make a list2 on a non existing child table By: bonzo_bcn on Tue, 09 December 2008 15:32
		Re: How to make a list2 on a non existing child table By: AJM on Tue, 09 December 2008 19:39
		Re: How to make a list2 on a non existing child table By: bonzo_bcn on Wed, 10 December 2008 04:11
		Re: How to make a list2 on a non existing child table By: AJM on Wed, 10 December 2008 04:58

Previous Topic:	Dynamic Report Column Headings
Next Topic:	get calculated field from parent table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Jul 27 21:26:14 EDT 2024

Total time taken to generate the page: 0.01129 seconds