Página 1 de 1

DBF/NTX Problem

Publicado: Jue Sep 17, 2009 9:58 pm
por g.s.rogers
When I append a new record to a dataset with AddNew() and Update(), the
index files do not appear to be updated. I have the dataset scoped at the
time I am adding a new record and the new record does not appear in the
linked DBBrowse table until I reindex the .dbf file. I have checked the IDX
property of the dataset and I have all three indices listed there as
follows:
CAPLAINT
CAPLNAME
CAPLIDNM
These indices are .NTX files and are in the same directory as the datasource
for the dataset. I have a form to reindex files and the dataset I have in
that form lists the indices the exact same way. Once I run that routine, the
appropriate records show up in my app's dbbrowse controls. I have no idea
why the indices are not getting updated properly when the new record is
added.
Thanks for your help.
Gary

DBF/NTX Problem

Publicado: Vie Sep 18, 2009 9:49 am
por ignacio
Gary,
Try to make a Refresh( .T. ) on the child TBrowse.
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=4ab29500@svctag-j7w3v3j....]4ab29500@svctag-j7w3v3j....[/email]
> When I append a new record to a dataset with AddNew() and Update(), the
> index files do not appear to be updated. I have the dataset scoped at the
> time I am adding a new record and the new record does not appear in the
> linked DBBrowse table until I reindex the .dbf file. I have checked the
> IDX property of the dataset and I have all three indices listed there as
> follows:
>
> CAPLAINT
> CAPLNAME
> CAPLIDNM
>
> These indices are .NTX files and are in the same directory as the
> datasource for the dataset. I have a form to reindex files and the dataset
> I have in that form lists the indices the exact same way. Once I run that
> routine, the appropriate records show up in my app's dbbrowse controls. I
> have no idea why the indices are not getting updated properly when the new
> record is added.
>
> Thanks for your help.
> Gary
>

DBF/NTX Problem

Publicado: Vie Sep 18, 2009 9:49 am
por ignacio
Gary,
Try to make a Refresh( .T. ) on the child TBrowse.
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=4ab29500@svctag-j7w3v3j....]4ab29500@svctag-j7w3v3j....[/email]
> When I append a new record to a dataset with AddNew() and Update(), the
> index files do not appear to be updated. I have the dataset scoped at the
> time I am adding a new record and the new record does not appear in the
> linked DBBrowse table until I reindex the .dbf file. I have checked the
> IDX property of the dataset and I have all three indices listed there as
> follows:
>
> CAPLAINT
> CAPLNAME
> CAPLIDNM
>
> These indices are .NTX files and are in the same directory as the
> datasource for the dataset. I have a form to reindex files and the dataset
> I have in that form lists the indices the exact same way. Once I run that
> routine, the appropriate records show up in my app's dbbrowse controls. I
> have no idea why the indices are not getting updated properly when the new
> record is added.
>
> Thanks for your help.
> Gary
>