Quadrant Systems RASWIN - Release Notes 2022
1.0.5996 2025-09-10 12:00
October 19,2022
-
Changes were made to the INQUIRY screen to speed up retrieval of records based
on the selected criteria.
The option to PRINT SCREEN has been removed because generating the text file
needed to do this was performing very poorly and causing the query function to
take too long to return the requested results, especially when more than 100
records were retrieved. If you
need to print the contents of the screen use the 'SAVE TO EXCEL' option, then
print from EXCEL.
-
A new option to search the PAYER_NAME field using a
"SOUNDEX-based search."
SOUNDEX is a phonetic algorithm for indexing names by sound, as pronounced in English.
The goal is for names that sound alike but are spelled differently to be encoded to the same SOUNDEX code so that they can be matched despite minor differences in spelling.
You will find a new check-box labeled "Use SOUNDEX Search on Name" at the bottom of the inquiry screen. If you check this, and enter a name in the NAME search box near the top of the screen, RASWIN will convert the entered name to a SOUNDEX code. In
the screen sample below, you can see sample results of such a search.
This can be especially helpful when the spelling of a name is not clear. For example,
SMITH, SMYTH, SMITHE, SMYTHE, and so on.
-
Several new tables have been added to document database statistics,
indexes, structure, etc. These will automatically be created the first time
the updated RASWIN program is started, and regenerated when TABLE MAINTENANCE or the 'EXPORT TABLE DATA'
function is performed. They can be helpful to QUADRANT SUPPORT when trying to
resolved issues that arise when upgrading from older versions of RASWIN.
No user actions are necessary for these tables to be created. The list of tables
is shown below:
-
Over the years various indexes have been created as updated versions of the
program have been released. In some cases, this has resulted in duplicate indexes on the same table/field combination. A new function has been added to the
FILE-->MAINTENANCE MENU option.
When you click on the option shown above, it will display the following screen.
When you click on the REBUILD INDEXES button, it will go through all the tables
in the database and delete obsolete indexes and recreate them using standardized
naming conventions. Primary key indexes will be created using this format:
"[table_name]_PK". Other indexes (non-primary key) will be created using this format:
"[table_name]_[field_name]_PK".
When this process is completed, the list will be redisplayed with the updated index names.
SQL Server Indexing is pretty fast, but for larger databases you might expect this
reindexing process to take a little while.
Running this process will remove 'duplicate' indexes (with a few exceptions) which
serve no purpose and place an unecessary burden on SQL Server to keep them updated.
Also, recreation of indexes may
place 'locks' on individual tables which could interfere with routine transaction processing, so it will be best to do this process when other users are not actively
processing transactions.
July 18, 2022
-
Revisions were made to the CASH RECAP REPORT.
Under some combinations of selections some totals in the different report sections
were not correct. The error was due to the procedures RASWIN uses to calculate total
change disbursed. This has been corrected.
In cases where the user is not selecting full transaction details, the
program was still running through the logic to scan each transaction. If the report
contains a very large number of transactions this could take long time to process.
This has been changed to skip the full transaction scan process and can speed up the
final display of the report tremendously.
July 13, 2022
-
A logic error in the code that filters the list of tables to be exported via the
File-->Export Table Data menu option was preventing inclusion of a few tables. This
has been corrected.
-
The Table Maintenance Function has been enhanced with new logic to ensure that a
TRAN_CODE that has any existing history can't be changed. It already had logic to
ensure that it could not be deleted.
If you attempt to change or delete a TRAN_CODE as message will appear as shown
below.
Likewise, the same applies to both the CASHIERS and PMTTYPES tables.
If you must change a TRAN_CODE, payment METHOD, or USER_ID, it can be done, but
contact Quadrant for help. We can provide a script to change all the affected tables
and previous transaction entries.
March 9, 2022
-
The inquiry screen has been improved to permit you to drag and drop one or more
column totals to the gray area just above the column names. When this is done, totals
will be shown for all the items in the group.
The screen also now displays the total of the items that were included in the inquiry
along with the count of items in the top right portion of the screen.
-
RASWIN has been modified to allow you to adjust the column widths on the Receipt
Summary screen as opposed to setting them to fixed widths. When you adjust the width
of a column by dragging the bar between the column names left or right, the program
will save the current widths of all the columns. The next time the screen is
displayed, it will read these settings and set the columns to the previously saved
widths.
-
The REGSET.EXE program (used to set the register number) has been modified and
renamed to
REGSET_NEW.EXE. The new version will be installed automatically when you
update your software to the latest version. As part of the setup process the old
version will be deleted.
It is used to adjust the LICENSE table to have additional fields to track the
last user to login, the last login date/time, current program version, and the
Windows WSID. It will automatically make these changes and then when you set the
register
number, it will update the table. When RASWIN starts, it will update the new fields
as well.
Jan 11, 2022
-
A small change to the setup program has been made which installs a small file
indicating which version of Windows (7,8,10) the workstation is running. The RASWIN
program was having some trouble detecting this information due to changes in some
system API calls made by Microsoft. The install/setup program correctly sees the
Windows version and allows RASWIN to properly know the version.