|
| |
Announcing Advanced DB Master version 7.2
Shipping August 1, 2006
Advanced DB Master version 7.2 supports:
Microsoft Windows Server 2003
Microsoft Windows XP
New features in 7.2
| Tools |
 |
Find Database
Elements
A new button
Used By
will open a new Find Database Elements window with a search for the
element currently selected in your open Find Database Elements window.
Another new button is
Macros Only
which brings up 3 additional buttons:
Whole Word,
Match Case,
and
Comments,
which add the additional control over these factors that are available
in the
Find In
Macros
tool. In this mode, only the macros are searched. When a search is
displayed with both the
Table
and
Field
values filled in, you can changed the search to include all tables for
this field by clicking the
+T
button. |
|
Macro Editor
Find Database
Elements
A new button on the Macro Editor toolbar will open a
Find Database
Elements
window with a selection based on the line that the cursor is on. Place
the cursor on a line containing one of the commands: RunDataChange,
RunMacro, LoadView, LoadTable, PrintReport, or ViewReport, but do NOT
select a range of characters. When you click the
Find Database
Elements
button the selected format's references will be found in a newly opened
Find Database Elements window. If a range of characters is selected in
the line, it will be used as the value for the Field entry in the window
for the resulting search. |
|
Right mouse
menu for controls on views
The
Find
Database Elements tool can be called directly from any view by using
the right mouse menu when focus is on one of the controls in the view.
Select Find Database Elements from the right mouse menu and this tool
will be opened with a search set up and run for the field you had focus
on, including it's table. If you then wish to search for this field in
all tables, click the +T button. |
|
| Reports |
|
PDF files in Reports Specific pages of PDF files can be
set as the background to pages of a report.
See the
PIcture Tab of the report
Object
Properties Wizard
for more details. |
| Report Textblock Line
Height Textblocks
in a report will allow you to set the line height. A line height (in
pixels) adjustment field defaults to 0 and allows values between -8 and
30. See the Text Tab of the report
Object
Properties Wizard
for more details. |
|
| SQL Query Functions |
|
| Design Tables |
|
Design Table Tab for Structure Fields This
new tab, labeled All-F (for Formula) includes all the field properties
that relate to the structure of the field. |
|
| Views |
|
PDF files as View page background
PDF files can be set as the background to pages of a report.
If both the view and the PDF have more than one page, the page
background of each page of the view will be the corresponding page of
the PDF. This is very useful for presenting multi-page forms for data
entry where the data entry fields on each page of the form can be placed
in their actual location on the form. |
|
PDF View
Control
A control
that will display PDF files can be placed on any page of a view. The
macro command
SetPDFFieldImage
sets which PDF file to display. The standard controls are available for
scrolling, zooming, and paging through the pages of the document. This
can be used to create a page on a view that could have a list of PDF
documents in one browse control view and when each document is selected
in this control, it will display in a PDF control that occupies the rest
of the page. Use a record display macro in the browse control view that
presents the list of documents to contain the code that makes the
SetPDFFieldImage call. |
|
Jump To Field
in Record View
This menu option for records in a view now sorts the listed fields in
alphabetic order. If the view is in Record Mode, all fields on all pages
are listed, with the page number the field is on displayed after the
field name in the list of fields. In Browse Mode, only the fields on the
currently displayed page are listed. |
|
| DataChanges |
|
| Formula Language |
|
Hash (str, n)
(7.0) The
Hash function now supports 4 additional hash values returned as a
longint or an unsigned longint.
Use n = 0, 1, 2, or 3 for the long return values. These new hash values
return much better hash values than the Hash(str) value where there is
no second parameter. They are better in that the returned values are as
unique for the long integer value (which only requires 4 bytes of
internal storage) as the older real value (which requires 8 bytes of
internal storage). |
|
| Macro Language |
|
PDF files printed using PrintBitmap command The
PrintBitmap
macro command can print a range of pages from a PDF file. |
|
GetAttachDir
Returns the directory that is used by the
Image Attach
function. |
|
SetAttachDir
Sets the directory for the
Image Attach
feature to the specified directory. |
|
SetPDFFieldImage
(windowID, pdfField, PDFname) Sets the PDF in file PDFname to be
displayed in a PDF control on a view. |
|
TimeSeconds
(
) Returns a double value which is the number of seconds and milliseconds
since midnight January 1, 1970. This function is useful for computing
time intervals between two events. |
| ViewPDFBitmap (PDFname, viewMode, x, y, width, height) PDF
files can be opened in a PDF viewer window. The usual controls are
available for scrolling, zooming, and paging through the pages of the
document. |
|
SetLogControl
New codes are:
m
when used with M, only shows the divider line ahead of the level 0
macro (the macro directly triggered by the user). the divider line for
the macros called by the level 0 macro are suppressed. Use this to
provide a very compact Log file that can show the called macros in a
single spaced list. Using m will cause the complete suppression of log
entries for macros that you may not want to see in a summary log such as
Init view, Void Edit, Edit Record, Display Record, Field Enter, Field
Change, Field Exit, Find Mode, Record Mode, Add Mode, Edit Mode, Close
View, Report Section.
g
Suppresses the progress messages that DataChange formats may be
configured to display when they are running. This allows you to see the
messages |
|
| Miscellaneous |
|
Database Permissions
Delete Reports Permissions can be set to allow users to delete
reports independent of the Create Reports permission settings. |
|
Database Permissions
Manage Users See Controls who can see the Manage Users dialog. |
|
Database Permissions
Manage Users Lockout Controls who can use the Manage Users dialog
to Lockout users. |
|
External Program Access
Permissions Access
to the database by other software using the ODBC protocol can be
controlled according to the user group that the program uses when it
logs onto the database. This database property is set on the
Database
Settings
Control Tab by choosing Main Menu option
File |
Database Settings.
It can also be set using macro command
SetSystemControl
(ctl,val1,val2,val3,val4) with ctl=2. There are 3 settings:
val1=0 Allow access from All User Groups (Default)
val1=1 Allow access from Administrator Group Only
val1=2 Disallow access from All User Groups |
|
Performance
Enhancements
Several internal improvements have helped speed up operation of the
program. |
|
Database
Error Log
Error and information messages in previous versions have been written
into each user's daily LOG file in the user's C:\ADBMW program
directory. See
ADBMW.LOG Log
File
for details on these logs. A select few of the messages that are deemed
most important to be viewed are now written, for all users of the
database, into a collection file stored in the same directory as the ADB
database file itself. This file is named DatabaseName.LOG where
DatbaseName is the name of the database. For example, for the sample
database ADBMSAMP.ADB this file would be called ADBMSAMP.LOG and be
located in the same directory as ADBMSAMP.ADB. This file will contain
the most important error messages for ALL the users that use this
database. The contents of this file should be viewed in as editor such
as WordPad from time to time to see if anything out of the ordinary is
occuring with the database. Each message in the LOG file included the
user name, and date and time of the entry. Examples of the kind of
message that might show up in this file are: Secondary key errors if any
of the secondary keys are in error, file damage, memory corruption
errors. Possible remedial action that these messages would indicate as
appropriate would include running the
Validate DB
Structure
tool on the Tools menu option, and/or performing a
Pack Tables
on
the Database menu option. If all the message for a given time frame are
for only one user, when other users have been in the database during the
same period of time, this might indicate some localized problem with
that particular pc.
The mechanism that the program uses for deciding if a particular
message should be sent to this collection LOG file is if the message
contains the characters ^^^ (3 carat characters). If you wanted to
include your own messages in this file, you could do so by using a
command such as
WriteADBMLog
"^^^LOGON", UserName & " " & TimeStamp
in one of
your macros. This example if placed in the Open Database Macro would
write an entry for each user when they logged on to the database. |
|
Table Link
Handling
Some major internal enhancements have been made to the way the program
stores and works with the Table Links during program operation. You will
not see anything different when using the program, but the entire
operation of the table links and link lookups is now more robust. |
|
Upgrade now to take advantage of Advanced
DB Master's newest functions and enhancements.
Download and print
NEW63.EXE and
NEW62.EXE and
NEW61.EXE for a complete listing of the new
features. After you download the EXE, run it to unzip the DOC file, then
print it using Microsoft Word.
| Tools |
| Calendar (6.2) |
| Find in Macros (6.2) |
| Browse Editor (6.2) |
| Browse Delete (6.2) |
| Send E-Mail Menu Item (6.3) |
|
| Reports |
| Charts (6.1) |
| Right Justify Text (6.1) |
| SQL Left Outer Join (6.1) |
| HLML Reports (6.3) |
| RTF field references (6.3) |
| PDF file Reports (6.3) |
| Report Tables (6.3) |
|
| SQL Query Functions |
| IFSTR (6.1) |
| IFNUM (6.1) |
| COMPARE (6.3) |
| TOCHAR (s,mask) (6.3) |
| TOCHAR (n,'SINT') (6.3) |
| TOCHAR (n,l,p,'s') (6.3) |
| LPAD (s,n,c) (6.3) |
| RPAD (s,n,c) (6.3) |
| RECNUMBER ( ) (6.3) |
| INITCAP (s) (6.3) |
| INITCAP (s,2ltr,3ltr) (6.3) |
| String Concatenation (6.3) |
| IFNUM Enhancements (6.3) |
| IFSTR Enhancements (6.3) |
| |
|
| Design Tables |
| Copy Field Command (6.1) |
| Field Alias (6.1) |
| Four Digit Year (6.1) |
| Check Box Field (6.1) |
| Sort Button (6.2) |
| Link to Non-key Fields (6.2) |
| Multi-line text field case editing (6.3) |
|
| Views |
| Browse Column Widths (6.1) |
| Standard Label Font Colors (6.1) |
| Custom Label Fonts and Colors (6.1) |
| Drop List Query Parameters (6.1) |
| Drop Lists Filled Each Time (6.1) |
| Drop List Performance (6.1) |
| Browse Record #'s (6.2) |
| Browse Controls use Default Query (6.2) |
| Close View macro (6.3) |
| Display Record macro (6.3) |
| Void Edit macro (6.3) |
| Browse record buttons (6.3) |
| Custom Field Labels (6.3) |
| Droplists Enhancements (6.3) |
| Mulit-line text fields support case editing (6.3) |
| View Owner (6.3) |
| View Table (6.3) |
|
| DataChanges |
| Print DataChange Formats (6.1) |
| DataChange Formats Portable (6.2) |
| Add String Fields (6.3) |
| Character Delimited edit enhancements (6.3) |
|
| Formula Language |
| UGROUP (6.2) |
| INITCAP (6.2) |
|
| Macro Language |
| GetViewSelection (6.1) |
| SqlQuote (6.1) |
| GetError (6.1) |
| RedisplayView (6.1) |
| EditRecord SaveRecord etc. Enhancements |
| CalendarFloating (6.2) |
| CalendarModal (6.2) |
| FieldIsChanged (6.2) |
| FieldNameFromIndex (6.2) |
| GetBrowseColumnName (6.2) |
| GetCalendarDate (6.2) |
| GetFieldInfo (6.2) |
| GetTableInfo (6.2) |
| RecordStatus (6.2) |
| ShowHideField (6.2) |
| WaitBox (6.2) |
| PrintReport Enhancements (6.3) |
| GetDatabaseDir (6.3) |
| LoadTable Enhancements (6.3) |
| LoadView Enhancements (6.3) |
| SendEMail (6.3) |
|
| Miscellaneous |
| Database Window Choices Saved (6.1) |
| Saves 2 Prior Formats on Disk (6.1) |
| Security: Manage Users (6.1) |
| Internal Macros Format (6.2) |
| Pack Tables List (6.2) |
| Table Lists Alpha Order (6.2) |
| Double-click Macro for views (6.2) |
| ODBC Level 3 Upgrade (6.3) |
| Alphabetized Lists (6.3) |
| Clearing trapped users (6.3) |
| Database Permissions (6.3) |
| DB Manager Category Enhancements (6.3) |
| Import / Export Formats Enhancements (6.3) |
| HTMLHelp System (6.3) |
|
NOTE: These are the currently implemented
new features and enhancements. If there
is an enhancement that you would like to see in this release, please call us at
719-520-1555 to discuss it.
And there's more. So contact Macon
Systems, Inc. for further information and upgrade pricing.
... |
