Re: forms / trigger question

[Quoted] It's been suggested that I use the pre-query trigger instead of the key-exeqry trigger. So I tried to do something like this:

select * from bill_material_hours
  where bmh_so_# = :block1.bmm_so_#
  and bmh_so_item_# = :block1.bmm_so_item_#   and bmh_so_chg_# = :block1.bmm_so_chg_#;

I'm trying to work this select statement into block5. The selected rows therefore depend on data that was entered in block1. Unfortunately, I can't compile the select statement! It's expecting the keywork INTO after the *. This is a V3 trigger. Why won't it work without INTO?

Thanks,
Martin Meadows Received on Mon Apr 06 1998 - 00:00:00 CEST