Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unexplainable phenomena?
Message
 
To
10/08/1999 10:26:32
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00251957
Message ID:
00251969
Views:
9
>>In a form I have code in the click section it make computations on a dbf called swork.dbf.
>>
>>THREE="CTOD(DATE_CLOSED)- CTOD(DATE_REC_J)"
>>DATEGOOD3="CTOD(DATE_CLOSE)>=MSTART .AND. CTOD(DATE_CLOSE) <=MEND .AND. STATUS <> 'CA' .AND. (DATE_CLOSE)<> 'NA'"
>>BPA="(BPA_NBR <> 'NA' .OR. REMARKS = 'BPA')"
>>
>>When it gets to this line:
>> AVER &THREE FOR &DATEGOOD3 .AND. &BPA TO AVGBPA3
>>It says "Variable 'DATE_CLOSED' not found" when in fact I hit suspend and verify manually and it's ok!
>>
>>:(
>
>Is it date_close or date_closeD?

That's it! you're pretty sharp today. Thing is, I copied that text from another prg I had working perfectly previously and the 'd' must have gotten added inadvertantly. Also what thru me off was that it said variable when it is a field!
thanks.
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform