In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.

Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.

two tables in one browse

Foro público de Xailer en español
Responder
Aguiar Costa
Mensajes: 115
Registrado: Jue Jun 01, 2006 7:21 pm

two tables in one browse

Mensaje por Aguiar Costa »

Hello !!!
If i have a browse with a table that have for example, a client code, and i
want to show in the same browse the client name that is in the client table,
how do i do that using whatever browse with or without Datasets?
2 tables in 1 browse.
TIA.
Regards
Aguiar !!!
Avatar de Usuario
ignacio
Site Admin
Mensajes: 9445
Registrado: Lun Abr 06, 2015 8:00 pm
Ubicación: Madrid, Spain
Contactar:

two tables in one browse

Mensaje por ignacio »

Aguiar,
1) Make the table with only the client code the main table for the browse:
oDbfBrowse:SetDbf( "Table")
2) Make a relation between the two tables
3) Add a new column to the browse, indicating the following properties:
oCol:cHeader := "Client Name"
oCol:OnGetData := {|oSender, Value, nImage| Value := Client->Name }
Regards,
"Aguiar Costa" <Aguiar.Costa@Sisbit.pt> escribió en el mensaje
news:[email=442a4ef7@ozsrvnegro.ozlan.local...]442a4ef7@ozsrvnegro.ozlan.local...[/email]
> Hello !!!
>
> If i have a browse with a table that have for example, a client code, and
> i want to show in the same browse the client name that is in the client
> table, how do i do that using whatever browse with or without Datasets?
> 2 tables in 1 browse.
> TIA.
> Regards
> Aguiar !!!
>
Ignacio Ortiz de Zúñiga
[OZ Software]
https://www.ozs.es
--
[Equipo de Xailer / Xailer team]
https://www.xailer.com
Aguiar Costa
Mensajes: 115
Registrado: Jue Jun 01, 2006 7:21 pm

two tables in one browse

Mensaje por Aguiar Costa »

Ignacio,
Thank you.
Regards
Aguiar !!!
"Ignacio Ortiz de Zúñiga" <NoName@xailer.com> escreveu na mensagem
news:442a5c58$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
> Aguiar,
>
> 1) Make the table with only the client code the main table for the browse:
>
> oDbfBrowse:SetDbf( "Table")
>
> 2) Make a relation between the two tables
>
> 3) Add a new column to the browse, indicating the following properties:
>
> oCol:cHeader := "Client Name"
> oCol:OnGetData := {|oSender, Value, nImage| Value := Client->Name }
>
> Regards,
>
> "Aguiar Costa" <Aguiar.Costa@Sisbit.pt> escribió en el mensaje
> news:[email=442a4ef7@ozsrvnegro.ozlan.local...]442a4ef7@ozsrvnegro.ozlan.local...[/email]
>> Hello !!!
>>
>> If i have a browse with a table that have for example, a client code, and
>> i want to show in the same browse the client name that is in the client
>> table, how do i do that using whatever browse with or without Datasets?
>> 2 tables in 1 browse.
>> TIA.
>> Regards
>> Aguiar !!!
>>
>
>
Responder