>>>However, I have found that by using views to access the data I need from J:\DBFS\CLIENTS.DBF was faster that using SELECT * FROM CLIENTS...
>>>
>>
>>I don't know too much about NT or C/S, but I can give you a tip about SQL:
>>If you specify all the fields you want selected from the table (even if it's all fields) it will be much faster than '*'. It has always been like that...
>>
>>Alex.
>
>Yup. Another reason for that would be if you add some fields on the Server side that you don't want reflected on the client side. Using * gives you everything, and thus you would need to change your app. (Learned that one the hard way!)
I thought so! That's why you look so tanned in the picture! :-)
>
>Scot.
I was just talking about speed, but that's true too (unless you do want the changes on the server to reflect on the client's side :-) ).
Alex.
Alexandre Nobre
Alpha Bytes Computer Corp.
Did you know that there are innocent people dying in East Timor?
It helps if you do...
I suppose you don't need glasses if you're able to read this line