>That's kind of weird. What's the SQL statement for the view?
CREATE SQL VIEW "LV_VACCINEBRAND" ;
AS ;
SELECT ;
Imc_bran.iid, ;
Imc_bran.imanufacturervaccineid, ;
Imc_bran.cname, ;
Imc_bran.dAvailable, ;
Imc_bran.iminage, ;
Imc_bran.imaxage, ;
Imc_bran.imaxdose, ;
Imc_bran.imindose, ;
Imc_mava.imanufacturerid, ;
Imc_mava.ivaccineid, ;
Imc_manu.cname AS cmanufacturername ;
FROM ;
impact!imc_mava ;
INNER JOIN impact!imc_bran ;
INNER JOIN impact!imc_manu ;
ON Imc_manu.iid = Imc_mava.imanufacturerid ;
ON Imc_mava.iid = Imc_bran.imanufacturervaccineid ;
WHERE ;
Imc_Bran.iManufacturerVaccineid = ?vp_iManufacturerVaccineId
This code, when run the first time, says it cannot find iManufacturerId, but if I run it again it runs correctly.
Thanks
Rex
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only