Duane,
El 05/08/2004 5:29 PM, Duane Lee - EGOVX en su mensaje escribio:
What table is lnpedpk in - ped_cam? What table is ped_pk in - ped_pro and ped_cam?
lnPedPk is parameter pased to the function and it could be a fixed value on the sql console too, ped_pk is common in both tables, I changed the code to this and still get the same error
INSERT INTO ped_cam
(SELECT * from ped_pro where ped_pro.ped_pk=81178)
WHERE NOT EXISTS
(SELECT 1 FROM ped_cam WHERE ped_cam.ped_pk=81178);Thanks,
--
Sinceramente,
Josué Maldonado.
"Deja que los perros ladren, Sancho, es señal que caminamos." -- Miguel de Cervantes Saavedra.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
