PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV, WEBDEV e WINDEV Mobile

Inicio | Mensagens recentes | Conecte-se... |  | Português FR
Inicio → WEBDEV 2024 → Related table not populating
Related table not populating
Iniciado por James, jun., 17 2011 3:12 PM - 2 respostas
#1
Membro registado
11 mensagems
Publicado em junho, 17 2011 - 3:12 PM
I have this query below for a table on a Company Page. It is suppose to populate with a list of related contacts but the table remains empty.

I have verified the query returns a result in a test but fails on the page. I think the table is not loading records because it cannot link to the parameter. I have checked and the parameter pCompanyID has a value.

PROCEDURE PAGE_Company_Home (pCompanyID is int,gsCompanyName is string)

Apart from having the query reference the param is there another step to having the data load into the table?

I was surprised I couldn't find any master & child examples included in the example sites.

Thx. James


QUERY:

SELECT
Contact.FirstName AS FirstName,
Contact.LastName AS LastName,
Contact.Mobile AS Mobile,
Contact.Email AS Email,
Contact_Company.ContactPosition AS ContactPosition,
Contact_Company.ContactID AS ContactID_Co,
Contact_Company.CompanyID AS CompanyID
FROM
Contact,
Contact_Company
WHERE
Contact_Company.ContactID = Contact.ContactID
AND
(
Contact_Company.CompanyID = {pCompanyID}
)
#2
Publicado em junho, 22 2011 - 12:32 PM
You could fill the table by programming with TableAddLine.
#3
Membro registado
11 mensagems
Publicado em julho, 04 2011 - 3:21 PM
As it turns out it was user error. I did not modify the code of the table, I was modifying the code of the page.
→ Voltar para WEBDEV 2024