Thanks Razzak - I did not mention that I am copying all of the unloaded .dat files to the current directory with the database.
All the data loads into the tables fine. The end result is all good, except for that one error message. Dayle Coxen Florida DOT (850) 410-5635 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Wednesday, February 09, 2011 4:11 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Issue LOADING table in 9.1 At 03:55 PM 2/9/2011, Coxen, Dayle wrote: >Hello all - > >I am having an issue LOADING a table in eXtreme 9.1. >I am unloading 21 tables in 6.5++ and LOADing them into a 9.1 database. >All of the 21 tables load OK. But one of the loads gives me an error. > >During the load process for the workneed table I get the error message: >"Constraint Error" "Invalid Estimated Time" > >I am unloading the table as follows: >OUTPUT c:\mms76dat\workneed.dat >UNLOAD DATA FROM workneed >OUTPUT SCREEN > >A trace shows the error is thrown on the "LOAD filename" line. > >The workneed.dat file that contains the commands to load the table is large. >In the R:Base editor, it contains 12,633 lines including the set commands >and the comma delimited data. There are 3673 rows in the loaded table. > >My goal is to automate the unload and load functions so the user will not >see any error. > >I tried: >SET ERROR MESSAGES OFF > RUN workneed.dat > RETURN > >Same result. > >Suggestions? Thanks in advance. Dayle, 01. Without knowing all details, it seems that you are UNLOADing the data in a different folder. Make sure that the exact folder does exist in path. 02. In your specific situation, when loading that file, you must specify the exact path and folder, when RUNning the file, with default database folder being a different one. Hope that provides you with some blue's clues ... Very Best R:egards, Razzak.
