Wiki Home

VFP to VBConcordance


Namespace: VFP
VFP to VB concordances
This is an important topic for the Visual FoxPro Wiki. Currently, this article is incomplete, and it would be cool to expand it. If you know anything about VFP to VBConcordance, please consider editing the topic and sharing your knowledge.

Les Pinter has a neat VFP to VB concordance document online at http://www.lespinter.com/Articles/English/216.htm (error 404).
Here's an archived copy, courtesy of the Wayback machine: http://web.archive.org/web/20010605064416/http://www.lespinter.com/Articles/English/216.htm

In summary, quoting from the article:

Visual FoxProVisual Basic
! commandSHELL
#DEFINE...#UNDEFNo equivalent
#IF...#ENDIFSame
#IFDEF...#ENDIFNo equivalent
#INCLUDENo equivalent
$ operatorInStr (reverse order of parameters)
% operatorMod()
macro expansionNo equivalent
&& inline comment prefix' (single quote)
* Comment prefix' (single quote)
+ (string concatenation> &
; (line continuation)_ (underscore)
.ResetToDefault() to return to defaultReadProperty
= (to execute a function) - no longer requiredNot required
? | ? print commandPrinter object Print, NewPage methods
? send directly to printerNo equivalent
@ commands (screen output)Use label objects
ABS()Same
ACCEPTInputBox() (Sort of...)
ACLASS()No equivalent
ACOPY()No equivalent
ACOS()Same
ACTIVATE MENUNo equivalent
ACTIVATE POPUPNo equivalent
ACTIVATE SCREENWindowName.Show
ACTIVATE WINDOWAppActivate
ADATABASES()No equivalent
ADBOBJECTS()Traverse database obj and enumerate
ADD CLASSNo equivalent
ADD TABLENo equivalent
ADEL()No equivalent
ADIR()No equivalent
AELEMENT()No equivalent
AERROR()No equivalent
AFIELDS()No equivalent
AFONT()No equivalent
AINS()No equivalent
AINSTANCE()No equivalent
ALEN()UBound()
ALIAS()No equivalent
AllowAddNew grid propertyDepends on the grid
ALLTRIM()Trim()
ALTER TABLE - SQLPST only
AMEMBERS()No equivalent
ANSITOOEM()No equivalent
APPENDAddNew of RecordSet object
APPEND FROMNo equivalent
APPEND FROM ARRAYNo equivalent
APPEND GENERALAppendChunk
APPEND MEMOAppendChunk
APPEND PROCEDURESNo equivalent
APRINTERS()No equivalent
ASC()Same
ASCAN()No equivalent
ASELOBJ()No equivalent
ASIN()Same
ASORT()No equivalent - IN FORMS, USE AN INVISIE
ASSERTDebug.Assert
ASUBSCRIPT()No equivalent
AT()InStr()
ATAN()Same
ATC()Instr()
ATCC(), AT_C()Double-byte (Unicode) string searches
ATCLINE()No equivalent
ATLINE()No equivalent
AT_C()InStrB()
AUSED()No equivalent
AVERAGENo equivalent
BAR(),BARCOUNT(),BARPROMPT()Not needed: VB menu items have events,
BEGIN TRANSACTIONMethod belongs to Data object
BEGIN...END TRANSACTION in DBCTransactions use Repository
BETWEEN()Same command, different syntax
BIT functionsNo equivalent
BITAND()Imp - implication operator
BLANKNo equivalent
BOF()BOF property of recordset
BROWSENo equivalent - use form with grid
BUILD EXE FROM object.MakeCompiledFile or File, Make
BUILD EXE, DLL, APPVB Menu selections
CALCULATENo equivalent
CALLSame
CANCELEnd
CANDIDATE()No equivalent - handled by RS object
CAPSLOCK()Use SendKeys() to set
CDCHDIR
CDOW()Instr(Format(now)) to find day name
CDX()No equivalent - handled by RS object
CEILING()No equivalent
CHANGENo equivalent - build a form instead
CHR()CHR$()
Class Browser (select from IDE menu)Repository Browser (select from IDE menu)
CLEAR EVENTSEnd
CLOSE TABLES ALLRecordSet.Close for each open RecordSet
CLOSE DATABASEUse Database.Close
CLOSE MEMONo equivalent
CMONTH()INSTR(FORMAT(now)) to find month name
CNTBAR()Not needed: VB menu items have events,
CNTPAD()Not needed: VB menu items have events,
COL()No equivalent
Combo Box control - syntax differencesDBCombo control
Command Button in ToolbarButton object
COMPILEIDE menu selection
Constant declarations not neededConst declarations
Constants in FOXPRO.HConstants - 22 lists in HELP
COPY FILENo equivalent
COPY INDEXESNo equivalent
COPY MEMONo equivalent
COPY PROCEDURESNo equivalent
COPY STRUCTURENo equivalent
COPY TAGNo equivalent
COPY TONo equivalent
COPY TO ARRAYNo equivalent
COS()Same
COUNTNo equivalent
CPCONVERT()No equivalent
CPCURRENT()No equivalent
CPDBF()No equivalent
CREATE ( a table interactively )Use VisData or Access
CREATE CLASSIDE menu selection
CREATE CLASSLIBNo equivalent
CREATE CONNECTIONData Object Method
CREATE CURSORData Object Method
CREATE DATABASEData Object Method
CREATE FORMIDE menu selection
CREATE FROMData Object Method
Create indexes, other featuresCONSTRAINT clause of ALTER
CREATE LABELIDE menu selection
CREATE MENUIDE menu selection
CREATE PROJECTIDE menu selection
CREATE QUERYData Object CreateQueryDef Method
CREATE REPORTIDE menu selection
CREATE SCREENIDE - Form Wizard
CREATE SQL VIEWData Object CreateQueryDef Method
CREATE TABLE - SQLData Object CreateTable Method
CREATE TRIGGERData Object CreateProcedure Method
CREATEBINARY()CharToBinary()
Create Object - classes or OCXsCreateObject - OCXs only
CREATEOBJECT()DIM AS New
CTOBIN()No equivalent
CURSORGETPROP()No equivalent
CURSORSETPROP()No equivalent
CURVAL()Now
DATE()Now
DATETIME()Now
DAY()Same
DBC()No equivalent
DBF() (return name of selected .DBF)RecordSet Object Property
DBGETPROP()Data Object Property
DBSETPROP()Set Data Object Property
DBUSED()No equivalent
DDE functionsVarious
DEACTIVATE MENUUse VB menu with 0 property
DEACTIVATE POPUPUse VB menu with 0 property
DEACTIVATE WINDOWAppActivate - AppDeactivate?
DEBUGSet breakpoint(s) in IDE
DEBUGOUTDEBUG.Print
DECLARE - DLLDeclare
DEFINE BARUse Menu Editor
DEFINE CLASS can be included in any PRGClasses are files created in the IDE
DEFINE CLASS..ENDDEFINETYPE statement - user-defined types
DEFINE MENUapplies to entire appMenus are created within forms
DEFINE PADUse Menu Editor
DEFINE POPUPUse Menu Editor
DELETERecordSet.Delete
DELETE - SQLRecordSet Action Query
DELETE CONNECTIONDatabase Object Method
DELETE FILEKILL
DELETE TAGRecordSet Object Property
DELETE TRIGGERRecordSet Object Property
DELETE VIEWRecordSet Object Property
DELETED()No equivalent
DESCENDING()No equivalent
Destroy eventTerminate event
DIMENSIONDim, ReDim [PRESERVE]
DIMENSION OR DECLAREDim, Redim
DIRDir - behaves differently
DIRECTORY()Dir
DISKSPACE()No equivalent
DISPLAYNo equivalent
DISPLAY < options >No equivalent
DISPLAY DLLSNo equivalent
DISPLAY MEMORYNo equivalent
DISPLAY OBJECTSNo equivalent
DISPLAY PROCEDURESNo equivalent
DISPLAY STATUSNo equivalent
DISPLAY STRUCTURETraverse RecordSet object Fields coll
DISPLAY TABLESTraverse Database object Tables coll
DISPLAY VIEWSTraverse Database object QueryDefs coll
DMY()Format() functions
DO CASE...ENDCASEDifferent syntax
DO commandNo equivalent
DO FORM
.Show
DO WHILE...ENDDODifferent syntax
DODEFAULT()No equivalent
DOW()FORMAT() function
DROP TABLEDatabase Object Method
DROP VIEWDatabase Object Method
DROPOFFLINE()No equivalent
DTOC()FORMAT() function
DTOR()FORMAT() function
DTOS()FORMAT() function
DTOT()FORMAT() function
EDITNo equivalent
EJECT()No equivalent
EMPTY()ISNULL(), ISEMPTY(), etc. type-specific
END TRANSACTIONDatabase Object Method
EOF()RecordSet Object EOF Property
ERASE KILL
ERROR commandCompletely different error handling
ERROR()Completely different error handling
EVALUATE()No equivalent
EXITExit
EXP()Same
EXPORTNo equivalent
EXTERNALNo equivalent
FCHSIZE()No equivalent
FCLOSE()CLOSE #
FCOUNT()RecordSet Object property
FCREATE()OPEN FOR OUTPUT
FDATE()FileDateTime()
FEOF()EOF(File#)
FERROR()Completely different error handling
FFLUSH()CLOSE # is similar
FGETS()READ #
FIELD()rs.FIELD(#).Name
FILE()GetAttr()
FILTER()No equivalent: RecordSet SELECT similar
FIND (obsolete)SEEK
FKLABEL()No equivalent
FKMAX()No equivalent
FLOCK()Recordset page locking is similar
FLOOR()End Sub
FLUSHNo equivalent - rs.Update is similar
FONTMETRIC()CommonDialog.ShowFont
FOPEN()OPEN # AS
FOR EACH...ENDFORSame
FOR()No equivalent
FOUND().NoMatch property of Recordset object
FPUTS()PRINT #
FPUTS(), FWRITE()Write #
FPUTS(), FWRITE()Print # - display-formatted data
FREAD()READ #
FREAD()Input #
FREE TABLENo equivalent
FSEEK()Seek(#), Loc(#)
FSIZE()GetAttr()
FTIME()FileDateTime()
FULLPATH()No equivalent
FUNCTIONFunction declarations somewhat different
FUNCTION or PROCEDURE statementSUB procedure declaration
FV()No equivalent
FWRITE()PRINT #
GATHERNo equivalent
GETBAR()Not needed: VB menu items have events,
GETCOLOR()CommonDialog component
GETCP()RecordSet property
GETDIR()CommonDialog component
GETENV()No equivalent
GETEXPRNo equivalent
GETFILE()CommonDialog component
GETFLDSTATE()RecordSet Object property
GETFONT()CommonDialog component
GETNEXTMODIFIED()No equivalent
GETOBJECT()Dim New
GETPAD()Not needed: VB menu items have events,
GETPEM()No equivalent for most features
GETPICT()CommonDialog component
GETPRINTER()CommonDialog component
GOBookmarking is similar
GOMONTH()Write your own
Grid base class - fewer features & propsDBGrid - very powerful and complex
HEADER()N/A
HELPobject.HelpFile = [filename]
HIDE MENUVisible property of each menu item
HIDE POPUP.Visible = False
HIDE WINDOW.Hide
HOME()AppDir()
HOUR()Format()
IF Value = DisplayValue, entry matchedMatchedWithList ( DBCombo or DBList)
IF...ENDIFDifferent syntax
IIF()Iff()
IIF() is similar but more verboseChoose()
Image List - almost never usedImageList - widely used
Image List control - used sparinglyImageList control - used extensively
IMPORTNo equivalent
IN ( list )IN ( list )
INDBC()No equivalent
INDEXRecordSet method
INKEY()No equivalent
INLIST()No equivalent
INPUTInputBox is similar
INSERTRecordSet SQL method
INSMODE()Use SendKeys() to set
ISALPHA()No equivalent
ISBLANK()IsEmpty() or "" = Expr
ISDIGIT()IsNumeric() is similar
ISEXCLUSIVE()RecordSet Object property
ISFLOCKED()RecordSet Object property
ISLEADBYTE()No equivalent
ISLOWER()Compare Lcase(expr) to (expr)
ISNULL()Same
ISREADONLY()RecordSet Object property
ISRLOCKED()RecordSet Object property
ISUPPER()Compare Ucase(expr) to (expr)
JOINUse SQL JOIN
MAPI ocxMAPI control - 54 entries in HELP
MSCOMM ocxMSComm object has 38 entries in HELP
Multimedia ocxMultimedia obj - 60 entries in HELP
KEY()No equivalent; rs Index collectn similar
KEYBOARDUse SendKeys() to set
KEYMATCH()Like SEEK, but doesn't move rec pointer
LABELReport writer also used for labels
LASTKEY()No equivalent
LEFT(). LEFTC()Left() is same;
LEN()Same
Like EMPTY(), but for uninitialized varsIsEmpty()
Like FoxPro Import,ExportImport - VisData
TableUpdate() with buffermode 3UpdateRecord
LIKE(), LIKEC()Like operator
LINENO()No equivalent; Breakpoints replace
LISTNo equivalent
LIST CONNECTIONSNo equivalent; traverse connections obj
LIST DATABASETraverse collections in db object
LIST DLLSNo equivalent
LIST OBJECTSNo equivalent
LIST PROCEDURESNo equivalent
LIST TABLESTraverse Database TABLES collection
LIST VIEWSTraverse Database TABLES collection
List Box and ComBox propertiesDBList and DBCombo constants
LOADPICTURE()Like GetData() from clipboard
LOCALNo equivalent; use Public or Private
Local has same scope, but no persistenceStatic
LOCATEFindFirst
LOCFILE()CommonDialog component
LOCK()Use RecordSet object methods
LOG()Same
LOG10()Write your own: Log10 = Log(X) / Log(10)
LOOKUP()No equivalent
LOWER()LCASE()
LPARAMETERS()Function parameters are similar
LTRIM()Same
LUPDATE()No equivalent
MAX()Same
MDMkDir
MDOWN()Use MouseDown event of Form
MDX()No equivalent
MDY()Format() function is similar
MEMLINES()No equivalent
MEMORY()No equivalent
MESSAGE()Use error collection for messages
MESSAGEBOX()MsgBox
MIN()Same
MINUTE()Timer is similar
MLINE()No equivalent
MOD()Same
Modal (screen)WindowName.Show 1
MODIFY CLASSIDE Class Editor
MODIFY COMMANDSHELL NotePad is similar
MODIFY CONNECTIONVisual editor - no equivalent
MODIFY DATABASEVisual editor - no equivalent
MODIFY FILESHELL NotePad is similar
MODIFY FORMIDE Form Editor
MODIFY GENERALVisual editor - no equivalent
MODIFY LABELVisual editor - no equivalent
MODIFY MEMOSHELL NotePad is similar
MODIFY MENUUse Form Menu Editor
MODIFY PROCEDUREIDE Module Editor
MODIFY PROJECTMenu - Open Project
MODIFY QUERYQuery definition within Data Environment
MODIFY REPORTIDE Report Designer
MODIFY SCREENIDE Form Editor
MODIFY STRUCTURENo equivalent; use TableDef
MODIFY VIEWNo equivalent; Use QueryDef
MODIFY WINDOWNo equivalent
MONTH()Same
MOUSE commandNo equivalent - used for demos
MRKBAR()Not used - VB menu is obj oriented
MRKPAD()Not used - VB menu is obj oriented
MROW()Used to simulate event model; not needed
MTON()Format(),
MWINDOW()Use Form.MouseOver event to trap
N/AUnattendedApp property
NDX()RecordSet manages indexes
No equivalentPrintForm
No equivalentLIKE operator
No equivalentGetFormat
No equivalentLoadResData
No equivalentLoadResString
No equivalentLoadResPicture
No equivalentAbout
No equivalentButton.Customize
No equivalentRemoveAddInFromToolbar
No equivalentButtonHeight, ButtonWidth
No equivalentIManageReposTypeLib
No equivalentIMdoComponent
No equivalentIMdoControl
No equivalentIMdoControlContainer
No equivalentIMdoControlUsage
No equivalentIMdoISVControl
No equivalentIMdoModelItem
No equivalentIMdoProject
No equivalentIMdoReference
No equivalentImplements
No equivalentIMpoProjectItem
No equivalentIMpoProjectItemContainer
No equivalentImport - add component to project
No equivalentBOFACTION property
No equivalentBookmark in IDE code editor
No equivalentVisibleItems property
No equivalentSelectedItem
No equivalentDataObject
No equivalentDataObjectFiles
No equivalentDateValue ( almost anything )
No equivalentDDB() function - Dbl Declining Balance
No equivalentHEX(), OCT()
No equivalentHitText of List objects
No equivalent in VFP 5.0Repository
No EquivalentLogPath, LogEvent
GoTo (Line # or label) not supportedGoTo
No equivalentLock, Unlock for sequential file I/O
No equivalentIsArray()
No equivalentDef Type statements
No equivalentStatusBar control
No equivalentWidth # (File output )
VFP events are exposed by defaultWithEvents
No equivalentPropertyBag
No equivalent.Printform
No equivalent.ShowIntaskBar
No equivalent - use MousePointerMouseIcon - set custom cursor
No equivalent - write your ownDateSerial
No equivalent; used for OLE operationsDataText
NOTESingle quote ( begins a comment )
NTOM()Ccur()
NUMLOCK()SendKeys()
NVL()No equivalent
Use obj.ListIndex,TopIndex to write your ownScroll event (lists, combos)
object.IncrementalSearch = .T./.F.object.MatchEntry (DBList/DBCombo)
object.Picture = GetData (object method)
object.Picture = SetData (object method)
object.Picture propertyobject.PaintPicture
OBJNUM()Traverse container objects
OBJTOCLIENT()Write your own
OBJVAR()Traverse container objects
OCCURS()Use Instr()
OCX Verb = 1, 2, etc. to call OCX functionSame
OLDVAL() - used with CURVAL()No equivalent
OLE HELP entries - 27OLE HELP entries - 30
ON ERRORVB uses ON ERROR GOTO label
ON ESCAPESet form Key Preview to True, then trap in Key Press ev
ON SELECTION Not used - VB menu is obj oriented
ON SHUTDOWNNo equivalent
ON() (to interrogate state of SET commands)No equivalent
OPEN DATABASEOpenDatabase(name) `
ORDER()Use Index collection of recordset object
OS()No equivalent
PACKNo equivalent
PACK DATABASENo equivalent
PAD()Use form menu click event code
PADL(), PADR(), PADC()Write your own
PARAMETERSSame
PARAMETERS()FUNCTION statement contains params
PARAMETERS()IsMissing() is similar
PAYMENT()Pmt()
PCOUNT()For missing parameters, use IsMissing()
PEMSTATUS()No equivalent
Picture propertyPicture object
PLAY MACRONo equivalent; use MSSCRIPT.OCX
Prefix of fieldname in Control SourceDataSource
PRIMARY()No equivalent
PRIVATEUsed differently
Private, PublicPrivate, Public
Procedures stored in DBCProcedure - stored procedures
PROGRAM()No equivalent
PROPER()StrConv ( String, 3 )
PUTFILE()CommonDialog component
QUITEnd (or Unload Me in MDI form)
QUITobject.QUIT
RAND()Rnd - precede by Randomize
RAT(), RATC()Write your own
RATLINE()Write your own
RDRmDkr
READ EVENTSDefault state of a VB app
READKEY()No equivalent
RECCOUNT()RecordSet property AFTER MoveLast
RECNO()No Equivalent
RECSIZE()No Equivalent
Refresh methodUpdateControls method
REFRESH()RecordSet method?
REINDEXNo Equivalent
RELATION()No Equivalent
RELEASENo equivalent
RELEASE N/A
RELEASE CLASSLIBNo Equivalent
RELEASE LIBRARYNo equivalent
RELEASE MENUSN/A
Release methodUnload method
REMOVE CLASSNo equivalent
REMOVE TABLEDataBase object method
RENAMEName AS
RENAME CLASSN/A
RENAME CONNECTIONN/A
RENAME TABLEN/A
RENAME VIEWN/A
REPLACErs.Edit: rs![Field]=: rs.update
REPLACE FROM ARRAYNo Equivalent
REPLICATE()String()
REPORTDataReportName.Go
Requery ( List Box, Combo Box )Refill ( List Box, Combo Box )
REQUERY()Requery method of QueryDef
RESTORE N/A
RESUMEPress F8 in IDE when breakpointed
RETRYNo equivalent
RETURNSame
RGB()Same, but not always used the same way
RIGHT(), RIGHTC()Same
RLOCK()No equivalent; Access locks by page
ROLLBACKRecordSet Object Method
ROUND()No equivalent
RowSourceobject.DataField
RTOD()Write your own
RTRIM()Rtrim()
RUNShell
Verb = (used with OLE objects)Verb = (used with OLE objects)
SAVE MACROSNo equivalent
SAVEPICTURE()CommonDialog
SCAN...ENDSCANUse rs.MoveNext until RS.eof
SCATTERNo equivalent
SCHEME()No equivalent
SEC()Same
SECONDS()Timer is similar
SEEK, SEEK()RecordSet Object FIND (Tables only)
SELECT 0FreeFile (for file I/O)
SETNo equivalent
SET ALTERNATENo equivalent; Use PRINT #
SET ASSERTSNo equivalent - PRINT.Assert
SET AUTOSAVENo equivalent
SET BELLNo equivalent
SET BLOCKSIZENo equivalent
SET CARRYNo equivalent
SET CENTURYNo equivalent
SET CLASSLIBClasses added to project in IDE
SET CLOCKNo equivalent
SET COLLATERecordSet object property
SET CONFIRMNo equivalent
SET CONSOLEN/A
SET COVERAGENo equivalent
SET CPCOMPILERecordSet Object Property
SET CPDIALOGNo equivalent
SET CURRENCYNo equivalent
SET CURSOR.MousePointer property
SET DATABASENo equivalent
SET DATASESSSIONNo equivalent
SET DATENo equivalent
SET DEBUGBreakpoint setting in IDE
SET DEBUGOUTNo equivalent
SET DEVELOPMENTNo equivalent
SET DOHISTORYNo equivalent
SET ESCAPENo equivalent
SET EVENTLISTNo equivalent
SET EVENTTRACKINGNo equivalent
SET EXACTParameter of RecordSet FIND method
SET EXCLUSIVERecordSet Object Property
SET FDOWNo equivalent
SET FDOW, SET FWEEK, WEEK()DatePart
SET FIELDSNo equivalent
SET FILTERQueryDef object defines views
SET FULLPATHN/A
SET FUNCTIONFunction key mapping
SET FWEEKNo equivalent
SET HEADINGSNo equivalent
SET HELPBind in a HLP file
SET HELPFILTERNo equivalent
SET HOURSNo equivalent
SET INDEXRecordSet object method
SET LIBRARYProject attachment in IDE
SET LOCKNo equivalent
SET MARKMenu object properties
SET MEMOWIDTHNo equivalent
SET NEARParameter of RecordSet FIND method
SET NOCPTRANSNo equivalent
SET NOTIFYNo equivalent
SET NULLRecordSet object property?
SET NULLDISPLAYForm.Format - 4th parameter
SET ODOMETERNo equivalent
SET OLEOBJECTReference must be resolved in project
SET OPTIMIZENo equivalent
SET ORDERRecordSet object method
SET PATHDataset object must fully qualify
SET POINTNo equivalent
SET PRINTERCommonDialog
SET PROCEDUREReferences must be resolved in IDE
SET REFRESHNo equivalent
SET RELATIONRecordSet method
SET REPROCESSNo equivalent
SET RESOURCEUse .INI file and write your own code
SET SAFETYNo equivalent
SET SECONDSNo equivalent
SET SKIPN/A - use form with FlexGrid
SET SPACEN/A
SET STATUS BARobject.StatusBarText property
SET STEPBreakpoint setting in IDE
SET SYSFORMATSNo equivalent
SET SYSMENUNo equivalent
SET TALKNo equivalent
SET TEXTMERGENo equivalent
SET TOPICNo equivalent
SET TRBETWEENNo equivalent
SET UDFPARMS; @ before ByRef varsByVal, ByRef
SET UNIQUERecordSet indexing parameter
SET WINDOW OF MEMONo equivalent - use SHELL NotePad
SET()No equivalent
SETFLDSTATE()No equiv - RecordSetEdit method 4record
SIGN()Same
Similar to LTRIM()LSET()
Similar to RTRIM()RSET()
SIN()Same
SKIP nRecordSet.Move n; can be relative to bookmark
SORTNo equivalent
SOUNDEX()No equivalent
SPACE()Space() Space$()
SQLSyntax different, e.g. Table![Fieldname]
SQLCANCEL()RecordSet or QueryDef method
SQLCOLUMNS()Data Object method parameters
SQLCOMMIT()Data Object method
SQLCONNECT()Data Object method
SQLDISCONNECT()Data Object method
SQLEXEC()Data Object method
SQLGETPROP()Data Object method
SQLMORERESULTS()Data Object method
SQLPREPARE()Data Object method
SQLROLLBACK()Data Object method
SQLSETPROP()Data Object method
SQLSTRINGCONNECT()Data Object method
SQLTABLES()Data Object method
SQRT()Same
STOREvarName = rs![Field]
STR()Different syntax
STRCONV()Same, slightly different syntax
STRTRAN()Write your own
STUFF()MID()
STUFF(), STUFFC()Write your own
SUBSTR()MID$()
Date2 - Date1 gives difference in daysDateDiff ( date1, Date2 )
SUMNo equivalent
SUSPENDBreakpoint set in IDE
SYS() functions (many)Calls to Windows API
SYSMETRIC()Various
Table Revert()RecordSet object method
TableUpdate()RecordSet object method
TAG()RecordSet object index property
TAGCOUNT()RecordSet object index property
TAGNO()RecordSet object index property
TAN()Same
TARGET()RecordSet object Relation property
TEXT...ENDTEXT' (on each individual comment line)
THISFORMMe
THISFORMSETNo equivalent
TIME()Time
Toolbar.AddObject methodButton Add method
TOTALNo equivalent
TRANSFORM()Format(), C* functions, others
TRIM()Same
TTOC()Format(), C* functions, others
TTOD()Format(), C* functions, others
TXNLEVEL()RecordSet object controls
TXTWIDTH()CommonDialog?
TYPE ( "" ) = "U/O/N/D/L"IsNumeric, IsDate, IsBoolean, others
UNLOCKRecordSet object method - Update/Revert
UPDATE - SQLExecuted in RecordSet object
UPPER()UCase()
UPPER(), LOWER(), PROPER()StrConv() function with different parameters
USEDatabase / RecordSet object definition
? INKEY(0) to see ASCII() value of keystrokesKeyCodeConstants
Use DO WHILE...ENDDOWHILE...WEND
USE statementAction Queries
USED()No equivalent
VAL()Same
VALIDATE DATABASENo equivalent
GetFont(), GetDir(), GetFile(), Get PrinterOffsite link to http://www.news2news.com/vfp/?function=549
()CommonDialog control
VERSION()Various App collection properties
VFP Valid event is different from VBValidate event
WAITUse MsgBox instead
WEEK()DatePart()
WEXIST()Iterate through app windows collection
WFONT()Form.FontName
WITH...ENDWITHSame
WTITLE()Iterate through app windows collection
YEAR()Same
ZAPNo equivalent
ZOOM WINDOWIndividual window properties
\ | \\ Text Merge print commandPRINT # (sort of...)
_Screen.Heightapp.WorkAreaHeight

Category Developer Productivity Category Reference
( Topic last updated: 2005.01.12 05:41:29 PM )