Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
THISFORM can only be used within a method
Message
From
17/01/2007 06:14:25
 
 
To
16/01/2007 15:04:24
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01185055
Message ID:
01186180
Views:
21
>>Thanks for all the input on this one, guys. Sorry I haven't got back sooner but the UT's been out of order for me this PM. The filter code appears in a few places on the form and I've got round the problem sort of in this way:
>>
>>
>>lcFilter	= "OPERATOR = " + ALLTRIM( this.Value) + " and " + ;
>>	  "END_DATE >= CTOD('" + DTOC( thisform.dStartDate) + "') or EMPTY( END_DATE)"
>>
>
>What's type of operator? If it's a number and This is a combo, then just remove the alltrim and replace it with a transform(). If operator is a string, you'd need
>
>
>lcFilter	= "OPERATOR = [" + ALLTRIM( this.Value) + "] and " + ;
>	  "END_DATE >= CTOD('" + DTOC( thisform.dStartDate) + "') or EMPTY( END_DATE)"
>
Like I said, it keeps flip-flopping from char to num. I make a change accordingly then next time it decides it's the other!
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform