Estou com uma duvida, não sei se é possivel.

Tenho uma tabela de clientes (16.000 registros com 125 campos, demora uns 3 segundos para buscar). Os meus clientes tem costume de abrir esta tabela pela manha  por default com um FillAll onde eles trazes todos os registros e navegam nos registros o dia todo. Oque acontece que esses registros estao em memoria (BO) e nao refletem mais oque existe no banco.

Existe algum metodo ou propriedade, ou alguma funcao em que eu possa atualizar apenas o registro corrente, sem tem der fazer novamente um FillAll e trazer todos os dados?

I have a doubt, do not know if it's possible.

I have a customer table (16,000 records with 125 fields, it takes about 3 seconds to get). My clients have a way to open this table in the morning by default with a FillAll where they bring all records and navigating the records all day. What happens to those records are in memory (BO) and do not reflect more WHAT exists in the database.

Is there any method or property, or some function where I can update only the current record, without having to give a FillAll again and bring all the facts?

There are lots and lots of potential ways to handle this, but all of them essentially are based on simply providing the means for the user to select what record or records they want to work with, get just those records, then they close out or start over by picking new records.



One way is to use the BrowseDialog and when you open the form, don't load any records. The user will have to select the records to work with via the BrowseDialog. I think the best place to start is to see the help file and StrataFlix sample app for more details. As you start working through this you can ask more detailed questions and we can help you out.

Hey Malcon!

Glad to see you back here.