RBGXE 10.0.2.20731
WIN10
Error Message:
This in a GATEWAY IMPORT XLS routine which has worked without drama for
over two years. Relevant code:
DEBUG SET TRACE ON
SET ERROR MESSAGE 2038 OFF
DROP TABLE Import_ReserveFundBalance_tt
SET ERROR MESSAGE 2038 ON
CREATE TEMP TABLE Import_ReserveFundBalance_tt +
( TReserveBalanceDATE DATE NOT NULL, +
TReserveBalanceCASH CURRENCY NOT NULL, +
TReserveBalanceCD CURRENCY NOT NULL, +
TReserveBalanceTOTAL CURRENCY NOT NULL, +
TReserveWithdrawCUMUL CURRENCY NOT NULL, +
TReserveAddCUMUL CURRENCY NOT NULL, +
TReserveContribCUMUL CURRENCY NOT NULL, +
TReserveInflowNET CURRENCY NOT NULL, +
TReserveDailyCHANGE CURRENCY NOT NULL )
GATEWAY IMPORT XLS +
D:\00\GWAY\gway_ReserveFundBalance.xlsx +
APPEND Import_ReserveFundBalance_tt +
OPTION FIRST_ROW 2 +
|ADD_MAPPING TReserveBalanceDATE = A +
|ADD_MAPPING TReserveBalanceCASH = B +
|ADD_MAPPING TReserveBalanceCD = C +
|ADD_MAPPING TReserveBalanceTOTAL = D +
|ADD_MAPPING TReserveWithdrawCUMUL = E +
|ADD_MAPPING TReserveAddCUMUL = F +
|ADD_MAPPING TReserveContribCUMUL = G +
|ADD_MAPPING TReserveInflowNET = H +
|ADD_MAPPING TReserveDailyCHANGE = I -- FAIL
The Excel source data is [Number(2)], no dollar sign, no comma.
The Excel data has been scrubbed, checked, re-formatted; file deleted
and new one created three times; and the error repeated through one
unload/reload and ten follow-on tests.
Mystified. Thoughts? Course of action?
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 Mobile
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
