|
|
|
|
|
|
|
|
|
|
|
|
AutoSoft Systems |
| |
|
|
|
AutoSoft
Systems |
2 Round Hill
Court |
| |
|
|
|
East Greenwich,
RI 02818 |
| |
|
|
|
401.885.3631 |
| |
|
|
|
401.884.5653 Fax |
| |
|
|
|
|
|
|
|
|
|
|
|
401.996.3631
Cell |
| AMDG |
|
|
|
"Once you
know it, it's Easy!" |
autosoft@aol.com |
| Commercial and custom computer related products spanning the
areas of data acquisition and control, simulation and modeling, numerical
analysis, chemical process design and manufacturing management information
systems design. Founded in 1982. |
| We know Excel! Whenever possible, Excel
is the user interface, VBA is the programming language, ODBC connects to the
database of your choice. |
| Home |
About Us |
Literature |
Wire
& Cable |
Pharmaceutical
& Biotech |
Construction
Management |
Commercial
Products |
Custom Solutions |
| Contact Us |
Events |
Downloads |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
AMDG |
|
| AXIOM provides you with great power in the definition of quality
specifications for all parts. However,
as with many features in AXIOM, it is nearly impossible to generate a
user-friendly report of your quality specifications. As many of you already know, in order for
AXIOM to provide the flexibility to store user defined data, AXIOM
incorporates a technique that is clever, frustrated and convoluted. AXIOM stores user defined data in
open-ended character fields, where individual data is separated with pipes
"| and carrots "^".
Generating meaningful reports is elusive. A simple ODBC call reveals
fields that look like this: |
| 2536^.151^.167^.159^702|1969^^^LH^702|503^^^2.29^702|2515^^^PPFAM^702|541^^^PPF^702|2541^^^PARA^702|2546^25^^^701|2540^^^AM^702|2544^^^HELI^702|2523^^^RH^702|2548^25^^^702|2552^^^OUT^702|3355^^^^702 |
| YUCK! AutoSoft has
mastered the art of deciphering AXIOM's cryptic storage technique and a
simple mouse click generates a comphrehensive and legible Quality
Specifications Report: |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Configuration
could not be any simpler. |
|
|
|
|
|
|
Database
Query Information |
|
|
|
|
|
|
|
|
|
|
|
Parameter |
axs |
cis |
fin |
| Simply enter the ODBC settings for your
site to configure this program. The
ODBC table on this report is identical to the ODBC tables used on any SMART
report. |
DSN |
DSNaxis |
DSNcis |
DSNfin |
| HOST |
axiomcmc |
|
|
|
|
|
|
|
|
|
|
|
Port |
axssql |
cissql |
finsql |
| And away you
go! |
|
|
|
|
|
|
|
|
|
DB |
axs |
cis |
fin |
|
|
|
|
|
|
|
|
|
|
|
UID |
sysprogress |
| As with all AutoSoft solutions, source code is included. |
Password |
blank |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| AutoSoft Systems | 2 Round Hill Court, East
Greenwich, Rhode Island, USA 02818 | 401.885.3631 | Fax: 401.884.5653 |
Mobile: 401.996.3631 |
| This web page was last updated at 04/27/2010 06:58 PM and is
written in EXCEL! |
| AXIOM is a Trademark of Consona - USYS is a Trademark of Zumbach
- AutoSoft Systems is not affiliated with Consona nor Zumbach |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|