 |
|
|
|
Next: R4 ds/dsi firmware-drivers de R4 Sdhc. R4 ultra, ..
|
| Author |
Message |
External
Since: Aug 28, 2006
Posts: 88
|
(Msg. 1) Posted: Thu Mar 05, 2009 10:22 am
Post subject: Error writing file - record not tagged with Formatted Memo
Archived from groups: comp>databases>paradox (more info?)
|
|
|
Greetings all,
A client is receiving a strange error with a Formatted Memo field "Error
writing file - record not tagged". This also causes a long delay in my app
trying to get the value - sometimes over 5 minutes, which causes the client
to think it is locked & they restart the app (very bad!).
The workaround is to wipe out this problem value, which fixes the problem
for the one record.
I'm writing a generalized script to fix every value. The script copies every
value to a memo variable then to a backup table, & sets the production value
to blank. The table will then be closed, giving an 'empty' MB file. A second
pass on the table then reverses this to restore all the values.
My question is, will the 'corrupted' value survive being copied to/from the
backup, or will it 'fix' itself (and/or become blank)? I'm hoping for the
'fix' option. The MB files are a mystery to me, so I don't know if the corruption
is in -how- the value is stored or is inherent in the value itself.
Looking at Bertil's buglist, this only shows an Sql problem, which we don't
use. Also, there isn't an opportunity to redesign this without formatted
memos, so I'd rather not have that discussion here.
TIA,
Jim Moseley |
|
| Back to top |
|
 | |
External
Since: Dec 04, 2008
Posts: 5
|
(Msg. 2) Posted: Thu Mar 05, 2009 10:22 am
Post subject: Re: Error writing file - record not tagged with Formatted Memo [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Jim Moseley wrote:
> Greetings all,
> Looking at Bertil's buglist, this only shows an Sql problem, which we don't
> use. Also, there isn't an opportunity to redesign this without formatted
> memos, so I'd rather not have that discussion here.
You talk about 'problem value' but don't identify what the value is - that
might be helpful to know.
Is the table damaged once the value has been assigned to the field? That may
be the answer to whether copying the data out and then back in will scrub the
data. Probably only way to tell is to try it.
Is this only happening on that one system? Can you reproduce it at your location?
Can't say that I understand what you are even dealing with, so no way I can
make a suggestion of any type.
--
---------------
Tony McGuire
http://www.lostlore.com |
|
| Back to top |
|
| |
External
Since: Nov 09, 2007
Posts: 110
|
(Msg. 3) Posted: Thu Mar 05, 2009 10:34 am
Post subject: Re: Error writing file - record not tagged with Formatted Memo [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
> My question is, will the 'corrupted' value survive being copied to/from
> the backup, or will it 'fix' itself (and/or become blank)?
unfortunately, there's no way to know.. you're better off killing that one
and/or replacing it..
--
Steven Green - Myrtle Beach, South Carolina USA
http://www.OasisTradingPost.com
Oasis Trading Post
- Collectibles and Memorabilia
- Vintage and Custom Lego Creations
Diamond Software Group
- Paradox Sales and Support
Diamond Sports Gems
- Sports Memorabilia and Trading Cards
"Jim Moseley" wrote in message
>
> Greetings all,
>
> A client is receiving a strange error with a Formatted Memo field "Error
> writing file - record not tagged". This also causes a long delay in my
> app
> trying to get the value - sometimes over 5 minutes, which causes the
> client
> to think it is locked & they restart the app (very bad!).
>
> The workaround is to wipe out this problem value, which fixes the problem
> for the one record.
>
> I'm writing a generalized script to fix every value. The script copies
> every
> value to a memo variable then to a backup table, & sets the production
> value
> to blank. The table will then be closed, giving an 'empty' MB file. A
> second
> pass on the table then reverses this to restore all the values.
>
> My question is, will the 'corrupted' value survive being copied to/from
> the
> backup, or will it 'fix' itself (and/or become blank)? I'm hoping for the
> 'fix' option. The MB files are a mystery to me, so I don't know if the
> corruption
> is in -how- the value is stored or is inherent in the value itself.
>
> Looking at Bertil's buglist, this only shows an Sql problem, which we
> don't
> use. Also, there isn't an opportunity to redesign this without formatted
> memos, so I'd rather not have that discussion here.
>
> TIA,
> Jim Moseley >> Stay informed about: Error writing file - record not tagged with Formatted Memo |
|
| Back to top |
|
| |
External
Since: Nov 22, 2006
Posts: 4
|
(Msg. 4) Posted: Thu Mar 05, 2009 10:39 am
Post subject: Re: Error writing file - record not tagged with Formatted Memo [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
If the formatting is important, you may be in trouble...
I've never been able to fix a memo field without exporting the table to text
and re-importing. This means removing all hard returns from memo fields
and losing any formatting in formatted memo fields. Of course, I've only
ever had this happen once. ChimneySweep wouldn't fix it; table repair wouldn't
fix it; making a new table and moving data (with query, table add, script)
wouldn't fix it. Only making a new table and importing the data from a text
file would fix it.
That said, I never saw the error message you report, so maybe it's something
other than corruption (or a different kind of corruption).
Maybe others have alternatives.
Liz
"Jim Moseley" wrote:
>
>Greetings all,
>
>A client is receiving a strange error with a Formatted Memo field "Error
>writing file - record not tagged". This also causes a long delay in my
app
>trying to get the value - sometimes over 5 minutes, which causes the client
>to think it is locked & they restart the app (very bad!).
>
>The workaround is to wipe out this problem value, which fixes the problem
>for the one record.
>
>I'm writing a generalized script to fix every value. The script copies
every
>value to a memo variable then to a backup table, & sets the production value
>to blank. The table will then be closed, giving an 'empty' MB file. A
second
>pass on the table then reverses this to restore all the values.
>
>My question is, will the 'corrupted' value survive being copied to/from
the
>backup, or will it 'fix' itself (and/or become blank)? I'm hoping for the
>'fix' option. The MB files are a mystery to me, so I don't know if the
corruption
>is in -how- the value is stored or is inherent in the value itself.
>
>Looking at Bertil's buglist, this only shows an Sql problem, which we don't
>use. Also, there isn't an opportunity to redesign this without formatted
>memos, so I'd rather not have that discussion here.
>
>TIA,
>Jim Moseley >> Stay informed about: Error writing file - record not tagged with Formatted Memo |
|
| Back to top |
|
| |
External
Since: Aug 28, 2006
Posts: 88
|
(Msg. 5) Posted: Thu Mar 05, 2009 10:50 am
Post subject: Re: Error writing file - record not tagged with Formatted Memo [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Tony,
>You talk about 'problem value' but don't identify what the
>value is - that might be helpful to know.
That's just it - once the field's value is corrupted, Pdox won't tell me
what it was. I can only tell it was corrupted by the long delay in getting
the value, and the error message.
>Is the table damaged once the value has been assigned to the field?
Table Repair shows the table is fine, no corruption.
>Is this only happening on that one system?
It has now happened at 3 different clients over the last year (that I know
of, out of ~1000 total). I can't reproduce it because I'm not sure what
is causing it in the first place.
So, my current goal is to just try to fix all values & see if that helps.
The latest client with the problem has started 'locking up' a couple of
times a day, so after my fix it should be quickly apparent if it had any
effect.
Thanks,
Jim Moseley >> Stay informed about: Error writing file - record not tagged with Formatted Memo |
|
| Back to top |
|
| |
External
Since: Mar 05, 2009
Posts: 1
|
(Msg. 6) Posted: Thu Mar 05, 2009 10:50 am
Post subject: Re: Error writing file - record not tagged with Formatted Memo [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Mar 14, 2008
Posts: 7
|
(Msg. 7) Posted: Thu Mar 05, 2009 11:31 am
Post subject: Re: Error writing file - record not tagged with Formatted Memo [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Mar 05, 2009
Posts: 1
|
(Msg. 8) Posted: Thu Mar 05, 2009 6:20 pm
Post subject: Re: Error writing file - record not tagged with Formatted Memo [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Thu, 5 Mar 2009 11:31:29 -0500, Jim Giner wrote:
> "record not tagged". Is that something you output from your application?
> I've never seen that message from pdox. Course I've never used formatted
> memos either.
That's what struck me. Formatted memos are rtf internally, where each
paragraph is (must be?) surrounded by start tags and end tags. Maybe a
paragraph lacks its start tags or end tags. That at least makes sense of
the error message.
--
Jim Hargan >> Stay informed about: Error writing file - record not tagged with Formatted Memo |
|
| Back to top |
|
| |
External
Since: Dec 04, 2008
Posts: 5
|
(Msg. 9) Posted: Thu Mar 05, 2009 6:20 pm
Post subject: Re: Error writing file - record not tagged with Formatted Memo [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Jim Hargan wrote:
> On Thu, 5 Mar 2009 11:31:29 -0500, Jim Giner wrote:
>
>> "record not tagged". Is that something you output from your application?
>> I've never seen that message from pdox. Course I've never used formatted
>> memos either.
>
> That's what struck me. Formatted memos are rtf internally, where each
> paragraph is (must be?) surrounded by start tags and end tags. Maybe a
> paragraph lacks its start tags or end tags. That at least makes sense of
> the error message.
>
> --
> Jim Hargan
And my question is whether the data in these memo fields, or some of it, is
from copy/paste from Internet pages or other applications.
A LOT of garbage, that the user can't see, is captured along with text when
doing copy/paste of text from Internet pages.
--
---------------
Tony McGuire
http://www.lostlore.com >> Stay informed about: Error writing file - record not tagged with Formatted Memo |
|
| Back to top |
|
| |
External
Since: Aug 28, 2006
Posts: 88
|
(Msg. 10) Posted: Thu Mar 05, 2009 6:41 pm
Post subject: Re: Error writing file - record not tagged with Formatted Memo [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Tony,
>And my question is whether the data in these memo fields, or some of it,
is
>from copy/paste from Internet pages or other applications.
>
>A LOT of garbage, that the user can't see, is captured along with text when
>doing copy/paste of text from Internet pages.
Good guess. One of the biggest uses of the formatted memo fields built into
the app is to grab directions from web pages, although I extract the raw
html instead of cut/paste. Can't guarantee that the users don't do it manually,
though.
I've started working with Rodney's RTF-to-HTML converter, since I'm not fluent
in RTF. Hopefully that will point to problems.
Thanks,
Jim Moseley >> Stay informed about: Error writing file - record not tagged with Formatted Memo |
|
| Back to top |
|
| |
External
Since: Dec 04, 2008
Posts: 5
|
(Msg. 11) Posted: Fri Mar 06, 2009 8:32 am
Post subject: Re: Error writing file - record not tagged with Formatted Memo [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Jim Moseley wrote:
> Tony,
>
>> And my question is whether the data in these memo fields, or some of it,
> is
>>from copy/paste from Internet pages or other applications.
>> A LOT of garbage, that the user can't see, is captured along with text when
>
>> doing copy/paste of text from Internet pages.
>
>
> Good guess.
> Jim Moseley
Not exactly a guess. I've seen it many times.
I believe that if you write the captured text to a textstream, then read back
out using a text stream, you get rid of the 'bad' characters.
Might be able to do this just copying from a memo var to a string var during
the capture process.
One of the worst things that happens during this exchange is that web pages
can contain NULL characters. Which trash fields of data. Even chr(13) or
chr(10) can make some data appear to say 'new record' when it isn't intended.
--
---------------
Tony McGuire
http://www.lostlore.com >> Stay informed about: Error writing file - record not tagged with Formatted Memo |
|
| Back to top |
|
| |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
