Message
From
23/03/2010 13:37:52
To
23/03/2010 13:35:58
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01456639
Message ID:
01456665
Views:
31
>>>
>>>lol forgive my lazy internet lingo i meant to work. you're using the year 2000 i really didnt wanna hard code a year
>>
>>Alternative solution would be
>>
>>year(date) = thisform.Spinner1.value
>>
>>this solution is worse if you have an index on date field. Otherwise it doesn't matter and shorter to use.
>
>
>would i hav to write it like (1,1,year) if im using the british date in my tableS?
date function accepts year, month, day parameters. Check Help.
>>>lol forgive my lazy internet lingo i meant to work. you're using the year 2000 i really didnt wanna hard code a year
>>
>>Alternative solution would be
>>
>>year(date) = thisform.Spinner1.value
>>
>>this solution is worse if you have an index on date field. Otherwise it doesn't matter and shorter to use.
>
>
>would i hav to write it like (1,1,year) if im using the british date in my tableS?
date function accepts year, month, day parameters. Check Help.