To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Keys with @AM in them...
Trying to remember what I used to do in Universe to get rid
of these
Try having a select list of these records active, then going
into the editor, and see if it will let you edit each record,
and do an FD
Sent: Monday, April 07, 2008 3:50 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Keys with @AM in them...
uh, write the same program to construct the keys and delete them?
There are notes about finding these actual keys (to use in your fix
program) in one of my various UniData
Subject: RE: [U2] Keys with @AM in them...
LOL - I don't have the keys -- it was a one-off piece of code. But
I'll
write a program -- I was trying to do a 'select' and use AE to remove
the
keys -- but that just will not work...
-Original Message-
From: [EMAIL PROTECTED
UniQuery parser truncates at @FM, making it very difficult to display keys
with imbedded field marks.
Fortunately the ECL RECORD command displays keys in their brawb form.
Once you have found the key, you can write a small UniBasic program to
construct the key and delete or rewrite the
You could fix this by selecting all records EXCEPT those with keys
containing @AM in the key, copying them to a temporary file, and then
clearing the permanent file and copying from the temporary file back in.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
I open the file in a program, then use an internal select and loop readnext
Eg
Open 'file' to handle else...
Select handle
Loop
readnext key else exit
if index(key,@fm,1) then delete handle,key
Repeat
This simply moves a pointer thru the file and doesn't attempt a value
judgement of the
Trying to remember what I used to do in Universe to get rid of these
Try having a select list of these records active, then going into the
editor, and see if it will let you edit each record, and do an FD.
HTH
Drew
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Hi David,
My program wrote items with @AM in the key. (oops)
Now, I can 'select' the items, but I cannot get rid of them - they show as
non-existent.
Is there a way to remove/clean up these records, or will I have to clear
the
file and copy the good records back in?
The problem is that
uh, write the same program to construct the keys and delete them?
There are notes about finding these actual keys (to use in your fix
program) in one of my various UniData troubleshooting presentations - from
U2U, at least.
In the context of 'duplicate keys'.
the duplicates.
This advice comes with no warranty! Your mileage may vary. Good luck! ;)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wally Terhune
Sent: Monday, April 07, 2008 1:50 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Keys with @AM in them
If you are on UniVerse try setting the ALLOWMARKS flag in uvconfig, run
uvregen, restart UniVerse and then programmatically delete them (if you
generated the keys, hopefully you can recreate them),
Otherwise - (as others have advised) SELECT and copy what you want, blat the
file (CLEAR-FILE) and
11 matches
Mail list logo
