Frank Schönheit - Sun Microsystems Germany wrote:
Hi Drew,
Anyone want to venture a guess as to what is going on?
Just a wild guess - what would happen if an error occurs during writing
the input line to the error file? (Don't know enough about Basic to say
whether this is a stupid question.)
Ciao
Frank
Howdy,
Well, I received another email from Dinabdu today...we found the missing
records.
The problem - performance.
What happened was that the program paused and he figure it was done, so
he opened the table saw 916 records and said..oh no. Closed Base and OOo
and contacted me. Anyway, I let him know that I had posted the message
here and told him it would be 2 todays or so before I got back to him.
OK - so he has been following along and realized that maybe it was just
the the program was getting slower...he started it over, waited about 5
minutes then left and did another task for about 2 hours and came
back...the program was this time finished.. How long, don't know -
longer then 5 minutes and shorter then 2 hours that is all he can tell me.
But when he opened the table 3,440 records. In the error file 6 records
- total records in the import file was 3,446. It;s nice when things
actually add up.
@marc - he did send me the error file to look at, and perhaps yes the
scrubber was being a little over zealous ..not sure, because of a logic
error - the file is holding the input records after the scrubber routine
finished with them, not as they where when read from the file...oh well,
it appears all the errors came from the final step before insert where I
handled a couple data type conversions from MSA representation to Base
representation and they all had the same error. A final field that held
an email address as a string with an opening double quote and no closing
double quote.
At that point he simply opened a data view window and hand entered the
data with copy paste for the varchar and memo fields, and just updated
the boolean fields, of the six records. So - now that he finally has all
his data in a table that duplicates the MS Access table we turn to
duplicating the actual logic in the MSA database - meaning a whole bunch
of queries, lots of which are New Table, Update or Delete style MSA
queries.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
