Razzak: Thank you very much. I will experiment with "ADD_MAPPING" in the meanwhile.
Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Friday, May 24, 2013 8:24 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Gateway Autonum Failure At 11:11 AM 5/24/2013, Bruce A. Chitiea wrote: >Razzak: > >Thank you very much for the exercises. > >My SHOW ZERO shows "ON" > >I've performed a set of controlled experiments with a set of source files: > > Opcashbalance.xlsx > Opcashbalance.xls > Opcashbalance.csv > >... generated from Excel 2013 >... containing only one worksheet >... with blank column 1 to accommodate the CASHBALID autonumber column >... with data starting on row 1 ... sourced sequentially from each two >folders: > > D:\00\gway > <database folder> > >... with your exercise code appropriately modified > >both exercises 01.RMD and 02.RMD fail to import data. > >The import dialog appears and is immediately overlain by a constraint >error >message: > > "Value for Column CashBalID Cannot be NULL" [OK] > "Value for Column CashBalID Cannot be NULL" [OK] > "No rows in table, INSERT a NULL row? [NO] > >There may be more clues, but through the blue, hard to view. > >Thoughts? And thanks. Bruce, My schedule and time permitting, I will send you my test files that were created to illustrate the proper method, as posted in my original reply. Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase
