||Re: Master/Child Tables
Mervyn Bick <firstname.lastname@example.org>
||Thu, 8 Feb 2018 12:44:25 +0200
On 2018-02-08 11:05 AM, WJS wrote:
> On 2018/02/07 11:55 AM, Mervyn Bick wrote:
>> this.S1 = new QUERY(this)
>> with (this.S1)
>> left = 11.0
>> width = 3.0
>> height = 1.0
>> sql = 'select s.* from s s where s.reg = :rno union select t.*
>> from t t where t.reg = :rno order by data '
>> params["rno"] = "" //***
>> masterSource = form.r1.rowset
>> active = true
> In the above query you use params["rno"] = "" (I marked it with //***)
> I still use dBase 2.6.2 and that is not required when using masterSource.
> i know you are using dBase 11, so my question is, is this a new
> requirement for the new dBase ?
It is not necessary.
As long as the mastersource rowset is assigned one can add the 'where
fieldname = :parameter' in the sourcecode editor and the form will run
as expected. The params entry is not required.
If one adds the parameter in the select statement without assigning the
mastersource the form gives an error. If the params entry is there
there won't be an error but the child records will not be selected if
the mastersource is not set.
If the form is altered in any way in the designer the designer will
stream out the line even though dBASE doesn't need it in the constructor
code to work properly.
It looks as if this line is generated automatically in memory if it
isn't in the constructor code. Because it's there the designer then
streams it out with the rest of the code.