Thanks Razzak. I had them unload just the offending table and I loaded it back here and found one Note field was truncated on the load (I suspect because of a bad length). I will have them input their unloaded data base as per your suggested code.
Dennis ***** At 09:45 AM 2/26/2004 -0500, you wrote: >At 09:18 AM 2/26/2004 -0500, Dennis Flemming wrote: > >>Rbase 6.5++ >> >>In a table with about 7000 rows, both Reload and Autochk find: >> >>Examining data in PARTS-ERROR- A row of data's length is too small. (1248) >>-ERROR- A row of data's length is too small. (1248) >> Rows: Active 6907, Deleted 32 >> >> >>>> >> >>After saving db, we rerun Reload and it "clears" the error. Reload says all >>is OK. But Autochk still finds the same error??? >> >>They have the default delimit char in some of their data (comma) and so I >>need to change the utility used to Input Structure and Data or it will not >>work properly. >> >>What's the affect of doing nothing? > >Dennis, > >Looks like the broken pointer. > >You can use R:Scope to fix that problem on the original, not on the >RELOADed version of the DB. > >I would also recommend the following procedure: > >DISCONNECT >CONNect dbname >SET NULL -0- >OUTPUT NewDB.ALL >UNLOAD ALL >OUTPUT SCREEN >DISConnect >RENAME dbname.RB? OldDb.RB? >RUN NewDB.ALL >CONNect dbname > >In reference to changing the DELIMIT character, as you know that >it separates a character, string, or items in a list used in >commands. Also it is used to separate repeatable parts of a >command. > >To change the DELIMIT Character: > >SET DELIMIT=NULL >SET DELIMIT=char > >Hope that helps! > >Very Best R:egards, > >Razzak. > > > Dennis Fleming IISCO http://www.TheBestCMMS.com Phone: 570 775-7593 Fax: 570 775-9797
