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 aFind 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.
|
|
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) |
|