Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
nope,
is SQL server view
>You are creating a VFP view, rather than a SQL Server view? If so, you can set the property of the field in the VFP view to change the field from a datetime to a date. I forget the exact syntax, but it's something like:
>
>DBSETPROP(FieldNameHere, "FIELD", "Type", "D")
>
>>no,
>>a DATETIME field to a DATE.
>>In other workds I want to use a TTOD() function in SQL server.
>>
>>The reason I want to do this is because I'm creating a SQL view, so that when I get all the fields in my cursor I just slap it into the grid.
>>Otherwise, it will be easy to do it in Fox, but I have too many fields to do a SELECT on that.
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