Thank you for all the detailed instructions! I will try this tonight. I have
to transport some rescue dogs during the day. I will let you know how it goes.
Patti
From: MikeB <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Saturday, February 28, 2015 7:42 AM
Subject: [RBASE-L] - RE: phantom field on a form
I wouldn't muck with the sys_forms3 table unless you make a backup copy of the
form first and just mess with the backup or the original ONLY.
Your form MUST be saved UnCompressed or you will be unable to edit the text
description of the form in the SYS_DATA column.
First you should have made note of both the object type and its componentID
from the object list in the designer. If it did not have a componentID, access
the property page of the object from the object list and assign it one, maybe
"PHANTOM" would be appropriate :) and it will make the work simpler to assign
it a unique componentID in case your offender is a just an accendental copy of
another object (which it likely is since the eep firing is the source of the
discovery).
When you scroll down through the description, notice the indentation of the
objects from the left. Objects that have an object above and to the left in
indentation are container objects that hold it.
Anyway, just shift f8 and do a search for the objects componentID. Scroll or
mouse up to the object type. The line will begin with "object" followed by the
type of object that it is named under the covers for RBase internal use.
Everything from the beginning of that line down to the first "end" that is the
same number of spaces from the left as far as indentation is concerned is the
description of the object.
Highlight and DELETE those lines, leaving no trailing spaces or empty lines.
Save and exit and you should be ok.
You of course would have had to f4 to edit the data, but I would not do that
until you have located the exact area to avoid any accidental key touches while
finding the offender.
HTH
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Patti
> Jakusz
> Sent: Saturday, February 28, 2015 1:15 AM
> To: RBASE-L Mailing List
> Subject: [RBASE-L] - RE: phantom field on a form
>
> Hi Javier,
> I am mostly finished with copying and putting it on a new form. But I
> will try the sys_forms3 thing tomorrow anyway. Just double-clicking in
> Object list and hitting delete didn't work. I tried moving it to
> somewhere where I knew I could see it using properties, but that didn't
> work.
>
>
> But now that I moved it to a new form, some of my fields that had
> defaults are working - not all of them, but I guess if only half of my
> fields default to what they're supposed to, I should be glad.
>
>
> I'll let you know how it goes. But I won't be trying it until tomorrow
> night.
>
> Patti
>
>
> ________________________________
>
> From: Javier Valencia <[email protected]>
> To: RBASE-L Mailing List <[email protected]>
> Sent: Friday, February 27, 2015 11:11 PM
> Subject: [RBASE-L] - RE: phantom field on a form
>
>
> Mike,
>
> I posted the information below in a previous post but It seems to have
> gotten lost in the interwebs... :( Hopefully this one makes it...
> ==================
> Patti,
>
> There are several way you can solve your problem.
> First, backup your form.
> Second, back up your form.
> Next, open the object list and find the item you want to delete, even
> if you don’t see it on the screen, select the field on the object list
> and press the DELETE key and your field will be gone. If the wrong
> field is deleted, restore the form from the backup and start again.
> The other way is more complicated and involves editing the SYS_FORMS3
> table.
> On the R:Base Navigator select System Tables, and the double click on
> SYS_FORMS3. A browser with all your form will open. Make sure you are
> in the editing mode, select your form and the double click the Sys_data
> column. Provided your form is not encrypted or compressed the R:Base
> Editor will open with all the code for the form. If the BLOB editor
> open, then your form is encrypted or compressed and you will need to
> change to the normal mode.
> You can find the object your are looking for by using the SEARCH
> button. Once you find it, It will have a bunch of data and a part of it
> will look like this:
>
> object VarLabel14: TVarLabel
> Tag = 39474034
> Left = 179
> Top = 397
> Width = 68
> Height = 16
>
> Of course the Object will reflect the type you are looking for. Change
> the Left and Top coordinates to say 10 and 10 so it shows on the upper
> left hand corner of the form. Exit the grid, save it, and now your
> ghost object should show up on your form.
> While looking at the code, you can probably find the repeated EEP. Very
> powerful tool but not for the faint of heart. I have used it in the
> past to find code that I could not find otherwise and for global
> conversion of objects to their corresponding enhanced versions before a
> right click upgrade was available.
>
> Again, make sure you back up your form before doing any work so you can
> always restore it to its original condition
> ==================
> Javier,
>
> Javier Valencia, PE
> O: 913-829-0888
> H: 913-397-9605
> C: 913-915-3137
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of MikeB
> Sent: Friday, February 27, 2015 9:52 PM
> To: RBASE-L Mailing List
> Subject: [RBASE-L] - RE: phantom field on a form
>
> If you were more experienced you could edit the form description
> directly in the sys_forms3 table and remove the code segment for the
> field description.
>
>
>
> > -----Original Message-----
> > From: [email protected] [mailto:[email protected]] On Behalf Of Patti
> > Jakusz
> > Sent: Friday, February 27, 2015 8:34 PM
> > To: RBASE-L Mailing List
> > Subject: [RBASE-L] - RE: phantom field on a form
> >
> > Yes, I will have to bite the bullet and start. I have to select them
> > individually, so I don't pick up the phantom field. And then the
> > field order gets screwed up when you copy them to a new form. And
> all
> > the radio buttons need fixing. All the variables. Just a couple of
> > hours I didn't need to waste.
> >
> > Thank you for your suggestions though.
> >
> >
> > Patti
> >
> > ________________________________
> >
> > From: Dan Goldberg <[email protected]>
> > To: RBASE-L Mailing List <[email protected]>
> > Sent: Friday, February 27, 2015 6:22 PM
> > Subject: [RBASE-L] - RE: phantom field on a form
> >
> >
> > Try to select them and copy them in a new form.
> >
> > Dan Goldberg
> >
> > From: [email protected] [mailto:[email protected]] On Behalf Of Patti
> > Jakusz
> > Sent: Friday, February 27, 2015 2:50 PM
> > To: RBASE-L Mailing List
> > Subject: [RBASE-L] - RE: phantom field on a form
> >
> > It took about 15 hours to create the report. I'm hoping there's
> > another solution.
> > Patti
> >
> > ________________________________
> >
> > From: jan johansen <[email protected]>
> > To: RBASE-L Mailing List <[email protected]>
> > Sent: Friday, February 27, 2015 5:13 PM
> > Subject: [RBASE-L] - RE: phantom field on a form
> >
> > Patti,
> >
> > Sometimes weirdness happens and the only way to fix is start over.
> > Just re-create the form.
> >
> > Jan
> >
> >
> >
> > -----Original Message-----
> > From: Patti Jakusz <[email protected]>
> > To: [email protected] (RBASE-L Mailing List)
> > Date: Fri, 27 Feb 2015 22:06:45 +0000 (UTC)
> > Subject: [RBASE-L] - RE: phantom field on a form
> >
> > I could only find one of the fields that way. The other one has
> > coordinates that are nearby. When I select it in object list, no
> > field is highlighted by the dots on the form. I'm looking right
> where
> > the field should be. When I click in object list and hit delete on
> > the phantom field, nothing happens.
> >
> > Patti
> >
> >
> >
> >
> > ________________________________
> >
> > From: "Richardson, Jeff" <[email protected]>
> > To: RBASE-L Mailing List <[email protected]>
> > Sent: Friday, February 27, 2015 4:57 PM
> > Subject: [RBASE-L] - RE: phantom field on a form
> >
> > Regarding the removal of the unwanted field, I can select any form
> > object from the object list with my mouse (blue dots appear around it
> > when I do so, just like as if I clicked directly on the object) and
> > then when I hit the delete key on the keyboard… poof, it’s gone.
> >
> >
> > From: [email protected] [mailto:[email protected]] On Behalf Of Patti
> > Jakusz
> > Sent: Friday, February 27, 2015 4:41 PM
> > To: RBASE-L Mailing List
> > Subject: [RBASE-L] - phantom field on a form
> >
> > Hello again,
> >
> > I was tracing a form and noticed an eep was initiated 3 times on the
> > same field. I went into designer and only see one field (a
> variable)
> > that calls that eep. I looked at Object List and it appears twice.
> I
> > can click on the Object List and find one of them, but not the other.
> > I looked in Tabbing order and it only appears once.
> >
> > So I tried to use the left & top coordinates to find the phantom
> field.
> > The good variable is located Left: 159 and top: 292. The bad one is
> > Left: 161 and Top: 110. I found a field that is near that location
> > and moved it, but there's nothing underneath. I tried to catch it by
> > roping around that area and hitting delete, but it's still in my
> > Object list.
> >
> > I unloaded and loaded the form again, but it's still there. Is there
> > some other way I can delete that field? I still don't know why the
> > eep is executing 3 times either.
> >
> > Thanks,
> > Patti
> >
> >
> >
> >
>
>
>
