Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select statement
Message
From
05/10/2005 05:14:52
 
 
To
05/10/2005 04:25:56
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01056147
Message ID:
01056161
Views:
37
What type is Dat field?

>hi,
>thank you,
>the type is date ,but i get it at my text via calender,
>Yes,dat field at my table.
>
>thisform.text1.value= CMONTH(This.object.value)+' '+Str(year(This.object.value))
>&&thisform.olecontrol1.Visible=.f.
>
>>Mohhamed,
>>What type are m.dat1, m.dat2 AND dat. I hope Dat is Field from table
>>
>>
>>>hi all,
>>>any idea ,help.
>>> to fix this code under,
>>> I want to see only what I choice between to dates but I see all months,
>>> thanks.
>>>
>>>
>>>
>>>SET CENTURY on
>>>SET DATE TO british
>>>SELECT divi
>>>m.nam=nam
>>>m.dat1=thisform.text1.Value  && result is january   2005
>>>m.dat2=thisform.text2.Value  && result is feb...2005 or any month i choice
>>>SELECT table1 && error message table1 not found, I need to use it to make index
>>>INDEX ON dat TO kk
>>>
>>> SELECT * from table1 WHERE   (dat between m.dat1 AND m.dat2) AND dvno=VAL(this.Value) and peri=thisform.combo2.value ;
>>>     into CURSOR xyz
>>>IF _TALLY > 0
>>>             report form newtable1 preview
>>>  ELSE
>>>        =MESSAGEBOX("Still No Product")
>>>
>>>Endif
>>>
>>>m.qasem
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform