Mensaje
De
23/03/2010 14:01:56
a
23/03/2010 13:58:18
General information
Foro:
Visual FoxPro
Category:
Bases de datos, tablas, vistas, índices y SQL
Título:
Miscellaneous
ID de la conversación:
01456639
ID del mensaje:
01456682
Views:
27
>>>>>Try first
>>>>>
>>>>
>>>>
>>>>i changed the months seemd to fix it
>>>
>>>You didn't need to change months if you wanted the whole year. Look closer at the solution presented.
>>
>>yea but im not going to hard code the year. so the yea can only be one value which is the value it gets from the spinner
>
>LOL.
why u laughed!!! tell me :(
>>>>>
>>>>>select * from myTable where datefield >=date(2002,1,1) and datefiled < (2003,1,1) >>>>>>>>>>Does it bring you records? If not, in means all records are deleted or don't exists for the year 2002.
>>>>
>>>>
>>>>i changed the months seemd to fix it
>>>
>>>You didn't need to change months if you wanted the whole year. Look closer at the solution presented.
>>
>>yea but im not going to hard code the year. so the yea can only be one value which is the value it gets from the spinner
>
>LOL.
why u laughed!!! tell me :(