>>I have a remote view with a datetime field that I would like to change to a simple date field before the user gets a hold of it. The problem I'm running into is that I have used an alias name in the data environment and the DBSETPROP(alias.fieldname, "FIELD","DATATYPE","D") is ignored (even though it returns .T.). Does anybody know how to reference the fieldname properly?
>>
>>Thanks
>
>You can get the name of the underlying view first like:
>
>lcViewName = CURSORGETPROP("SourceName","Alias")
>
>DBSETPROP(lcViewName + "Yourfieldhere", "FIELD","DATATYPE","D")

Thanks Eric, that did the trick. Funny, I thought I had tried using the view name before -- I must be losing it.

Looking forward to her week at the beach ...