AAA

check lại hàm với a dân

select count(*) into b_i1 from bh_dtac_ma where ma=b_ma;
if b_i1 > 0 then
select * into r_hd from bh_dtac_ma where ma=b_ma;
if b_ng_sinh=0 then b_ng_sinh:=r_hd.ng_sinh; end if;
if b_gioi=' ' then b_gioi:=r_hd.gioi; end if;
if b_cmt=' ' then b_cmt:=r_hd.cmt; end if;
if b_dchi=' ' then b_dchi:=r_hd.dchi; end if;
if b_mobi=' ' then b_mobi:=r_hd.mobi; end if;
if b_email=' ' then b_email:=r_hd.email; end if;
if b_nghe=' ' then b_nghe:=r_hd.nghe; end if;
if b_c_thue=' ' then b_c_thue:=r_hd.c_thue; end if;
if b_nhang=' ' then b_nhang:=r_hd.nhang; end if;
if b_ma_tk=' ' then b_ma_tk:=r_hd.ma_tk; end if;
if b_kvuc=' ' then b_kvuc:=r_hd.kvuc; end if;
if b_ma_ct=' ' then b_ma_ct:=r_hd.ma_ct; end if;
if b_ngay_kt=0 then b_ngay_kt:=r_hd.ngay_kt; end if;
end if;
select txt into b_txt from bh_dtac_ma_txt where ma=b_ma;