Gunnar: I do not know if it is a typo on your e-mail but delimit would normally be "," not "." , at leas in the US. I know some countries use "," instead of "." for decimals so you may want to use a different delimiter such as "|" Also, make sure to SET MESSAGES ON and SET ERROR MESSAGES ON to catch all the messages/error messages. You could also use TRACE to go one line at the time and pinpoint where you are having problems. You may also try packing the database before you do an UNLOAD, I found that PACK solves a lot of problems, particularly with indices. I know how frustrating debugging can be; on the other hand, it sure feels good when you find the cause and fix the problem. Don't forget Murphy's Law: 1. Anything that can go wrong, will go wrong 2. When something goes wrong, it will happen at the worst possible time And my favorite: 3. If nothing has gone wrong, you have obviously overlooked something Good luck and happy "bug" hunting... Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gunnar Ekblad Sent: Wednesday, December 11, 2002 2:53 PM To: [EMAIL PROTECTED] Subject: RE: Unload all/Reload/ Pack I have verified and verified and verified again I have suspected even some more settings like lineend and idquotes and in the process I got actually to learn Howe to utilize lineend in my application. So a good thing has come out of this But quotes is ' null is -0- and delimt is . and date is yyyy-mm-dd and time is hh:mm:ss checked double checked and checked again. ( -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Javier Valencia Sent: den 11 december 2002 21:09 To: [EMAIL PROTECTED] Subject: RE: Unload all/Reload/ Pack You may want to verify your setting, quotes, null, delimit, date and time formats, zero, etc. Sometimes this settings may be in conflict with stored data. Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gunnar Ekblad Sent: Wednesday, December 11, 2002 1:36 PM To: [EMAIL PROTECTED] Subject: RE: Unload all/Reload/ Pack You have some points here Thats why I allmost allways do a reload rather then a pack (except when I am lazzy), but recently I did a number of unload all and started a new db. For some tables I lost the data, I had to go back to the backup db and could recover the data (I used unload as asci and load). Eveything seams to be restored but I am the perverse that are worried since something went wrong who do I know that everything is right? Gunnar thanks Bernie -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bernie Corrigan Sent: den 11 december 2002 19:32 To: [EMAIL PROTECTED] Subject: Re: Unload all/Reload/ Pack At 06:24 PM 12/11/2002 +0100, you wrote: >Has someone a guidence? >1. If I do a pack I understand I take a chance on no power breakdown. True. >2. If I do a reload I should not have the risk of power breakdown but >have the same result as 1 obove. False. You have a better result. All tables are rewritten and some data problems can be cured. >3. If I do unload all then delete the database base an load it back, >that should be the same as 2 obove.!? False. You have a better result than RELOAD. The entire database is completely rebuilt and any corrupt data should become apparent. >4. If 2 and 3 and that does not give the same result what am I doing >wrong? Probably nothing. Sometimes they don't give the same result. How do you know the results are different? >5. I am mostly on DOS 1.862 (or Windows corresponding version) >Background: >1. I am doing conversion work from Glorious 2.11 to Dos version of today >waiting for the future win 7.0 to go Windows when happy days will >arrive. >Other minory ? that I can not answer! >1. Has someone an Idea where I can look for answers? >2. Has anyone an Idea what to look out four? >Not to worry! >1. Some 20 % of my application is running on 1.862 but I would be happy >to understand above subject before I Move remaining 80% from 2.11 > >??? From the Swedish Dinosaur of 2.11 world ??? >Gunnar > > > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
