>A view is just like a cursor in this sense. Data selection should be as fast as the corresponding cursor.
>
>Usually you would use a parameterized query for selecting a small subset of a large table. For instance, "Client = ?vClient". Note the question mark - it is customary - and legal - to include a question mark here. This indicates to VFP that, if the variable doesn't exist, the user will be shown a dialog (but you want to avoid this at all costs). Some frameworks parse for the question mark, so I recommend to include it. As a matter of fact, I never tried to define a parameterized view without it.
>
>The view will simply simplify some programming aspects. Specifically, VFP takes over more of your work. You issue TableUpdate(), and VFP takes care of finding the records to update (or creating new records) in the original table.
>
>HTH, Hilmar.

What about record locking? In the approach I'm actually using don't have to worry too much about it since I only begin the transaction before start updating the table, so the records are locked for a really short time.

Please don't think my questions are stupid or something, I know I can read about views on the VFP help and many of my doubts will be answered but I always prefer having real world answers.

Thanks a lot,

Enmanuel