In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.

Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.

DBBrowse question

Xailer professional forum in English
Responder
g.s.rogers
Mensajes: 202
Registrado: Dom Feb 17, 2008 3:35 am

DBBrowse question

Mensaje por g.s.rogers »

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
NoAccount
Mensajes: 35
Registrado: Mié Sep 16, 2009 10:09 am

DBBrowse question

Mensaje por NoAccount »

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
NoAccount
Mensajes: 35
Registrado: Mié Sep 16, 2009 10:09 am

DBBrowse question

Mensaje por NoAccount »

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
g.s.rogers
Mensajes: 202
Registrado: Dom Feb 17, 2008 3:35 am

DBBrowse question

Mensaje por g.s.rogers »

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
>
>
g.s.rogers
Mensajes: 202
Registrado: Dom Feb 17, 2008 3:35 am

DBBrowse question

Mensaje por g.s.rogers »

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
>
>
Avatar de Usuario
ignacio
Site Admin
Mensajes: 9441
Registrado: Lun Abr 06, 2015 8:00 pm
Ubicación: Madrid, Spain
Contactar:

DBBrowse question

Mensaje por ignacio »

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
>>
>>
>
Ignacio Ortiz de Zúñiga
[OZ Software]
https://www.ozs.es
--
[Equipo de Xailer / Xailer team]
https://www.xailer.com
Avatar de Usuario
ignacio
Site Admin
Mensajes: 9441
Registrado: Lun Abr 06, 2015 8:00 pm
Ubicación: Madrid, Spain
Contactar:

DBBrowse question

Mensaje por ignacio »

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
>>
>>
>
Ignacio Ortiz de Zúñiga
[OZ Software]
https://www.ozs.es
--
[Equipo de Xailer / Xailer team]
https://www.xailer.com
g.s.rogers
Mensajes: 202
Registrado: Dom Feb 17, 2008 3:35 am

DBBrowse question

Mensaje por g.s.rogers »

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
>>>
>>>
>>
>
>
g.s.rogers
Mensajes: 202
Registrado: Dom Feb 17, 2008 3:35 am

DBBrowse question

Mensaje por g.s.rogers »

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
>>>
>>>
>>
>
>
Responder