>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")
Erik Moore
Clientelligence