>Thats another question... views.
>Just in terms of speed talking, I notice that the table (as in any SELECT command in VFP) opens the "Master" table itself, so... whats the benefict in terms of speed ?

With a paramerized view, you only "see" the data you want. This is usually much faster than filtering a table.

You can use an index with SET KEY, but this doesn't make it easy to sort the result with a temp index. A view can be indexed, to see the data in any order.

Hilmar.

>(in opposite to the table it self and good indexs ?)
>
>Thanks
>(and sorry for my "novice" skills)
>(and my poor English :-D )
>
>>In addition to what Hilmar told you, use Views.
>>
>>
>>>Hi
>>>
>>>I'm trying to define the best aproach on a LAN based aplication...
>>>My question is:
>>>should a I open my tables and never close then (to speed up data operations) or in the other end, should I open tables just when I need them, since as I understand, Foxpro tables are fragile and could get damaged in a LAN failure.
>>>
>>>I know I should use SQL Server as the best way of doing this, but I'm no expert and dont have that much time to get the proper training and do a SQL Server application.
>>>
>>>(any sugestions, samples and so on would be great)
>>>
>>>TIA