Embedded browse table pointer

[Peter.Greulich]

I have an app where I copied a bunch of forms w. embedded browses to new identical tables. But when I look at "browse properties/setup/primary table" the value is blank. When I click the dropdown and select the table A5 immediately crashes. The browse seems to work okay w/o assigning the table, but not browse "events". I need that event code to work. Anyway, is there a trick anyone found to set the browse to the table? Recreating these browses from scratch is a big job.

[MoGrace]

Re: Embedded browse table pointer

Have you tried adding one of the browses to the control library? If the table is the same, you ought to be able to drop the control on the form. You would still have to delete the original browse first when you edit the form. Not saying it will work, since I haven't tried it...

[Peter.Greulich]

Re: Embedded browse table pointer

Robin,

How do I add the embedded browse to a control library?
What's a control library?

[aschone]

Re: Embedded browse table pointer

Just for fun try converting the data dictionaries containing the forms in question to tables.

If the form is based on a set then:
<file>.set -> <file>.dbf
<file>.sem -> <file>.fpt
<file>.sex -> <file>.cdx

If the form is based on a table then:
<file>.ddd -> <file>.dbf
<file>.ddm -> <file>.fpt
<file>.ddx -> <file>.cdx

add the <file>.dbf to a test database and open it. The code for the form is stored as a memo field. Might be able to locate the area that needs to be changed and manually add it. Once done change the extensions back and test.

I recommend doing this with back up copies and not your actual live copy. Good chance you can make the data dictionaries go splat.

I once had to do this to correct several sets that were copied from one directory to another however the sets decided to maintain absolute path information instead of relative paths. So converted the set data dictionaries to a table and made the needed change.

[Al Buchholz]

Re: Embedded browse table pointer

Just for fun try converting the data dictionaries containing the forms in question to tables.

If the form is based on a set then:
<file>.set -> <file>.dbf
<file>.sem -> <file>.fpt
<file>.sex -> <file>.cdx

If the form is based on a table then:
<file>.ddd -> <file>.dbf
<file>.ddm -> <file>.fpt
<file>.ddx -> <file>.cdx

add the <file>.dbf to a test database and open it. The code for the form is stored as a memo field. Might be able to locate the area that needs to be changed and manually add it. Once done change the extensions back and test.

I recommend doing this with back up copies and not your actual live copy. Good chance you can make the data dictionaries go splat.

I once had to do this to correct several sets that were copied from one directory to another however the sets decided to maintain absolute path information instead of relative paths. So converted the set data dictionaries to a table and made the needed change.

1. When I do that type of rename (and I do), I do it in another directory and another workspace.

2. If the set is pointing at the wrong tables, use the utilities to redirect to the proper tables.
control panel (tables/sets) - right click the set - utilities - repair set - step through each table to keep or reset the table location.

[preston2]

Re: Embedded browse table pointer

Is this in the same app Peter?

[Peter.Greulich]

Re: Embedded browse table pointer

Al, it's a table, not a set.

Preston, same app as what?

[preston2]

Re: Embedded browse table pointer

Preston, same app as what?

You said

I have an app where I copied a bunch of forms w. embedded browses to new identical tables.

So are the identical tables in the same app as the bunch of forms with embedded browses you copied them from?

[Peter.Greulich]

Re: Embedded browse table pointer

Oh. yes, it's the same app.

[preston2]

Re: Embedded browse table pointer

Ok. I have done what you are trying to do. I will try and go back and see how I did it.

[aschone]

Re: Embedded browse table pointer

We are now off topic :(

2. If the set is pointing at the wrong tables, use the utilities to redirect to the proper tables.
control panel (tables/sets) - right click the set - utilities - repair set - step through each table to keep or reset the table location.

I originally tried to use the built in tools and was unsuccessful in effecting the correction I needed.

[MoGrace]

Re: Embedded browse table pointer

Re: the Control Library

Open the original form in design mode
Open the Toolbox
Highlight the browse and right click
Select 'Add selected controls to control library' (at the bottom of the list)
Name the saved control something like Brw_yourformname or Brw_tablename

Open the form from the copied files
delete the existing browse and save the form
open the Toolbox and click on the Control Library (selection may not appear until you have a saved control?)
click on the new Brw_* control
draw the browse onto the form and your browse will appear.

[Peter.Greulich]

Re: Embedded browse table pointer

Thanks Robin.

[Finian Lennon]

Re: Embedded browse table pointer

My situation is a little bit different, although the objective is still to copy an embedded browse that will take hours to re-create. I've followed Robin's instructions on adding the brows to the control library. However, whenever I try to add the browse from the control library to a different form , I get a browse containing all the table fields, not the designed browse I added. The source form is based on a set. Does that make a difference? The browse only has fields from one child table.

[MoGrace]

Re: Embedded browse table pointer

Hi Finian,
I don't know if I ever tried it with a set or not. I think an Xd browse might be a better choice for a set. It would be interesting to see if that code could then be embedded into a form...although I have had pretty good success getting the Xd itself to offer much of what I would use the form for. Things like searches, browse buttons, double click events, etc - and you can roll them up!

xdbrws_20160615.jpg

I'm working on a feature that will add a bitmap only button to the column title and when pushed displays a text box for a var on top of the column title to do a quick find in that column on depart and uses the current sort order. It hides after the search so the column title can still be sorted again - and it displays both the sort_icon button and my button. (An idea I got from Mike Wilson here - and also from a peek at WinDev)

ps: In the meantime, if you are only displaying fields in the browse from one table, why not copy the browse to that table, then you should be able to add it to the control library.