Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>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 ...
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement