input parameter count is less then expected

Forum related to version 6.5.1 (alpha) and 6.6.x (beta) of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
alexandrecsouza
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 25.08.2005, 15:13

input parameter count is less then expected

Post 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 ?
User avatar
cipto_kh
Senior Boarder
Senior Boarder
Posts: 83
Joined: 28.09.2005, 11:22
Location: Indonesia
Contact:

Post 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?
Post Reply