MB4-213 - Microsoft Business Solutions - Solomon 6.0 Tools for Visual Basic
Go back to Microsoft
Which property of a Solomon data control must be populated in order for the control to display the data stored in a buffer value?
What are common memory array functions used for the Solomon application?
When working with unbound controls, which statements are true?
Standard VB controls do not support standard Solomon functionality, such as F3 lookups.
Unbound controls must be attached or associated with a buffer variable.
What type of container object must be used to contain the data controls and grid controls for a detail level?
Standard Visual Basic Tab control
The ROI.exe accepts several different command line switches to allow programs to pass necessary information to the executable to print the desired report. Which switch passes the report number that is used by ROI.exe to retrieve the correct record from the RptControl table?
What value will be stored in the buffer variable attached to a Solomon Tools check box control when the user sets the control to "checked"?
The buffer variable will be set to what ever value is assign to the "True Text" property of the control
When working with Solomon reports, which statements are true?
The printing of a Solomon report can be initiated either from the menu or programmatically from within a program or customization.
When the printing of a Solomon report is initiated, a surrogate program called ROI.exe is called which provides some prepocessing functionality and will actually launch the Crystal Reports printing engine to print the report.
What program utility can be used to create needed controls and set necessary properties automatically?
Once the user chooses a company from the Login screen they will be connected to two databases, an application and system database. What type of information is contained in the System Database?
Users and Groups
If you are adding a level that accesses an existing Solomon table, most likely a stored procedure will already have been created to support possible values lookups for that table. What file would you search to locate a suitable stored procedure?
Although these are not requirements, what are common programming practices when starting a new Tools for Visual Basic project?
Name the VBP file and the FRM file the same as the seven character screen number for the program being created.
Do not overwrite the template files.
Save the VBP file and the FRM file in the newly created development directory.
When adding new tables to the Solomon database, which restrictions must you follow?
Table names must not contain spaces.
Table names must not begin with a number.
How many tables per level is the Solomon Kernel designed to manage automatically?
In order for the Kernel to be able to manage records in the database, data must be broken into logically related groups. What term is used to refer to these groups?
Which statement is not a true statement when discussing how records are retrieved from the DBMS?
Tools for Visual Basic programs directly access and update the data in the database.
What conditions would require a SetAddr call?
If the Solomon Kernel will be responsible for managing the buffer as the primary table for a level.
If controls for displaying and updating fields of the buffer are needed.
If you wish to expose the variable for access through Customization Manager.
What does UDT stand for?
User Defined Data Type
All Solomon programs must adhere to a unique naming convention. Which of these applies and is in the proper order?
2 character module ID; 3 character screen number; 2 character sub screen
Which property of a control is used to tell the Kernel that it is a key field?
What must be done to set up a database side cursor to be used for a new level?
The database server must be told to create the cursor.
The Solomon Kernel needs to be told that the cursor being created is to be used for the level being added.
The handle to the cursor must be stored in the global variable created for it.
When working with a detail level of a spreadsheet control, where will the Kernel look to find the stored procedure used to retrieve the records from the database?
Which two existing template files will assist you in starting a new Tools for Visual Basic project?
Which programs are used to manage the data that Dictionary Browser uses to created controls on a VB form?
When the Solomon application is launched, which main programs are started
What is true when working with a spreadsheet control?
It must be placed into a container.
The Kernel will format the control at run time.
The name property of the spreadsheet control must match the name used in the DetailSetup call.
When a user moves to a line in a grid, the kernel triggers a LineGotFocus event in the Solomon Tools for Visual Basic program. What best describes the purpose of the information that the kernel passes to this event via the MaintFlg parameter?
The value indicates the status of the line the user just moved to.
What type of information does the FieldName property contain?
Declare Length and Type
Field Offset Value
If users other than the system administrator need rights to any new Tools for Visual Basic programs, the screen numbers for those programs will need to be added to the Screens table. Which of the following utility programs either in the Solomon product or the MS SQL Server product, could be used to modify existing records and insert new records into this table?
Database Update Utility
The SetButton function has several parameters that can be identified. What do these parameters represent?
Which buttons should be enabled or disabled.
Which level should be affected.
If the buttons are being enabled or disabled.
What Solomon function can be called to disable buttons on the Toolbar?
The Status function and the process status form are designed to manage and/or implement which of the following functions that commonly need to be handled performing operations on multiple entities such as records a database?
The Process status form, with the proper use of the Status function, provides a consistent user interface for notifying the user of what is happening during a lengthy process.
If the Status function is used properly, it will respond to SQL database errors that might occur during a process by automatically generating event logs that describe what error occurred and what was being processed when the error occurred.
What does Solomon call a field that exists on a window but is not a field from any table in the database?
When the user hits the F3 function key on a field that has a PV property, where does the kernel get the information needed to determine what should be included in the Possible Values window?
The Kernel retrieves a record of the PVREC table in the Solomon system database which contains the definition of the possible values window.
Which API function call can be used to redisplay the current contents of a buffer variable in the controls bound to that buffer?
Generate schema can be used to create files with a CRT extension that contain SQL create table statements. What can be used to execute these SQL script statements?
By default, setting this property will tell the Kernel to validate any data entered into a field and force the user to only enter valid values.
What statements are true about the Solomon menu?
Commented lines begin with an asterisk (*).
A "-" character will generate a line across the menu list to identify groups of items.
Lines without square brackets beginning in the fifth column below the main menu item are applications that appear in that main menu item.
Which statement is true about Record Maintenance?
This utility allows a developer to define the names of new tables. It does not actually create tables in the Solomon database.
The Solomon kernel is designed to automatically manage the unique identity of records in a detail level by which of the following methods?
By the ordinal position in which the user entered the records into the spreadsheet.
By one or more ey?fields which are visible in the spreadsheet.
Which of the following methods can be used to open a sub-form of a Solomon program using the Solomon Object Model?
Using the control name of the button control on the user interface that opens the subform as the index to to the Controls collection, set the value property of that control to TRUE.
When the user changes the value of a field, what Tools for Visual Basic event will fire?
Solomon uses a standard naming convention for many files used during development. Which file extension is used for SQL script files that contain CREATE INDEX statements?
What program is used to assign rights to users and/or groups?
Access Rights Maintenance
What must be done in order for a program that is automating a Solomon program via the Solomon Object Model to be able to programmatically respond to warnings and error messages for the automated program?
The SIVApplication Object must be declared using the WithEvents key word.
Since levels are responsible for managing data retrieval and updating, what does each level require that must be stored in a global variable in the program?
Handle to the Cursor
When automating a Solomon program using the Solomon Object Model, which controls on the program are accessable via the SIVControls collection (assume the program being automated does not have any controls on it that are not supported by the Solomon Tools for Visual Basic Kernel)?
All data controls and buttons in the entire program regarless of the form they are, including controls that were added via customization manager.
What term is used in the Solomon Tools for Visual Basic to define a logically related group of information that can be managed by the Solomon Kernel?
Which utility is used to perform an import to get the PV definition into the PVREC table of the Solomon database?
Possible Values Import
What is a true statement when dealing with a "NOLEVEL" buffer?
The buffer is not part of any level.
The programmer is responsible for a "NOLEVEL" buffer.
When working with the Solomon Status function, which function displays a status form with a cancel button and a timer showing elapsed time?