Page 1 of 1

input parameter count is less then expected

Posted: 22.05.2007, 20:34
by alexandrecsouza
I always used the resource of the DataSource of the Zeos without problem, now is giving this error in one of my Form, “input to parameter count is less then expected” follows mine query´s :

Master :

select a.*, EMP_NOME, GAR_NOME, TCA_NOME, TCH_NOME, TMO_NOME, LIN_NOME, FAB_NOME, TVE_NOME, TOR_NOME from VEICULOS a
left outer join EMPRESA on EMP_CODIGO = VEI_EMPRESA
left outer join GARAGEM on GAR_CODIGO = VEI_GARAGEM
left outer join FABRICANTES on FAB_CODIGO = VEI_FABRICANTE
left outer join TP_VEICULO on TVE_CODIGO = VEI_TIPO
left outer join TP_ORGAOS on TOR_CODIGO = VEI_ORGAO
left outer join TP_CARROCERIA on TCA_CODIGO = VEI_TP_CARROCERIA
left outer join TP_CHASSI on TCH_CODIGO = VEI_TP_CHASSI
left outer join TP_MOTOR on TMO_CODIGO = VEI_TP_MOTOR
left outer join LINHAS on LIN_CODIGO = VEI_LINHA
where VEI_PLACA = :placa

Detail :

select * from VEICULOS_PROGRAMACAO
where VPR_PLACA = :vei_placa
order by vpr_vigencia_final desc

I place in the DataSource Property of the Quey I will detail the DataSource of the Master, when I give the Open in the Detail of the this error: Somebody knows to inform the reason ?

Posted: 28.05.2007, 11:23
by cipto_kh
Do you already set the value for param :placa in master table before open the detail? Are you also sure that the master field already have "vei_placa" field?