Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi John,
Sorry about the caps. Just using a PC.
I can't seem to use any of vfp functions in the example. ie. DATE(),TTOD() etc.
Please explain or tell me what can be used in the example field.
Heres what I would like to use because birthdate is a DATETIME field:
TTOD(dbf.birthdate) = DATE(); but that does not seem to work.
Thanks in Advance!
Roland
=================================================================
>First off, Roland, kill the Caps....you're not using an Apple ][+ I suspect. :-)
>
>The way to pass dates to SQL Server is as a string delimited by quotes. For example:
>
>birthdate = '01/01/2001'
>
>Try setting a property or var to the strong date and making the view birthdate = ?myobject.myproperty
>
>
>
>>I AM TRYING TO CREATE A REMOTE VIEW USING VIEW DESIGNER. FILTER BY BIRTHDATE = EXAMPLE. I DON'T KNOW HOW TO EXPRESS THE EXAMPLE AS TODAY'S DATE. I HAVE TRIED BIRTHDATE = CURDATE(); BIRTHDATE = DATE(); DOES NOT WORK. THE BIRTHDATE IS AN SQL DATETIME FIELD.
>>
>>THANKS IN ADVANCE!
>>ROLAND
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