Re: [?]Fourgen:form:update:....
If you delete a header then the details must be deleted as well.
It's normal referential constraint logic.
If you delete just one of details FourGen logic is
-delete all details (call lld_delete())
-insert actual details from the array (see ring_llupdate() in
$fg/scr.RDS/r_llupdate.4gl)
Regards,
---------------------------------------------------------------
Vadim G. Park | Email: pivot@taxpol.krasnoyarsk.su
Tax Police | Fax : (3912) 27-07-69
Krasnoyarsk, Russia | Voice: (3912) 27-02-83
---------------------------------------------------------------
>Greetings Net.Wisdom,
>
>I am attempting to understand the 4gl that Fourgen generates in regard
>to line item deletes in the detail section of a header-detail screen
>when in the "update" option.
>
>Specifically I am looking at lld_delete() (detail.4gl) and the sql
>statement:
> delete from det_table where join_fld = m_rec.join_fld>
>What vexes me is that when I run this statement in dbaccess (replacing
>m_rec.join_fld with an actual value) this deletes all the rows meeting
>this criteria; however, Fourgen 4gl manages to delete just the row that
>was F2'd (line-item deleted).
>
>Can someone please explain to me what I am failing to see and
>understand? How is it that Fourgen is able to use the same function for
>line-item deletes and record-deletes ("delete" from the ring menu)?
>
>Much thanks!
>
>-Todd
>Willamette Industries, Inc.
>
>--
>Richard Shannon
>cpilot@teleport.COM
>Todd Bernhardt
>cpilot@teleport.COM