Visible FoxPro refers to variations of FoxPro which are newer than model 2.6; this contains variations three.zero – 9.zero. In case you have used an older model of FoxPro and swap to Visible FoxPro, you’ll discover a number of variations such because the terminology, language, tables and databases, keystrokes, instruments, screens, and reviews and layouts.
Tables and Database Variations
One distinction between Visible FoxPro (VFP) and FoxPro is that the newer model distinguishes between databases and tables. Whereas tables from FoxPro 2.6 nonetheless work in Visible FoxPro, they are going to be saved as VFP tables if the construction of the desk is modified. Moreover, Visible FoxPro tables can settle for null values. To forestall errors created by makes an attempt to retailer null values to FoxPro 2.6 variables or to Visible FoxPro controls, initialize variables or arrays. You may disable the NULL-entry key mixture, to stop customers from making an attempt to retailer null values to tables, through the use of this assertion: “ON KEY LABEL CTRL+zero *”
The next are a number of desk and database variations between Fox Professional 2.6 and Visible Fox Professional
(FoxPro 2.6 Performance = Visible FoxPro Performance)
• Character discipline with NOCPTRANS Attribute = Character (BINARY) discipline sort. (See “Knowledge and Area Sorts” within the VFP Assist file.)
• Normal discipline measurement = Now four bytes. (See “Normal Area Sort” within the VFP Assist file.)
• Memo discipline measurement = Now four bytes. (See “Memo Area Sort” within the VFP Assist file.)
• Memo discipline with NOCPTRANS Attribute = Memo (BINARY) discipline sort. (See “Knowledge and Area Sorts” within the VFP Assist file.)
• Numeric fields = Foreign money knowledge sort, Double discipline sort, Float discipline sort, Integer discipline sort, or Numeric knowledge sort.
• OLE knowledge in a Normal discipline = OLE Certain Management.
Terminology Variations
Visible FoxPro redefines a number of phrases from older variations of FoxPro together with:
(FoxPro 2.6 Performance = VFP Performance)
• @… GET discipline = textual content field management
• Blanks or empty fields or variables = Null values
• Browse (in a Kind) = Grid management
• Buffer = File and desk buffers and transactions. (See “Buffering Entry to Knowledge” and “Utilizing Transactions” within the VFP Assist file.)
• Code snippets = Properties, strategies, and occasion code. (See “Setting Properties at Design Time” and “Assigning Methodology and Occasion Code” within the VFP Assist file.)
• Edit area = EditBox management (See “Visible FoxPro Naming Guidelines” within the Visible FoxPro Assist file.)
• Popup = ComboBox management
• Energy instruments = Visible designers and toolboxs. (See “Utilizing Designers” and “Utilizing Toolbars” within the Visible FoxPro Assist file.)
• PushButton = CommandButton management
• Radio button = OptionButton management
• Display screen = Kind
• Display screen image = Picture management
• Display screen set = Kind set
• Textual content = Label management
Language Variations
Along with the brand new instructions for Visible FoxPro, instructions for FoxPro 2.6 are backwards suitable and totally useful with VFP. There are a number of instructions for FoxPro 2.6 which have modified or enhanced capabilities in VFP. Moreover, Visible Fox Professional permits lengthy names for objects, variables, home windows, and tables. Except discipline names in free tables and index tags, you’ll be able to use as much as 254 characters. A number of the essential language variations are listed under:
(FoxPro 2.6 Performance = VFP Performance)
• @… SAY = Left Property, High property
• @… SAY PICTURE = Picture, OLE Certain
• BORDER = BorderStyle property
• MOVE WINDOW CENTER = AutoCenter property
• Shade = ColorSourceForeColor, BackColor property
• Shade scheme = ForeColor property, BackColor property, ColorScheme property
• Date knowledge sort = Date Knowledge Sort and Date Time Sort
• DBCONNECT = SQLCONNECT( ) Perform
• DBEXEC = SQLEXEC( ) Perform
• DEACTIVATE MENU, DEACTIVATE POPUP, DEACTIVATE WINDOW = Deactivate Occasion
• @… GET DEFAULT = Default property
• DEFINE WINDOW CLOSE = Closable property
• DEFINE WINDOW FLOAT = Movable property
• DEFINE WINDOW HALFHEIGHT = HalfHeightCaption property
• DEFINE WINDOW ICON FILE = Icon property
• EMPTY( ), BLANK( ) to verify for non-existent knowledge = ISNULL( ) to verify for null values representing unknown or non-existent knowledge
• Allow, Disable = Enabled property
• Font (Textual content Menu) = FontName property
• Font measurement (Font dialog) = FontSize property
• Font fashion daring (Font dialog) = FontBold property
• Font fashion italic (Font dialog) = FontItalic property
• @… SAY FUNCTION, any @… GET FUNCTION = Format property
• Top = Top property
• Horizontal place (Display screen Structure dialog) = Left property
• @… GET MESSAGE cMessageText = StatusBarText property
• MODIFY SCREEN = MODIFY FORM command
• MODIFY STRUCTURE = TABLE Designer
• Numeric knowledge sort = Numeric knowledge sort plus Float discipline sort, Integer discipline sort, Double discipline sort, and Foreign money knowledge sort
• Image = InputMask property
• READ ACTIVATE = ReadActivate occasion
• READ CYCLE = ReadCycle property
• READ DEACTIVATE = ReadDeactivate occasion
• READ LOCK = ReadLock property
• READ NOMOUSE = ReadMouse property
• READ SAVE = ReadSave property
• READ SHOW = ReadShow occasion
• READ TIMEOUT = ReadTimeout property
• READ VALID = ReadValid occasion
• READ WHEN = ReadWhen occasion
• Display screen Identify = Identify
• SET NOCPTRANS = (See “Stopping Translation of Knowledge in Character or Memo Fields” within the VFP Assist file)
• SHOW GET, SHOW GETS = Refresh technique
• Measurement (Display screen Structure dialog) = Top, Width properties
• Model (Font dialog) = FontBold, FontItalic, FontUnderline properties, FontShadow property,FontOutline property, FontStrikeThru property
• Terminate on choice (Display screen Builder)= TerminateRead property
• Title (Display screen Builder) = Caption property
• Legitimate (Display screen Builder) = Click on occasion, DblClick occasion, LostFocus occasion, Legitimate occasion
• Legitimate Error = ErrorMessage
• Vertical place (Display screen Structure dialog) = High property
• When (Display screen Builder) = GotFocus occasion, When occasion
• Width (Display screen Builder) = Width property
Device Variations
Whereas among the instruments in Visible FoxPro are the identical as in FoxPro 2.6, there are a number of Visible FoxPro instruments which are totally different or have totally different performance. Under is a rundown of among the massive variations:
(FoxPro 2.6 Performance = VFP Performance)
• Catalog Supervisor = Mission Supervisor
• Mission Supervisor = Mission Supervisor
• Display screen Builder = Kind Designer
• Align (Object menu) = Structure toolbox
• Display screen Builder Toolbox = Kind Controls toolbox
• Management dialogs and display structure dialogs = Properties window
• Menu Builder = Menu Designer
• RQBE = Question Designer
• Report Author = Report Designer
• Label Designer = Label Designer
• View window choices = Instruments Menu objects
• Transporter = Conversion Choices dialog field
• Browse window = Grid Management
Keystroke Variations
There are a number of variations in the best way the most recent variations of FoxPro and FoxPro 2.6 defines a few of their navigation key mixtures. Under are a number of of probably the most helpful navigation key instructions which are new or totally different.
To create a brand new file
• Ctrl + N (VFP)
Add a report to a browse window
• Ctrl + N (FoxPro 2.6)
• Ctrl + Y (VFP)
Do program in edit window
• Ctrl + O (FoxPro 2.6)
• Ctrl + E (VFP)
Enter null values into null enabled fields
• Ctrl + zero (Visible FoxPro)
Disable capability for customers to enter null values into null enabled fields
• On label: Ctrl + zero (VFP)
Display screen Variations
Whereas you’ll be able to run unconverted FoxPro 2.6 display recordsdata (.spr) in FoxPro Visible, Visible FoxPro kinds use code in occasions, strategies, and property settings instead of code snippets. Under, a few of these variations are highlighted.
• (FoxPro 2.6 Performance = VFP Performance)
• #DEFINE, #INSERT preprocessor statements = World embody file known as by new.SPR file. (See “Checking the.SPR File” within the VFP file.)
• #Part 1 Setup code = Kind set Load occasion
• #Part 2 Setup code = Kind Load occasion
• Cleanup code besides procedures = Unload occasion
• Code snippets = Methodology and occasion code and properties
• Constants = Resolved solely in technique and occasion code (See “Checking the.SPR File” within the Visible FoxPro Assist file.)
• Macro substitutions = Unresolved in properties. Use variables as a substitute (See “Checking Transformed FoxPro 2.6 Screens” within the Visible FoxPro Assist file.)
• READ = WindowType property
Report and Label Variations
Although you’ll be able to use unconverted FoxPro 2.6 reviews and labels in Visible FoxPro, with Visible FoxPro reviews and labels, you possibly can set and management the information setting to be able to management report content material by report variables. A number of the variations between FoxPro 2.6 and Visible FoxPro are proven under:
• (FoxPro 2.6 Performance = VFP Performance)
• Controls generated with the FoxPro Report Wizard utilizing “Place Relative To” choices = Would possibly want adjustment in Visible
• Memo discipline measurement = Now four bytes. (See “Memo discipline sort” within the Visible FoxPro Assist file)
• REPORT TO FILE = REPORT TO FILE ASCII creates easy textual content file
• REPORT ENVIRONMENTLABEL ENVIRONMENT = Knowledge Setting (View Menu) (See “Setting Report and Knowledge Sources” and “Controlling a Report’s Knowledge Sources” within the Visible FoxPro Assist file)