>Hi Alistair
> I think we can't set view back to its defaults at runtime, as I am mapping the
>view fields in Database using DBSETPROP(). Any other way to handle this situation is
>most welcome.
>
>Hi Tom
> I did't got u r idea of creating sql on the fly, and this view which I am creating is
>updateable at backend, I will be thankfull if u express u r idea more clearly.
Waheed
A view is just an updateable SQL cursor right? So in SQL you can create a 'field' like for sum() and other stuff. Why not create your TimeDate the same way. This will leave your Time field intact. Am I on the same Wave length?
HTH,
Tom