Tech Update

The Best Tech Research

What is the Difference In between FoxPro and Visual FoxPro?

What is the Difference In between FoxPro and Visual FoxPro?

Visual FoxPro refers to variations of FoxPro that are newer than variation 2.6 this consists of versions 3. – 9.. If you have used an older version of FoxPro and swap to Visual FoxPro, you will find many distinctions this sort of as the terminology, language, tables and databases, keystrokes, applications, screens, and studies and layouts.

Tables and Database Discrepancies

A single big difference amongst Visible FoxPro (VFP) and FoxPro is that the newer model distinguishes in between databases and tables. Whilst tables from FoxPro 2.6 nevertheless work in Visible FoxPro, they will be saved as VFP tables if the structure of the desk is modified. Moreover, Visual FoxPro tables can accept null values. To avert glitches developed by attempts to retailer null values to FoxPro 2.6 variables or to Visible FoxPro controls, initialize variables or arrays. You can disable the NULL-entry important mixture, to avoid buyers from trying to store null values to tables, by working with this assertion: “ON Key LABEL CTRL+ *”

The next are quite a few desk and databases variations in between Fox Pro 2.6 and Visible Fox Pro

(FoxPro 2.6 Features = Visible FoxPro Functionality)

• Character industry with NOCPTRANS Attribute = Character (BINARY) area form. (See “Details and Field Forms” in the VFP Aid file.)

• General industry dimensions = Now 4 bytes. (See “General Field Type” in the VFP Assist file.)

• Memo discipline dimensions = Now 4 bytes. (See “Memo Field Kind” in the VFP Support file.)

• Memo discipline with NOCPTRANS Characteristic = Memo (BINARY) industry variety. (See “Details and Discipline Sorts” in the VFP Enable file.)

• Numeric fields = Currency facts form, Double field type, Float discipline kind, Integer subject form, or Numeric details sort.

• OLE facts in a Basic area = OLE Certain Handle.

Terminology Dissimilarities

Visible FoxPro redefines numerous phrases from older versions of FoxPro like:

(FoxPro 2.6 Functionality = VFP Functionality)

• @… GET discipline = textual content box handle

• Blanks or empty fields or variables = Null values

• Look through (in a Variety) = Grid control

• Buffer = Document and table buffers and transactions. (See “Buffering Access to Details” and “Employing Transactions” in the VFP Support file.)

• Code snippets = Properties, procedures, and function code. (See “Location Attributes at Design Time” and “Assigning System and Event Code” in the VFP Assist file.)

• Edit region = EditBox handle (See “Visible FoxPro Naming Rules” in the Visible FoxPro Enable file.)

• Popup = ComboBox handle

• Electricity resources = Visual designers and toolboxs. (See “Working with Designers” and “Making use of Toolbars” in the Visual FoxPro Aid file.)

• PushButton = CommandButton regulate

• Radio button = OptionButton regulate

• Monitor = Variety

• Display screen photo = Image management

• Display established = Form established

• Textual content = Label control

Language Variances

In addition to the new commands for Visual FoxPro, instructions for FoxPro 2.6 are backwards suitable and fully purposeful with VFP. There are numerous commands for FoxPro 2.6 that have modified or increased abilities in VFP. Furthermore, Visible Fox Pro lets very long names for objects, variables, windows, and tables. With the exception of field names in free tables and index tags, you are in a position to use up to 254 characters. Some of the vital language discrepancies are mentioned under:

(FoxPro 2.6 Functionality = VFP Performance)

• @… SAY = Still left Assets, Leading home

• @… SAY Photo = Impression, OLE Sure

• BORDER = BorderStyle assets

• Transfer WINDOW Middle = AutoCenter home

• Color = ColorSourceForeColor, BackColor house

• Coloration plan = ForeColor residence, BackColor house, ColorScheme residence

• Date information kind = Day Details Variety and Date Time Kind

• DBCONNECT = SQLCONNECT( ) Functionality

• DBEXEC = SQLEXEC( ) Perform


• @… GET DEFAULT = Default property

• Outline WINDOW Near = Closable residence

• Determine WINDOW FLOAT = Movable house

• Outline WINDOW HALFHEIGHT = HalfHeightCaption residence

• Outline WINDOW ICON FILE = Icon home

• Empty( ), BLANK( ) to check for non-existent data = ISNULL( ) to check out for null values symbolizing not known or non-existent data

• Allow, Disable = Enabled home

• Font (Textual content Menu) = FontName assets

• Font measurement (Font dialog) = FontSize property

• Font design bold (Font dialog) = FontBold property

• Font design italic (Font dialog) = FontItalic house

• @… SAY Perform, any @… GET Functionality = Structure property

• Top = Peak property

• Horizontal place (Screen Format dialog) = Still left assets

• @… GET Information cMessageText = StatusBarText house

• MODIFY Screen = MODIFY Type command

• MODIFY Composition = Table Designer

• Numeric knowledge form = Numeric information style in addition Float subject kind, Integer area style, Double subject type, and Currency data variety

• Photograph = InputMask property

• Go through ACTIVATE = ReadActivate party

• Study CYCLE = ReadCycle assets

• Read DEACTIVATE = ReadDeactivate party

• Read LOCK = ReadLock property

• Read NOMOUSE = ReadMouse assets

• Browse Help save = ReadSave assets

• Browse Display = ReadShow party

• Go through TIMEOUT = ReadTimeout home

• Read through Legitimate = ReadValid event

• Browse WHEN = ReadWhen event

• Screen Identify = Identify

• Established NOCPTRANS = (See “Blocking Translation of Data in Character or Memo Fields” in the VFP Support file)

• Display GET, Demonstrate Gets = Refresh technique

• Dimension (Screen Format dialog) = Height, Width houses

• Fashion (Font dialog) = FontBold, FontItalic, FontUnderline houses, FontShadow home,FontOutline assets, FontStrikeThru home

• Terminate on selection (Screen Builder)= TerminateRead assets

• Title (Screen Builder) = Caption house

• Valid (Monitor Builder) = Simply click event, DblClick celebration, LostFocus celebration, Valid party

• Legitimate Error = ErrorMessage

• Vertical placement (Display screen Format dialog) = Best home

• When (Screen Builder) = GotFocus celebration, When party

• Width (Display Builder) = Width property

Resource Discrepancies

Even though some of the instruments in Visible FoxPro are the very same as in FoxPro 2.6, there are numerous Visible FoxPro applications that are distinct or have unique performance. Beneath is a rundown of some of the significant distinctions:

(FoxPro 2.6 Features = VFP Performance)

• Catalog Supervisor = Venture Manager

• Undertaking Supervisor = Challenge Supervisor

• Monitor Builder = Type Designer

• Align (Object menu) = Layout toolbox

• Monitor Builder Toolbox = Form Controls toolbox

• Management dialogs and screen layout dialogs = Attributes window

• Menu Builder = Menu Designer

• RQBE = Question Designer

• Report Author = Report Designer

• Label Designer = Label Designer

• See window selections = Tools Menu merchandise

• Transporter = Conversion Alternatives dialog box

• Look through window = Grid Regulate

Keystroke Discrepancies

There are a several dissimilarities in the way the newest variations of FoxPro and FoxPro 2.6 defines some of their navigation essential mixtures. Down below are a handful of of the most helpful navigation key commands that are new or various.

To generate a new file

• Ctrl + N (VFP)

Increase a report to a look through window

• Ctrl + N (FoxPro 2.6)

• Ctrl + Y (VFP)

Do application in edit window

• Ctrl + O (FoxPro 2.6)

• Ctrl + E (VFP)

Enter null values into null enabled fields

• Ctrl + (Visual FoxPro)

Disable capacity for people to enter null values into null enabled fields

• On label: Ctrl + (VFP)

Display Dissimilarities

Whilst you are able to operate unconverted FoxPro 2.6 display data files (.spr) in FoxPro Visual, Visual FoxPro kinds use code in occasions, procedures, and house configurations in location of code snippets. Under, some of these dissimilarities are highlighted.

• (FoxPro 2.6 Operation = VFP Operation)

• #Determine, #INSERT preprocessor statements = Global consist of file called by new.SPR file. (See “Checking the.SPR File” in the VFP file.)

• #Segment 1 Set up code = Kind established Load function

• #Section 2 Set up code = Variety Load function

• Cleanup code other than techniques = Unload event

• Code snippets = Approach and function code and qualities

• Constants = Solved only in strategy and occasion code (See “Checking the.SPR File” in the Visible FoxPro Assistance file.)

• Macro substitutions = Unresolved in homes. Use variables in its place (See “Checking Transformed FoxPro 2.6 Screens” in the Visible FoxPro Help file.)

• Read through = WindowType house

Report and Label Dissimilarities

Nevertheless you are capable to use unconverted FoxPro 2.6 reports and labels in Visible FoxPro, with Visible FoxPro stories and labels, you can established and command the knowledge atmosphere in purchase to control report articles by means of report variables. Some of the differences among FoxPro 2.6 and Visual FoxPro are proven beneath:

• (FoxPro 2.6 Operation = VFP Performance)

• Controls generated with the FoxPro Report Wizard utilizing “Situation Relative To” options = Might will need adjustment in Visible

• Memo field measurement = Now 4 bytes. (See “Memo subject form” in the Visible FoxPro Support file)

• REPORT TO FILE = REPORT TO FILE ASCII results in basic text file

• REPORT ENVIRONMENTLABEL Natural environment = Data Ecosystem (Look at Menu) (See “Environment Report and Facts Sources” and “Managing a Report’s Data Resources” in the Visual FoxPro Enable file)