Content Supported by Sourcelens Consulting

Z@�This example illustrates populating a menu at run time. The menu is defined in the Menu Designer, but new menu items are added from a form with the DEFINE BAR command.�This example illustrates adding a check mark beside specific menu items at run time with the SET MARK OF command and disabling specific menu items at run time with SET SKIP.�This example includes columns in a grid with a ControlSource property setting of an expression or calculation.  Each row in the grid displays its own calculated value, which is dynamically updated.�This example illustrates displaying spinners (for numeric values) and check boxes (for logical values) in the columns of a grid. You can also specify whether the controls are always displayed or not.�This example illustrates setting the ForeColor and BackColor of grid columns on a row by row basis, depending on various criteria, using the DynamicForeColor and DynamicBackColor properties.�This example allows you to type a value in a text box, then add the value to a list.  You can also remove items from the list.  The key list box methods in this example are AddItem and RemoveItem.�This example illustrates changing the number of columns displayed in a list box at run time.  The key properties to set are ColumnCount, ColumnWidths, and RowSource.�This example illustrates moving one or more items from one list to another when a user clicks command buttons or drags and drops.�This example illustrates managing multiple selected items in a list box. Set MultiSelect to .T. to enable multiple selections. Loop through the list items and check the Selected property to manage.oThis example illustrates manipulating multiple items in a list box when the RowSourceType of the list is Files.�This example illustrates setting the Sorted property to .T. so that list items are alphabetically arranged and setting the MoverBars property to .T. so the user can order the items.�This example demonstrates how to fill a list with values, fields, array elements, table structure, queries, SQL statements, and files.�This example illustrates using a class with protected properties and exposed methods. For more description of this example, see Chapter 3, 'Object-Oriented Programming' in the Developer's Guide.eThis example illustrates using a class to display a system clock. You can drop the class on any form.`This example illustrates using a timer to perform an action at user-defined specified intervals.�This example presents an address book form with an adjustable number of tabs, each displaying a subset of customer names and phone numbers.mThis example illustrates programmatically changing the currently displayed page in a page frame without tabs.�This example illustrates creating a stored procedure in a database to automatically add an unique value to a field whenever a new record is added to the table.�This example illustrates the different order when you index on a character field that contains numbers and the VAL( ) of the field.�This example sets the order of the table to an index tag on a field when a user clicks the header of a column displaying the field.WThis example illustrates editing a memo field in a table or a text file in an edit box.�This example illustrates programmatically determining the database a table belongs to,  and the number of records, the number and type of fields, the index tags and the index expressions it has.�This example illustrates using a grid to display the child records in a 1-to-many-to-many relationship. As you move through the records in the parent, the child records are automatically displayed.|This example illustrates some Format and InputMask property settings, as well as some date display features, for text boxes.dThe example illustrates a variety of properties that can be set to customize command button display.�This example illustrates the values that can be displayed in a check box, as well as using a check box to toggle form behavior properties.�This example uses option buttons to present a short multiple-question quiz on Visual FoxPro. After you take the quiz, you can see your score and the correct answers.nThis example illustrates counting words, paragraphs, characters and searching for text strings in a text file.�This example uses six options buttons to let you choose one of the six button combinations (displayed in a page frame) in a MESSAGEBOX command.�This example illustrates providing functionality from a menu and a toolbar so that the same code is executed and both items and buttons can be disabled together.�This example illustrates providing functionality from a menu and a toolbar so that the same code is executed and both items and buttons can be disabled together.�This example illustrates declaring a Windows API function (GetSystemTime) that requires a pointer to a struct of 16 bit unsigned integers. The struct values are stored in a string and parsed out for information.�This example illustrates declaring a Windows API function (SetSysColors) that requires pointers to arrays of integers. You can programmatically get and set the system colors from Visual FoxPro.�This example illustrates reading Visual FoxPro settings from the Windows Registry and writing new values back out to the Registry.�This example illustrates checking to see if an application is registered and retrieving application and version information from the Windows Registry.�This example illustrates populating a list with members of a database and using the Picture property of the list to display an image beside the list.�This example illustrates allowing a user to interactively add and delete nodes in a treeview control.  You can also save your treeview settings to a table and restore them later.`This example uses OLE automation to change the type of graph and its legend displayed in a form.aThis example illustrates displaying file structures in an outline control and a treeview control.oThis example illustrates reading information about ODBC drivers and datasources stored in the Windows Registry.OThis example illustrates automating Excel for trend analysis and chart display.�This example illustrates using the DATA clause of the APPEND GENERAL command to refresh an MS Graph graph based on user interaction.This example illustrates how to add an OLE Control with an embedded Word object and change that object through OLE Automation. PThis example illustrates using BEGIN TRANSACTION, END TRANSACTION, and ROLLBACK.�This example illustrates displaying an SDI form, adding a menu to an SDI form, adding a toolbar to an SDI form, and displaying child windows in a form.sThis example illustrates the differences in size between various types of indexes on numeric and character fields. �This report example illustrates how to calculate a percentage total within a detail or group section, using a total value that is printed in the report summary.
�This example illustrates adding the value typed in the textbox part of a combo box to the drop-down part of the combo box.  It further illustrates locating records based on user input.�The example illustrates using a class ("resizable" in SOLUTIONS.VCX) to resize and reposition specified objects on a form whenever the form is resized.�This example illustrates implementing drag and drop operations -- repositioning a control with manual drag and drop, and taking an action with automatic drag and drop.dThis example illustrates setting the display characteristics of selected text in a RichText control.�This example allows you to draw lines and shapes on a form by clicking the left mouse button and dragging. You can also set pen styles and see how they affect drawing.eThis example demonstrates drawing lines based on equations with both polar and cartesian coordinates.�This example demonstrates saving coordinates of sets of lines drawn on a form and redrawing them, along with additional lines at intermediate positions, giving the illusion of motion.]This example illustrates adding, editing, and deleting records from a single table on a form.qThis example illustrates adding, editing, and deleting records from tables in a relationship displayed on a form.�This example illustrates displaying an SDI form, adding a menu to an SDI form, adding a toolbar to an SDI form, and displaying child windows in a form.�This example illustrates returning a value from a form.  A logon form is displayed.  When you close it, the user who logged on is returned to a calling form.�What's This Help allows you to provide context-sensitive help on a control by control basis.  This example also illustrates using animated cursors in a drag and drop operation.�This example illustrates allowing a user to type a value in a text box associated with a table field and filter the table based on that value.�This example illustrates setting properties of objects in a form set at run time.  This example is discussed in Chapter 9, "Creating Forms" of the Visual FoxPro Developer's Guide.�This example shows running the same form multiple times and managing data conflicts in each instance.  This example is discussed in Chapter 9, "Creating Forms" of the Visual FoxPro Developer's Guide.UThis example illustrates setting properties of the slider and statusBar OLE controls.�This example uses multiple field controls with different font and color settings to display information.  Conditions in the Print When dialog box determine when each of the field controls is displayed.KThis example illustrates printing invoice information from multiple tables.yThis example illustrates using Print When conditions in a report to print detail lines with alternating background fills.�This example illustrates wrapping text around general field bitmaps, alternating display of bitmaps, and using lines and shapes to print records in an attractive layout.qThis query retrieves customer names, associated order numbers, and all the line items associated with each order.�A full outer join allows you to retrieve all records from both tables and shows you all the matching records first, then records with .NULL. values where a match was not found in the other table.
�The query retrieves only records from two related tables that match the join criteria.  Any row from one table that does not have a matching row in the other table is not included.EThis query retrieves records from tables joined with two inner joins.�A right outer join retrieves all records from the table on the right side of the join criteria and only records that match the join criteria from the table on the left side of the join criteria.�A left outer join retrieves all records from the table on the left side of the join criteria and only records that match the join criteria from the table on the right side of the join criteria.mThis example illustrates taking data from combo boxes and text boxes and constructing a SQL SELECT statement.tThis example illustrates playing sound a video files using Multimedia Control Interface commands of the Windows API.KThis sample uses the ActiveX SysInfo control to display system information.�This query uses the Top N feature to retrieve the top ten best selling products based on total dollar amount made through sales.}This query uses the Top N feature to retrieve the worst ten selling products based on total dollar amount made through sales.^This example shows how to pass parameters to a form and return a value back from another form.OThis Customer mailing label shows how to set up a typical mailing label report.FThis example shows the different characteristics of the image control.dThis example shows how to pass data from VFP to Excel.  You must have both Word and Excel installed.eThis example shows how you can develop shortcut menus to speed access to commonly used functionality.VThis example shows how you can create a toolbar that interacts with objects on a form.<This example shows how to use MAPI within your applications.;This example shows using the ActiveX common dialog control.NThis example shows how to retrieve version information from EXE and DLL files.HThis parameterized view displays customers from the country you specify.�This sample uses a custom ActiveX� Control (Paper.OCX, created using Visual C++ 4.1 and the Ole Control Wizard) to demonstrate the MultiMedia Player control playing an AVI.
�This sample allows you to choose a year and a quarter.  You can then display a graph of the product sales for that quarter in the form and in a report.�This sample illustrates an alternative way to display shortcut menus, using an array and the DEFINE POPUP command rather than the Menu Designer.pThis sample allows users to choose a predetermined value from a list and store that value to a field in a table.?This sample shows advanced array handling for your application.7Use this ActiveX Control calendar to bind a Date field.[Add a variety of common buttons such as a help or application launcher button to your form.kUse a nifty conflict resolution dialog to display old, current and new data values for the user to resolve.FAdd wizard style edit buttons to 1-to-many relationship complex forms.;Add wizard style edit buttons to simple single table forms.IUse data lookup and unique value comboboxes to help users selecting data.`This sample has various types of record navigation including VCR style buttons and goto dialogs.TYou can add data querying to your applications such as via find buttons and dialogs.VAdd data sorting and filtering buttons, toolbars, menus and dialogs your applications.�This example shows a variety of common dialogs you might use in your application including aboutbox, splash screen, and user login forms.iTake advantage of the internet with this sample that shows how you can easily publish Visual FoxPro data.SThis example shows a number of common environment tasks that all applications need.LYou can handle top-level form tasks and cascading windows with this utility.nYou can use this control to allow a user to select both file and directory such as for creating a new project.�Take the hastle out of creating charts which are bound to fields in a single record. This sample also includes record navigation and automatic chart updating.|This example shows a variety of hyperlinks you can use with forms for navigating via your web browser to any web site (URL).`Add "coolbar" highlighting to any Visual FoxPro control like with the Internet Explorer coolbar.�This sample shows a number of useful mover listboxes for moving items between one list and another. It includes useful ones for handling tables and fields.�Use this valuable shortcut menu class to add a context menu to any Visual FoxPro object. You can also create cascading menus with it.�This sample shows off one of the most useful foundation classes, the OutputDialog class. You can use this for offering your user a variety of output/reporting options.gShow activity progress with this thermometer class that mimics those used by the Visual FoxPro product.itself.This samples uses automation classes to create Word mail merges, Excel pivot tables, Graph charts and Visual FoxPro cross-tabs.~This is a nice little error handler for your application which also includes capabililty for user to view error and add notes.qAdd the web browser control to your form to simulate having a fully functional web browser done in Visual FoxPro.�The new project manager hooks allow you to include track events associated with the project such as adding,  modifying, deleting files and building applications. This sample keeps an audit trail of this activity.�This sample is a useful utility for detemining data formats that a particular objects support. In addition to the samples on the form, you can also drag/drop from outside sources such as the Windows Explorer.ZHere is a sampling of fun OLE drag and drap ideas you might want to use in an application.lHere are two similarly functioning controls, each with a different interface, showing off OLE drag and drop.�This example shows how you can take existing Visual FoxPro application components (forms, menus, reports, etc.) and create an active document  to view in your web browser.|An assortment of access/assign methods used for various features including validation, object management and audit tracking.�Access/assign methods can be used to offer a consistent public interface between objects (such as the two controls in this sample), while hiding their internal implementation, which may be vastly different.at have a common property that is exposed �This samples shows the Visual FoxPro type library control which can be used to read type libraries from any COM component or ActiveX control.