I just tested this using 7.5 and I get the same results!
So it appears there is something with those customers or their data that is
messing things up.
But when I cut and paste the data in the examples I do not see anything strange.
Thanks
Marc
From: Alastair Burr
Sent: Wednesday, April 28, 2010 3:24 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Another Strange problem
Marc,
What I tend to do in situations like this is to open the table/s in the data
browser and sort each column in turn so that I can check top and bottom for
"oddities".
Depending on the number of rows you could also scroll down through the table
looking for the odd flash of a row where the data is different. If you stop
scrolling quickly you can go back slowly and see what the problem is. I have
even been known to wedge the [Down Arrow] down to save my fingers!!
It might sound like a lot of work but it's not as time consuming as it might
appear.
Make sure that your null is set to -0- and adjust the size of the text to suit
your capabilities - bigger might be a bit slower but something might catch your
eye more obviously.
Good luck,
Alastair.
From: MDRD
Sent: Wednesday, April 28, 2010 8:55 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Another Strange problem
This is getting the best of me. I cut part of the Output files to show the
before data and after data.
At this point I am afraid to update any of these users.
Even if I take my clean DB Unload the data Using Column, delete all my data,
then run the file to load the tables I get this new data in the table. So in
this case the DB is an exact copy
I am trying to load the data back into.
Original
19000',10/04/1989,'Y','000000000','F','5','S',,'2',,,,'1','N','Y','N','IN',+
after Load
19000',10/04/1989,'Y','000000000','F','5','S',,'2',,,'000000000','1','N','Y'+
Any other suggestions,
Marc
From: A.G. IJntema
Sent: Wednesday, April 28, 2010 1:00 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Another Strange problem
Maybe you can do it in another way. This is the way how I have done it
succesfully several times
First I define per table a variable with all the columns in it , which you
like to convert
-- CAO
SET VAR V_CAO_COL =
'CAO_ID,JRTL_ID,CAO_volgnr,CAO_mnd,CAO_pro,CAO_vb,CAO_min,CAO_max'
Open old database
Then unload the data as ascii
-- CAO
OUTPUT CAO.PDN
UNLOAD DATA FOR CAO USING &V_CAO_COL AS ASCII
OUTPUT SCREEN
Open new database
To be sure the new table is empty I run the statement:
DELETE ROWS FROM CAO
Finally the data are loaded into the new table as ascii
SET SEMI=NULL
SET SEMI='^'
LOAD CAO FROM CAO.PDN USING &V_CAO_COL ^ NOCHECK ^ NONUM
SET SEMI=NULL
SET SEMI=';'
In this way you are in control of the conversion and you can add some checks
and balances in the routine.
For instance count the number of rows in the old and new table, you easily
can avoid calculated fields and so on .
With defining the columns as a variable you are sure the structure is the
same in the old and new version.
Another advantage is you can optimize the new database in the way you like to
have it and in the end there is a clean situation, which is the same for
everyone.
The only thing you have to keep in mind is the order of loading the data into
the new database. PK's and FK's
Hope this helps.
Tony IJntema
From: rbas...@rbase
.com [mailto:[email protected]] On Behalf Of MDRD
Sent: woensdag 28 april 2010 0:00
To: RBASE-L Mailing List
Subject: [RBASE-L] - Another Strange problem
Hi
I am trying to update my users to 7,6 and I thought I would
Unload Data for Table Using ..... for all the data tables then load them into
a blank 7.6 DB.
Some of my users haven't updated my app for years and and I thought this
would be a good way to make sure they had the exact
same structure I had. I have dozens of out of state users.
I did not get any errors but to double check the data I did a Unload All on
the original DB and the new 7.6 DB
after I loaded the data. Then I compared the 2 files to see if the data
matched and it did Not?
In the first example you can see the 2 was changed to a 3... very strange.
In the second example, don't worry I changed the name and numbers with fake
data
But you can see on the second line a -0- was replaced with a SS number from
the first line
You can see that they have "dell" for the name so I wonder if that is the
problem. Also I noticed sometimes they have\
Smith, Jr in the last name on some customers but sometimes there is no
strange " or , in the data and the data after the
load is different.
This makes me real nervous about sending out my update.
neb',-0-,'244999999','3','N','N','N','IN',0,'Same','1','318 Valley Stream+
--- original file
neb',-0-,'344999999','3','N','N','N','IN',0,'Same','1','318 Valley Stream+
-- after Load
9444',-0-,11/12/1967,'Y','243089000','F','5','M','L','1','Sam O''dell',+ ---
original file
-0-,-0-,'3','N','Y','N','IN',0,'Eddie, Kryan','2','3400 Fixcraft Road','Char+
9444',-0-,11/12/1967,'Y','243089000','F','5','M','L','1','Sam O''dell',+
--- after Load
-0-,'243089000','3','N','Y','N','IN',0,'Eddie, Kryan','2','3400 Fixcraft Roa+
Any suggestions?
Marc
------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.814 / Virus Database: 271.1.1/2840 - Release Date: 04/28/10
07:27:00
