Embedded Browses on Form V9

[Brad Chesnut]

I've been on V9 now for a week and am finding it quite buggy. Here's my list specific to embedded browses ...

1. Embedded Browse on Form. The table will have logical fields with checkboxes. I'll pull up a group of records and need to check or uncheck the checkboxes for all the records which I'll do from the embedded browse since it's way faster. Not with V.9. I'll start working down the list and after the 3rd or 4th the records will start jumping sparatically. I'll try to click on a checkbox and it's a different record. Ugly stuff. No problem doing it from the form (avoiding embedded browse) one by one but what a waste of time. Plus this worked in v.8.

2. Embedded Browse on Form. A field will have a lookup on it. In Version 8 I could hit the first letter and it would autofill the field and then when I hit enter or the down arrow to the next record the autofilled information was retained. With version 9, the only thing that is retained is the letter I pressed. For example, the lookup has Mail, Fax or Letter as choice. I hit "L" and it auto-fills Letter. However, if I hit enter or an arrow it doesn't retain the auto-filled information leaving just "L" in the field. Not good at all. This works like it should on the form. Just not with an embedded form.

3. On many of my forms I will have a tab with a browse on it. This way I can see the individual record or go to the tab and see the next records in my list. I use this for sales callbacks ... excellent approach to making sales calls! When I'm on the form and use an index to find a record, if I go to the Tab with the browse, the record I'm on isn't on the list in the browse. It's generally the next record after the last record in the browse. Pain in the butt! Had this problem in V8 also. V7 worked like I want it to and like it should. When on a form and finding a record or when I'm on a record, when I go to an embedded browse the record I'm on should be the first record in the embedded browse with focus on it.

Here's a video to demonstrate the problem for #1 & #2 ... http://www.iamcllc.com/personal/Embe...ddedBrowse.htm. It's just 3 min's long.

I believe #1, 2, 3 are all bugs.

I deleted the old embedded browses and recreated them from v9. Didn't fix problem.

Thanks

[Bob Arbuthnot]

Re: Embedded Browses on Form V9

Brad,

Watched your video. I know putting that together took some time, but if you could go to the additional trouble to post up a sample data base for others to play with I think most (maybe all) of your issues can be resolved.

Bob

[Lance Gurd]

Re: Embedded Browses on Form V9

Hi Brad,

I do agree with Bob a sample is best.

Problem 2 can be resolved by making the lookups popup on entrance.

The others I have not had experience of.

[Mike Wilson]

Re: Embedded Browses on Form V9

Brad,
I do not see the things you are seeing with # 1 and #2 (see attached example). It frankly looks to me like you have a record On fetch, Onchange, OnSave or CanSave event filtering the browse and the "lost" check marks are really records replacing the ones in the browse order that have not been checked. That's my theory.

I do see that the moving to an embedded browse on a tabbed form does not show focus to the record present on the form. I see this happening only with the very first focus upon the embedded browse after navigation to a desired parent record. A work around would be placing this code in the tabbed objects OnTabChange event. The number 3 should be changed to the tab number that applies the tab where your embedded browse resides.

if parentform:tabbed1.tab_get() = 3
	topparent:pats_brws.refresh()
end if

[Mike Wilson]

Re: Embedded Browses on Form V9

As for the lookup, I am wondering what you have the field rules lookup linking field assigned as. Is it assigned to the field that has the value that you desire being captured, or is it a field that holds values that are single alphabet values? Check that.

[Brad Chesnut]

Re: Embedded Browses on Form V9

Mike,
I downloaded and looked your sample over.

In Visits, the lookup worked fine. So I went to investigate. You did a database lookup. So I took your sample, in s_visits changed tx_act to a simple lookup and it's doing what I documented above. This leads me to believe that the problem arises with a "simple" lookup. I found this consistent my database too. Works like it should with "table lookups" with the problem with "simple lookups".

However, when I changed the record and used the down arrow to go to the next record in the embedded browse, it jumped again and didn't take me to the next record. I ended up on some other record toward the bottom of the list. I wonder where this "jumping" is coming from which is the problem I'm having as stated in #1?

[Brad Chesnut]

Re: Embedded Browses on Form V9

Adding to #1, I created a brand new form in v9, put a tabbed section on it and added a single embedded browse to it with 8 fields in the browse. That's all.

When I change ANY field (checkbox, manual fill or lookup) one record after another using the down arrow to go to the next record, it sends my focus to the last record after about the 2nd or 3rd record.

My set I'm using is (all are one to one, no one to many links) ...

List
|- Memos
|- Agency_Info
|- HW_SW
|- Marketing
|- Cust_Info

There are no filters or sorts setup in the Set.

I did a database compact to just make sure everything was good. My table has 87,000 records in it.

Works fine in V8. Don't understand the problem with v9.

[Brad Chesnut]

Re: Embedded Browses on Form V9

Okay, still testing.

I did a Tabbed Section and embedded browse on just a dbf and not a set. In this layout it worked fine. No jumping around. So the problem is in sets.

[Tom Cone Jr]

Re: Embedded Browses on Form V9

As others have noted a sample from you illustrating the problem(s) would be a big help explaining why you see these behaviors and others do not.

[Brad Chesnut]

Re: Embedded Browses on Form V9

Tom,
That's why I did the video. You can watch the video and see exactly what I'm talking about.

My database has 87,000 confidential records in it. I provided as much details as I can think of. What else would you suggest?

[Tom Cone Jr]

Re: Embedded Browses on Form V9

The usual. A sanitized sample database that illustrates the behavior but doesn't contain any proprietary or personal information. Wouldn't need more than a couple dozen records in each of the related tables, I should think.

[Brad Chesnut]

Re: Embedded Browses on Form V9

Well, to add to this thread, from further investigating and after installing the most current patch ...

I created a new form. I put a single embedded browse on it, nothing more. In the browse I had logical fields from each of the tables that make up the set and one field with a lookup to test it.

List
|- Memos
|- Agency_Info
|- HW_SW
|- Marketing
|- Cust_Info

I then made all of the logical fields checkboxes. I started going down the list checking them. The field from the primary table (List) in the set worked fine. I went right down the list putting checks in the field.

Then I went to the next field which is part of an attached table (Agency_Info). Here the records started bouncing all over the place. I couldn't just go down the list. I even tried sorting the records, but the sort wouldn't hold. I had the same results for fields associated to HW_SW table, Marketing table and Cust_Info table. It appears this problem is isolated to fields that are part of a attached tables to a set and the primary table is immune from this problem.

I also added a browse with these same fields. No problem. I could click right down the list for all fields.

This indicates the problem is strictly with "embedded" browses on a form and for fields that are part of tables other than the primary table.

Then I tested to see if the lookup table worked yet. I went to the class field which is part of the List.dbf (primary table) and hit the letter "D" which automatically pulled in Dead into the field. But, when I hit enter what was left in the field was the initial D I put, not Dead which should've been left in the field.

I'm telling you, these are bugs in v.9.

[Mike Wilson]

Re: Embedded Browses on Form V9

Brad,
The latest patch a5v9_1884-3220 definitely has bugs. I reported one this morning. Go back to patch a5v9_1847-3216. The browse is far more stable in that release.

[Brad Chesnut]

Re: Embedded Browses on Form V9

Mark,
Thank you. However, I'm continuing to use V8 until these embedded browse problems get fixed. I was simply testing the latest patches to see if these problems had been resolved yet since I just can't go to V9 until they are.

Brad

[Brad Chesnut]

Re: Embedded Browses on Form V9

Of the initial 3 problems I listed in the first post, two of them are finally fixed. I've been on V8 all this time waiting because I just couldn't go to v9 until they were fixed. The only problem remaining is ...

1. Embedded Browse on Form. The table will have logical fields with checkboxes. I'll pull up a group of records and need to check or uncheck the checkboxes for all the records which I'll do from the embedded browse since it's way faster. Not with V.9. I'll start working down the list and after the 3rd or 4th the records will start jumping sparatically. I'll try to click on a checkbox and it's a different record. Ugly stuff. No problem doing it from the form (avoiding embedded browse) one by one but what a waste of time. Plus this worked in v.8.

Thank you Alpha 5 Team for fixing 2 of the 3 problems!!!

Here's the video I did showing the last problem still remaining to be fixed, #1 above.

Again, thanks for fixing #2 & #3.