I have figured out the problem with the ODBC not openning properly and
have found my UPDATE problem was not corrected. In case anyone is
interested here is what I found out.

If you try to change an item on the Allbase database that is NULL,
Delphi will tell you that someone else already has changed that record
and refuse to touch it.  The log file in ODBCSE indicates this:

98/06/23 23:35:23 072 Prepare[0]UPDATE [log in to unmask] SET
FACTOR_ACCT_NO=? WHERE GROUP_NO=? AND NAME=? AND MAIN_GP=? AND
FACTOR_ACCT_NO IS NULL  AND FILENAME=? AND UNIT_FACTOR=? AND
UNIT_TYPE=? AND TERMS_CODE=? AND STD_DISC=? AND SEASON_SALES=? A
ND SEASON_SHIP=? AND CURRENCY_CODE=? AND DATE_INVT=?
98/06/23 23:35:23 072 Allbase Prepare[0]UPDATE [log in to unmask]
SET FACTOR_ACCT_NO=? WHERE GROUP_NO=? AND NAME=? AND MAIN_GP=? AND
FACTOR_ACCT_NO IS NULL  AND FILENAME=? AND UNIT_FACTOR=? AND
UNIT_TYPE=? AND TERMS_CODE=? AND STD_DISC=? AND SEASON_S
ALES=? AND SEASON_SHIP=? AND CURRENCY_CODE=? AND DATE_INVT=?;
98/06/23 23:35:23 072 SetParams[0] nparam=13
98/06/23 23:35:23 072 Allbase SetParams[0]
98/06/23 23:35:23 072 [Allbase Warning]The data updated/deleted is in
the RC/RU transaction.  (DBWARN 2017)
98/06/23 23:35:23 072 Allbase Commit
98/06/23 23:35:23 072 FreeStmt[0]
98/06/23 23:35:23 072 Allbase Commit

I suspect the culprit is the Allbase Warning and that Delphi/ODBC
interprets it as an error of some kind.  There actually seem to be two
UPDATE statements in the log also one says "Allbase Prepare" the other
simply says "Prepare".  Note the item I'm trying to change is the
FACTOR_ACCT_NO.  It is now NULL and I want to change it to '00'.

Please, if anyone has any experience with this, we need some help.  I
don't want to put off the HP 3000 product for another year (it's now
been 2 years).

TIA
Mel Rees
CMT, Inc
[log in to unmask]
425-391-9450