I have created the following view which( by nature of the query) always starts empty, to which I add records.
CREATE SQL VIEW lv_leg_pack_mass as SELECT ;
causes.*,;
referrals.refnumber,;
referrals.ref_key as ref_ref_key,;
referrals.juv_key as ref_juv_key,;
referrals.cau_key as ref_cau_key,;
court_acts.ref_key as court_ref,;
court_acts.cau_key as court_cause,;
court_acts.act_type_key,;
court_acts.doc_code,;
court_acts.doc_date,;
act_types.act_trans, ;
act_types.act_type, ;
juveniles.jcn,;
atty_types.atty_trans,;
dpas.prosecutor,;
dpas.dpa_key as dpas_dpa_key,;
dpas.dpa_code ,;
alltrim(juveniles.lastname)+;
','+alltrim(juveniles.firstname) as fullname ;
FROM jjnew!causes ;
INNER JOIN jjnew!referrals on ;
referrals.cau_key==causes.cau_key ;
INNER JOIN jjnew!juveniles on;
referrals.juv_key==juveniles.juv_key ;
LEFT OUTER JOIN jjnew!court_acts on;
court_acts.cau_key==causes.cau_key ;
LEFT OUTER JOIN jjnew!act_types on;
act_types.act_type_key==court_acts.act_type_key ;
LEFT OUTER JOIN jjnew!atty_types on ;
atty_types.atty_type==referrals.atty_type ;
LEFT OUTER JOIN jjnew!dpas on causes.dpa_key==dpas.dpa_key ;
WHERE .f.
I open the view with an alias of v_leg_pack_mass and add records.
After adding the records if I select v_leg_pack_mass.* from v_leg_pack_mass the resulting query contains 0 records, no matter how many records I've added to the v_leg_pack_mass view. I've done this with other views and not had this problem.
Is this a known bug? Is this supposed to work this way? Anyone know what is going on?
Thanks in advance for the help
Thanks
Gar W. Lipow