This project is read-only.

VFP 9 SP2 Help File

Topics: Press Release
Feb 16, 2009 at 4:32 AM
Edited Feb 16, 2009 at 4:33 AM
It is my distinct pleasure to announce the "VFP 9 SP2 Help File" project is officially a new project on VFPX and Francis Faure is the project manager.

This project completes an ownership transfer of the VFP 9 SP2 Help file source code and rights to change from Microsoft to VFP Community. The VFP 9 SP2 Help file will be delivered under VFPX under the Creative Commons licensing.

What are the goals of this project?

1)   Provide corrected VFP 9 SP2 Help file to the VFP Community. Corrections to the Help file include corrected index, corrected hyperlinks, and corrected stylesheet.

2)   Allow the VFP Community to further enhance the Help file moving forward, adding missing content for VFP 9 SP2 and Sedna, making necessary corrections to existing examples, and repairing additional things missing in the index (like the SYS() functions).

The initial release will be the corrected file so developers using VFP 9 SP2 will have a usable Help file.

Thanks Francis!
Feb 18, 2009 at 2:00 PM
Edited Feb 18, 2009 at 6:05 PM
Thanks Rick!

I uploaded here monday 16 : the new vfp9SP2's Help File 1.04,

Since :
- "toreb" added a Comment in project page about HELP SELECT, HELP UPDATE, HELP INSERT, HELP DELETE.
- "CathyPountney" added a post in "Issue Tracker" about ComboxBox Control and CheckBox Control
- "Rick" asked for having SYS(...) in index file
- I received emails,
- I had ideas on possible missing,

So, I worked on the next release : 1.05 (Béta 5)

Actualy the next release contain this changes (allready done) :

    Added in index :
        PADL() -> "PADL( ) | PADR( ) | PADC( ) Functions"
        PADR() -> "PADL( ) | PADR( ) | PADC( ) Functions"
        PADC() -> "PADL( ) | PADR( ) | PADC( ) Functions"
        all the "SYS(....)"
        all the "How To: ..."
    Added in aLink Keywords
        HELP PADL    -> "PADL( ) | PADR( ) | PADC( ) Functions"
        HELP PADR    -> "PADL( ) | PADR( ) | PADC( ) Functions"
        HELP PADC    -> "PADL( ) | PADR( ) | PADC( ) Functions"
        HELP ERROR    -> "Error Messages Listed Alphabetically" + "Error Messages Listed Numerically"
        HELP SYS     -> "SYS( ) Functions Overview"
        HELP LIST    -> "LIST Commands"
        HELP CLEAR    -> "CLEAR Commands" + "Clear Methods"
        HELP CD     -> "CD | CHDIR Command" + "List Property"
        HELP CHDIR    -> "CD | CHDIR Command"
        HELP MD     -> "MD | MKDIR command"
        HELP MKDIR     -> "MD | MKDIR command"
        HELP RD        -> "RD | RMDIR command"
        HELP RMDIR    -> "RD | RMDIR command"
        HELP GO        -> "GO | GOTO Command"
        HELP GOTO    -> "GO | GOTO Command"
    Changed in aLink Keywords
        HELP UPDATE        -> Before on "UPDATE Command"     -> now on "UPDATE SQL"
        HELP INSERT        -> Before on "INSERT Command"     -> now on "INSERT SQL"
        HELP DELETE         -> "DELETE Command" + "DELETE SQL"
        HELP SELECT         -> "SELECT Command" + "SELECT SQL"
    Added in index (popup list choice)
        ComboBox control -> "ComboBox Control Properties, Methods, and Events"
        CheckBox control -> "CheckBox Control Properties, Methods, and Events"    


I published the 1.05 (Beta 5) today

Best Regards
Francis FAURE
Feb 18, 2009 at 7:09 PM

Hi Francis,

thanks a lot, I really appreciate your work. I find help so much more usable now!

Feb 19, 2009 at 1:17 AM
Merci beaucup Francis !
Wonderful job !

Salutations

Cesar
Apr 24, 2009 at 2:32 PM

There are two errors in Strtran’s topic.
The first error is nFlags  0 or 1, must be nFlags  0
The second error is
“You can also specify default behavior by passing –1 as the nFlags value.”
because you can not specify default behavior by passing –1 as the nFlags value.
?STRTRAN("1","1","2", -1, -1, -1) && returns “Function argument value, type, or count is invalid (Error 11)


Nov 6, 2009 at 7:28 PM

I found two additional error messages:

2202: Buffer manager internal consistency error.

2203: Insufficient GDI resources.

Got the second one in a running application!

Rick

Jan 11, 2010 at 9:12 PM

This is a minor item, but if you're going to update this, please add a link to the DIRECTORY() function in the See Also section for both the FILE and ADIR topics.  I couldn't remember if there was a command to test for the existence of a directory but since it wasn't linked I figured there must not be.  Ended up using ADIR which is a bit convoluted. 

 

--stein

Jan 11, 2010 at 10:04 PM
Steingo wrote:

This is a minor item, but if you're going to update this, please add a link to the DIRECTORY() function in the See Also section for both the FILE and ADIR topics.  I couldn't remember if there was a command to test for the existence of a directory but since it wasn't linked I figured there must not be.  Ended up using ADIR which is a bit convoluted. 

 

--stein

Dear Steingo,

Sorry : I don't realy understood what I must change in the next Build of vfp help file,

about "directory()" function ?
you talk about a link "see also" on the "directory()" function page
Could you clarify, for me, your request with an example?

best regards
Francis

Jan 11, 2010 at 10:42 PM
Faure wrote:

Dear Steingo,

Sorry : I don't realy understood what I must change in the next Build of vfp help file,

about "directory()" function ?
you talk about a link "see also" on the "directory()" function page
Could you clarify, for me, your request with an example?

best regards
Francis

What Stein is asking for is to have "See Also" links added to both the ADIR() and FILE() function topics, and have the new link point to the DIRECTORY() function topic. The ADIR() points to the DIRECTORY command only. Stein recently added some code to one of his applications to check for the existence of a folder on disk. He had forgotten that VFP has the DIRECTORY() function. His workaround code included FILE() and ADIR() and if the links to the DIRECTORY() function were there he might have saved himself some time, and written less code.

Jan 11, 2010 at 10:56 PM

Ok Rick
,
I understood now,
thanks

(again, sorry for my bad english)
I add that in next vfp help build. ok
Regards

Francis

 

May 2, 2011 at 4:59 PM

Hi,

I uploaded the new release (v1.06) of VFP9SP2 Help file.

What's new ?

All pages:
 - Corrected: Style of block "code" (margin & padding)
 - Removed: Combobox on top of each page "Language Filter : All / VB / C# / C++ / J# / JScript" !
 - Page Footer:    Ticket : http://vfpx.codeplex.com/workitem/30561
Added in aLink Keywords:
 - now, each page has an "aLink keywords" on the Title of the page (for calling directly in VFP with HELP Title...)
Added in index:
 - error messages "numerical order", "Error Messages Listed Numerically"  Ticket http://vfpx.codeplex.com/workitem/21307
 - double click on "error messages", added "Error Messages Listed Numerically" Ticket http://vfpx.codeplex.com/workitem/21307
 - double click on "double-byte characters", added "ATCC( ) function"  http://vfpx.codeplex.com/workitem/21767
 - double click on "double-byte characters", "Application Creation with Double-Byte Character Sets"
Pages added:
 - VFPX: List "Add and Updates" in VFP 9 SP2 Help file
 - SET DIRECTORY Command  Ticket http://vfpx.codeplex.com/workitem/23417
 - DBALIAS( ) Function    Ticket http://vfpx.codeplex.com/workitem/30506
 - Error 2202 Buffer manager internal consistency error
 - Error 2203 Insufficient GDI resources
 - FLDCOUNT( ) Function   Ticket http://vfpx.codeplex.com/workitem/30542
 - PADPROMPT( ) Function  Ticket http://vfpx.codeplex.com/workitem/30549
 - WINDOW( ) Function  Ticket http://vfpx.codeplex.com/workitem/30550
Pages updated:
 - DBC( ) Function        Ticket http://vfpx.codeplex.com/workitem/30506
 - SET Command Overview   Ticket http://vfpx.codeplex.com/workitem/23417
 - SET( ) Function  Ticket http://vfpx.codeplex.com/workitem/23417
 - VERSION( ) Function    Ticket http://vfpx.codeplex.com/workitem/22312
 - TXNLEVEL( ) Function   Ticket http://vfpx.codeplex.com/discussions/54976
 - SET DATABASE Command   Ticket http://vfpx.codeplex.com/workitem/30506
 - STRTRAN( ) Function    Ticket http://vfpx.codeplex.com/discussions/47198?ProjectName=vfpx
 - FILE( ) Function       Ticket http://vfpx.codeplex.com/discussions/47198?ProjectName=vfpx
 - ADIR( ) Function       Ticket http://vfpx.codeplex.com/discussions/47198?ProjectName=vfpx
 - Error Messages Listed Alphabetically Ticket http://vfpx.codeplex.com/workitem/30522
 - SUBSTRC( ) Function    Ticket http://vfpx.codeplex.com/workitem/21767
 - SUBSTR( ) Function     Ticket http://vfpx.codeplex.com/workitem/21767
 - RIGHTC( ) Function     Ticket http://vfpx.codeplex.com/workitem/21767
 - RIGHT( ) Function      Ticket http://vfpx.codeplex.com/workitem/21767
 - RATC( ) Function  Ticket http://vfpx.codeplex.com/workitem/21767
 - LIKEC() function  Ticket http://vfpx.codeplex.com/workitem/21767
 - AT_C( ) Function       Ticket http://vfpx.codeplex.com/workitem/21767 + delete duplicate entry of ATCC() in "see also" + re-order
 - ATCC() function        Ticket http://vfpx.codeplex.com/workitem/21767
 - VFPX Page add build # of the VFP9SP2 Help file : http://vfpx.codeplex.com/workitem/23522
 - Error Messages Listed Numerically: added errors 2202 and 2203- Ticket http://vfpx.codeplex.com/discussions/47198?ProjectName=vfpx
 - Error Messages Listed Numerically: added buttons list in header
 - Error Messages Listed Alphabetically: added errors 2202 and 2203
 - Error Messages Listed Alphabetically: added buttons list in header
 - STRTRAN( ) Function    Ticket http://vfpx.codeplex.com/workitem/30564
 - STREXTRACT( ) Function bracket removed
 - SYS(2325)   Ticket http://vfpx.codeplex.com/workitem/30571
 - SYS( ) Functions Overview Ticket http://vfpx.codeplex.com/workitem/30571
 - PictureVal Property  Ticket http://vfpx.codeplex.com/workitem/30570
 - SYS(2029)   Ticket http://vfpx.codeplex.com/workitem/30554
 - FontCharSet Property   Ticket http://vfpx.codeplex.com/workitem/21318
 - IMESTATUS( ) Function  Ticket http://vfpx.codeplex.com/workitem/30567
 - Table File Structure (.dbc, .dbf, .frx, .lbx, .mnx, .pjx, .scx, .vcx) ticket http://vfpx.codeplex.com/workitem/30553
 - NOTE Command   Ticket http://vfpx.codeplex.com/workitem/30572
 - FILE( ) Function  Ticket http://vfpx.codeplex.com/workitem/30592
 - SET DOHISTORY Command  Ticket http://vfpx.codeplex.com/workitem/30560
 - SET Command Overview   Ticket http://vfpx.codeplex.com/workitem/30560
 - SET( ) Function  Ticket http://vfpx.codeplex.com/workitem/30560
 - SET ECHO Command  Ticket http://vfpx.codeplex.com/workitem/30560
 - SET STEP Command  Ticket http://vfpx.codeplex.com/workitem/30560
 - DEBUG Command   Ticket http://vfpx.codeplex.com/workitem/30560
 - DEBUGOUT Command  Ticket http://vfpx.codeplex.com/workitem/30560 
 - Backward-Compatible Language Elements  Ticket http://vfpx.codeplex.com/workitem/30550
 - VFPX Page   Ticket http://vfpx.codeplex.com/workitem/30547
 - LOADPICTURE()   Ticket http://vfpx.codeplex.com/workitem/30570
Added in TOC / Contents:
 - VFPX Topic
 - SET DIRECTORY Command
 - DBALIAS( ) Function
 - FLDCOUNT( ) Function  
 - PADPROMPT( ) Function
 - SET DOHISTORY Command (moved)
 - WINDOW( ) Function (Backward-Compatible Language Elements)
Installation:
 - Inno Setup: now deletes the "dv_foxhelp.chw" file

Normally all the tickets of the "issue tracker" are fixed.
Thank you for your feedback.
Thank you to Rick, Tamar, Pavel, billand88, Burkhard, Koen, Igor_Nikiforov, RGBean944, Steingo, Woody, Christof, Pablo, ...

With best regards
Francis

May 2, 2011 at 5:05 PM

Thank you. I always point people at the VPX help file, and appreciate all the corrections so I don't have to explain "the original Help file isn't correct!".

Rick Bean

(Just up the road in Michigan from that other Rick - Schummer)

From: Faure [email removed]
Sent: Monday, May 02, 2011 12:00 PM
To: Rick.Bean
Subject: Re: VFP 9 SP2 Help File [VFPX:47198]

From: Faure

Hi,

I uploaded the new release (v1.06) of VFP9SP2 Help file.

What's new ?

All pages:
- Corrected: Style of block "code" (margin & padding)
- Removed: Combobox on top of each page "Language Filter : All / VB / C# / C++ / J# / JScript" !
- Page Footer: Ticket : http://vfpx.codeplex.com/workitem/30561
Added in aLink Keywords:
- now, each page has an "aLink keywords" on the Title of the page (for calling directly in VFP with HELP Title...)
Added in index:
- error messages "numerical order", "Error Messages Listed Numerically" Ticket http://vfpx.codeplex.com/workitem/21307
- double click on "error messages", added "Error Messages Listed Numerically" Ticket http://vfpx.codeplex.com/workitem/21307
- double click on "double-byte characters", added "ATCC( ) function" http://vfpx.codeplex.com/workitem/21767
- double click on "double-byte characters", "Application Creation with Double-Byte Character Sets"
Pages added:
- VFPX: List "Add and Updates" in VFP 9 SP2 Help file
- SET DIRECTORY Command Ticket http://vfpx.codeplex.com/workitem/23417
- DBALIAS( ) Function Ticket http://vfpx.codeplex.com/workitem/30506
- Error 2202 Buffer manager internal consistency error
- Error 2203 Insufficient GDI resources
- FLDCOUNT( ) Function Ticket http://vfpx.codeplex.com/workitem/30542
- PADPROMPT( ) Function Ticket http://vfpx.codeplex.com/workitem/30549
- WINDOW( ) Function Ticket http://vfpx.codeplex.com/workitem/30550
Pages updated:
- DBC( ) Function Ticket http://vfpx.codeplex.com/workitem/30506
- SET Command Overview Ticket http://vfpx.codeplex.com/workitem/23417
- SET( ) Function Ticket http://vfpx.codeplex.com/workitem/23417
- VERSION( ) Function Ticket http://vfpx.codeplex.com/workitem/22312
- TXNLEVEL( ) Function Ticket http://vfpx.codeplex.com/discussions/54976
- SET DATABASE Command Ticket http://vfpx.codeplex.com/workitem/30506
- STRTRAN( ) Function Ticket http://vfpx.codeplex.com/discussions/47198?ProjectName=vfpx
- FILE( ) Function Ticket http://vfpx.codeplex.com/discussions/47198?ProjectName=vfpx
- ADIR( ) Function Ticket http://vfpx.codeplex.com/discussions/47198?ProjectName=vfpx
- Error Messages Listed Alphabetically Ticket http://vfpx.codeplex.com/workitem/30522
- SUBSTRC( ) Function Ticket http://vfpx.codeplex.com/workitem/21767
- SUBSTR( ) Function Ticket http://vfpx.codeplex.com/workitem/21767
- RIGHTC( ) Function Ticket http://vfpx.codeplex.com/workitem/21767
- RIGHT( ) Function Ticket http://vfpx.codeplex.com/workitem/21767
- RATC( ) Function Ticket http://vfpx.codeplex.com/workitem/21767
- LIKEC() function Ticket http://vfpx.codeplex.com/workitem/21767
- AT_C( ) Function Ticket http://vfpx.codeplex.com/workitem/21767 + delete duplicate entry of ATCC() in "see also" + re-order
- ATCC() function Ticket http://vfpx.codeplex.com/workitem/21767
- VFPX Page add build # of the VFP9SP2 Help file : http://vfpx.codeplex.com/workitem/23522
- Error Messages Listed Numerically: added errors 2202 and 2203- Ticket http://vfpx.codeplex.com/discussions/47198?ProjectName=vfpx
- Error Messages Listed Numerically: added buttons list in header
- Error Messages Listed Alphabetically: added errors 2202 and 2203
- Error Messages Listed Alphabetically: added buttons list in header
- STRTRAN( ) Function Ticket http://vfpx.codeplex.com/workitem/30564
- STREXTRACT( ) Function bracket removed
- SYS(2325) Ticket http://vfpx.codeplex.com/workitem/30571
- SYS( ) Functions Overview Ticket http://vfpx.codeplex.com/workitem/30571
- PictureVal Property Ticket http://vfpx.codeplex.com/workitem/30570
- SYS(2029) Ticket http://vfpx.codeplex.com/workitem/30554
- FontCharSet Property Ticket http://vfpx.codeplex.com/workitem/21318
- IMESTATUS( ) Function Ticket http://vfpx.codeplex.com/workitem/30567
- Table File Structure (.dbc, .dbf, .frx, .lbx, .mnx, .pjx, .scx, .vcx) ticket http://vfpx.codeplex.com/workitem/30553
- NOTE Command Ticket http://vfpx.codeplex.com/workitem/30572
- FILE( ) Function Ticket http://vfpx.codeplex.com/workitem/30592
- SET DOHISTORY Command Ticket http://vfpx.codeplex.com/workitem/30560
- SET Command Overview Ticket http://vfpx.codeplex.com/workitem/30560
- SET( ) Function Ticket http://vfpx.codeplex.com/workitem/30560
- SET ECHO Command Ticket http://vfpx.codeplex.com/workitem/30560
- SET STEP Command Ticket http://vfpx.codeplex.com/workitem/30560
- DEBUG Command Ticket http://vfpx.codeplex.com/workitem/30560
- DEBUGOUT Command Ticket http://vfpx.codeplex.com/workitem/30560
- Backward-Compatible Language Elements Ticket http://vfpx.codeplex.com/workitem/30550
- VFPX Page Ticket http://vfpx.codeplex.com/workitem/30547
- LOADPICTURE() Ticket http://vfpx.codeplex.com/workitem/30570
Added in TOC / Contents:
- VFPX Topic
- SET DIRECTORY Command
- DBALIAS( ) Function
- FLDCOUNT( ) Function
- PADPROMPT( ) Function
- SET DOHISTORY Command (moved)
- WINDOW( ) Function (Backward-Compatible Language Elements)
Installation:
- Inno Setup: now deletes the "dv_foxhelp.chw" file

Normally all the tickets of the "issue tracker" are fixed.
Thank you for your feedback.
Thank you to Rick, Tamar, Pavel, billand88, Burkhard, Koen, Igor_Nikiforov, RGBean944, Steingo, Woody, Christof, Pablo, ...

With best regards
Francis

May 2, 2011 at 5:14 PM
Bonjour Francis,

I have uploaded and installed your new helpfile without any problems at all. It all looks fine.

Merci ami,

Best regards,

Koen
++++++++++++

2011/5/2 Faure <notifications@codeplex.com>

From: Faure

Hi,

I uploaded the new release (v1.06) of VFP9SP2 Help file.



Dec 4, 2012 at 11:49 AM

 

I notice that Set Classlib is entered twice in the last help file, but the content is not identical.

Dec 4, 2012 at 1:45 PM

Hi Toreb

a) could you open a ticket in "issue tracker" on vfpx

b) please add a print screen : I don't see twice help page for éset classlib". or what you type in command windows to see twice.
If I see/understand I can fix it

with best regards

Francis FAURE 

Dec 4, 2012 at 2:05 PM

Faure:

I just did. I don’t know whether all three images went through, so I attach them here also.

Tore Bleken

Norway

From: Faure [email removed]
Sent: 4. desember 2012 14:45
To: Tore Bleken
Subject: Re: VFP 9 SP2 Help File [VFPX:47198]

From: Faure

Hi Toreb

a) could you open a ticket in "issue tracker" on vfpx

b) please add a print screen : I don't see twice help page for éset classlib". or what you type in command windows to see twice.
If I see/understand I can fix it

with best regards

Francis FAURE

Jul 29, 2013 at 11:53 AM
Edited Aug 4, 2013 at 8:25 PM
Probably I'm not the first who pointed out this one. I quote from the help

EVALUATE(cExpression)

Parameters
cExpression
Specifies the expression to evaluate. cExpression can be a literal character string, or a valid Visual FoxPro expression, variable, array element, or field of any data type, enclosed in quotation marks. cExpression cannot exceed 255 characters.


It was a pleasant surprise to discover that cExpression can be 8192 character (if it's a variable):
LOCAL x[1162] as Integer,lc,s,lni && a dimension of 1163 exceed 8192 and produce error
lc=''
s=0
FOR lni=1 TO ALEN(x)
  x[lni]=INT(RAND()*30000)
  lc=lc+"+x["+TRANSFORM(lni)+"]"
  s=s+x[lni]
NEXT
lc="5"+lc
s=5+s
STRTOFILE('EVALUATE(lc)='+TRANSFORM(EVALUATE(lc))+CHR(13)+'s='+TRANSFORM(s)+CHR(13)+'LEN(lc)='+TRANSFORM(LEN(lc))+CHR(13)+'lc='+lc,'zzz.txt')
MODIFY FILE zzz.txt
I quote from the VFP help (topic Eval Method):

Specifies the expression to evaluate. cExpression can be a literal character string, or a valid Visual FoxPro expression, variable, array element, or field of any data type, enclosed in quotation marks.


I adjust my previous example.
LOCAL x[1162] as Integer,lc,s,lni && a dimension of 1163 exceed 8192 and produce error
lc=''
s=0
FOR lni=1 TO ALEN(x)
  x[lni]=INT(RAND()*30000)
  lc=lc+"+x["+TRANSFORM(lni)+"]"
  s=s+x[lni]
NEXT
lc="5"+lc
s=5+s

MESSAGEBOX(EVALUATE(s)) && error
MESSAGEBOX(_vfp.Eval(s)) && ok

MESSAGEBOX(EVALUATE(SIN(1+2))) && error
MESSAGEBOX(_vfp.Eval(SIN(1+2))) && no error but wrong result

MESSAGEBOX(EVALUATE("SIN(1+2)")) && ok
MESSAGEBOX(_vfp.Eval("SIN(1+2)")) && ok


STRTOFILE('EVALUATE(lc)='+TRANSFORM(EVALUATE(lc))+CHR(13)+;
            's='+TRANSFORM(s)+CHR(13)+;
            '_vfp.Eval(lc)='+TRANSFORM(_vfp.Eval(lc))+CHR(13)+;
            '_vfp.Eval(s)='+TRANSFORM(_vfp.Eval(s))+CHR(13)+;
            'LEN(lc)='+TRANSFORM(LEN(lc))+CHR(13)+'lc='+lc,'zzz.txt')
MODIFY FILE zzz.txt
As it can seen, Eval has its own inconsistence:
  • like EVALUATE(), work with variable (no quotation needed)
  • unlike the EVALUATE() help topic, there is no reference to the 254 chars limit
  • unlike EVALUATE(), accept numeric expressions (despite the help topic for Eval method), although it seems that results are truncated

A little more comparison between eval() and evaluate():
MESSAGEBOX(_vfp.Eval(5)) && no error, the correct result 5
MESSAGEBOX(EVALUATE(5)) && syntax error

MESSAGEBOX(_vfp.Eval(5.99)) && no error, the erroneous result 5
MESSAGEBOX(EVALUATE(5)) && syntax error

MESSAGEBOX(_vfp.Eval(1+2)) && no error, the correct result 3
MESSAGEBOX(EVALUATE(1+2)) && syntax error

MESSAGEBOX(_vfp.Eval(1+2.9)) && no error, the erroneous result 3
MESSAGEBOX(EVALUATE(1+2.9)) && syntax error

MESSAGEBOX(EVALUATE("1+2.9")) && ok
MESSAGEBOX(_vfp.Eval("1+2.9")) && ok

****
MESSAGEBOX(_vfp.Eval(DATE())) && date in numeric format DD.MM 
MESSAGEBOX(Evaluate(DATE())) && syntax error

MESSAGEBOX(_vfp.Eval(DATETIME())) && date in numeric format DD.MM 
MESSAGEBOX(Evaluate(DATETIME())) && syntax error

MESSAGEBOX(_vfp.Eval("DATE()")) && similar result with:
MESSAGEBOX(DTOT(DATE()))
MESSAGEBOX(EVALUATE("date()")) && ok

MESSAGEBOX(EVALUATE("DATETIME()")) && ok
MESSAGEBOX(_vfp.Eval("DATETIME()")) && ok

MESSAGEBOX(EVALUATE(.T.)) && syntax error
MESSAGEBOX(_vfp.Eval(.T.)) && error


xx=DATE()
MESSAGEBOX(EVALUATE(xx)) && syntax error
MESSAGEBOX(_vfp.Eval(xx)) && outputs 0

MESSAGEBOX(_vfp.Eval(@xx)) && outputs date in numeric format DD.MM 
MESSAGEBOX(EVALUATE(@xx)) && syntax error

xx=11
MESSAGEBOX(_vfp.Eval(xx)) && outputs 0
MESSAGEBOX(EVALUATE(xx)) && syntax error

MESSAGEBOX(_vfp.Eval(@xx)) && outputs 11
MESSAGEBOX(EVALUATE(@xx)) && syntax error


xx=.T.
MESSAGEBOX(_vfp.Eval(xx)) && outputs 0
MESSAGEBOX(EVALUATE(xx)) && syntax error

MESSAGEBOX(_vfp.Eval(@xx)) && error
MESSAGEBOX(EVALUATE(@xx)) && syntax error