Thanks, Ignacio. I've created a function I named ClearControls, which scopes
the datasets with a non-existent string, effectively clearing out the linked
data controls. I have another function, ResetControls, that scopes them
again using valid parameters, effectively refreshing the linked controls
with data. This is working very well.
I have to say I like Xailer very much. With a little work and your help, I
seem to be able to get past every obstacle!
Gary
"Ignacio Ortiz de Zúñiga" <
NoNameToAvoidSpam@xailer.com> wrote in message
news:4ab21279$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Gary,
>
>
> Gary,
>
> On AddNew() methods the physicall append is not done yet, BTW you can do
> the append your self and do an Edit() instead.
>
> I suggest you use a string variable instead of a field value for the scope
> and change that string to whatever non existing value when caling to
> AddNew().
>
> Regards,
>
>
> --
> Ignacio Ortiz de Zúñiga
> Xailer support / Soporte de Xailer
>
http://www.xailer.com
>
http://www.xailer.info
> "Gary S. Rogers" <
g.s.rogers@att.net> escribió en el mensaje
> news:[email=4ab0ff94@svctag-j7w3v3j....]4ab0ff94@svctag-j7w3v3j....[/email]
>>I appreciate the information, but I probably wasn't clear in my question.
>>
>> I have a form that has datacontrols for one dataset (the main table) and
>> shows several DBBrowse controls for related child records. Although it is
>> not an accounting form, it would be similar to a form that showed the
>> master record for an invoice and several browse controls for invoice
>> detail items.
>>
>> I can successfully establish a scope for the child datasets in the
>> OnCreate event of those child datasets. I tried simply relating the child
>> datasets to the parent dataset in the OnCreate event of the child
>> dataset, but the DBBrowse controls did not display properly -- that is,
>> they showed all records in the child dataset, not just those that matched
>> the SetRelation() parameters. I could not use the debugger to verify that
>> the SetRelation() was in effect. So, I went back to scoping the child
>> datasets, which works for me except for one thing. When I perform an
>> AddNew() for a new master record, I would like the other child controls
>> on the form to clear. Instead, they show the information for the last
>> displayed master record (of course).
>>
>> In my Clipper app, I was used to setting relationships between tables.
>> With a relationship set, I could be assured that if the master record
>> changed to eof()+1 (for adding a new record), then there would be no
>> related child records and the user interface would reflect that -- all
>> the child browses would show no records. I'm trying to get the same
>> effect in Xailer, but don't know quite how to go about doing it.
>>
>> I guess on an AddNew() of a master record, I could re-scope the child
>> controls on the form with some non-existent value and repaint them. Would
>> that be a good way?
>> TIA,
>> Gary
>>
>>
>> "Ignacio Ortiz de Zúñiga" <
NoAccount@xailer.com> wrote in message
>> news:[email=4ab09d91@svctag-j7w3v3j....]4ab09d91@svctag-j7w3v3j....[/email]
>>> Gary,
>>>
>>> You can include a reference to another dataset using the event
>>> TBrwColumn:OnGetData.
>>>
>>> Regards,
>>>
>>> --
>>> Ignacio Ortiz de Zúñiga
>>> Xailer team
>>>
http://www.xailer.com
>>>
http://www.xailer.info
>>>
>>> "Gary S. Rogers" <
g.s.rogers@att.net> escribió en el mensaje
>>> news:[email=4aafc7c8@svctag-j7w3v3j....]4aafc7c8@svctag-j7w3v3j....[/email]
>>>> Does DBBrowse reflect relationships set between the underlying dataset
>>>> and another dataset, or does one have to always scope the underlying
>>>> dataset in the OnChange event of the DBBrowse object?
>>>> TIA,
>>>> Gary
>>>
>>>
>>
>
>