InfoCenter
Info Center plug-in was designed to ease your work with data. It makes possible convenient way of managing different sorts of information: fast search of required data, aggregate operations with data (like Sum, Count), quick execution of SQL requests, set up indexes, mix required selections and more. User is free from taking care of bringing environment to the point as it was before working with data (filters, record pointers, etc). Info Center does this work for you.
Info Center is a powerful development tool for debugging business logic in the work of your project. Moreover, plug-in contains such useful add-ons as:
- Memory View - quick view of memory variables
- Program Stack - quick view of currently executed program stack
- Debug Expression - quick view and execution of various expressions and FoxPro commands
- Calculator - opens internal Calculator
- Calendar - opens internal Calendar
- Grid lines - brings up a measuring rule, that helps to measure objects in pixels and foxels
- Suspend - switch to suspend mode
- Debug - switch to debugging mode.
Tabs of the main dialog: Toolbar for additional tools:
Aliases tab
Aliases - list of tables opened in the "Datasession 1" range
Datasessions - list of opened data ranges
Location - physical location of current table
Filter expression - current expression of filter
Relation expression - current expression of relations with child table
Tags - list of indexes for the current table
Tag location - physical location of current tag in the index file
Index expression - index expression of current index tag
Show deleted record - current value of "Set delete On|Off" option
- open new table
from current DB or from another location
- execute SQL request for the
current table
Note: Use [...] buttons to use lists of objects available for pasting (table names, fields)
Fill in all required fields and click Execute. In the case when Сou'll get an execution error, refer to the Result page where you can find detailed information about the result of your request.
If your request was processed successfully you will be redirected to the Browse page of Info Center main window.
To edit SQL command click SQL-query button.
to the top
Browse tab
Tag - Set up index of current table. To change index, just select it from the list.
Filter - Current filter for the table. Specify new filter you can enter it manually or click [
]
and use expression designer. To setup default filter - click [<].[Memo] - shows memo field
[Seek] - execute Seek command with specified parameters
[Locate] - execute Locate command with specified parameters
[Continue] - executes Continue command and continues Locate search
[Top] - executes Go top command
[Bottom] - executes Go bottom command
[Current] - set up record pointer to default one
[Count] - execute Count command with specified parameters
[Sum] - execute Sum command with specified parameters
to the top
Structure tab
On this page you can get information about structure of current table and select a list of fields to view on the Browse page.
Fields type - Select field types you are interested in and you'll get filtered list of fields on the right.
Field, type - in that list fields that were filtered with the previous option are shown (type and size are mentioned). To select field just double click on it or use [->] button.
Fields list - here are shown all fields that are available for viewing on the Browse page. To delete field - use [<-]. To change the order of fields use Ctrl+Up, Ctrl+Dn, or Drad&Drop.
to the top
Toolbar for additional tools
- Browse RAM
- View the stack of program calls
- Browse expressions or execute commands
- Open Calculator
- Opens Calendar
- Bring up Measuring Rule
- run Suspend command
- run Debug commandMemory
Enter a mask of variables you want to browse and press Enter. In case for hidden variables - turn the Show hidden option on.
Program Stack
Debug expression
This dialog is for debugging different types of expressions.
Use sign "?" to refresh an expression (by evaluate) every time when focus gets to that field.
Use sign "=" to refresh an expression (by evaluate) every time when you press Enter in that field.
Use simple way of defining the expressions and it will be refreshed (by macro) every time you press Enter in that field.
Calculator
Calendar
Measuring rule
This rule appears right on the VFP desktop. It can be helpful when you work with form designer.
This rule has several properties that you can configure by calling context menu with the click of right mouse button.
Hot-keys:
F1 - Quick tip
Esc - Close rule
Ins - Orientation (vertical or horizontal)
Del - Scale (pixel or foxel)
Shift + [Arrow or click] - Position
Enter or double-click - Set a marker
Right click - Popup