NetTalk Central

Author Topic: Lookups returning to the wrong screen  (Read 3342 times)

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Lookups returning to the wrong screen
« on: December 18, 2010, 10:35:50 PM »
WindowsXP SP2 Clarion 6.3 Build 9056 Nettalk 5.06

I have an orderForm with a field StockItemID (call this form1)
The field is a string with a lookup onto a memory form (call this form2)
On Form2 I have 3 fields which are lookups used to limit a browse. (unfortunately I can't use drops because the tables being looked up are too large)
If I use any of these lookups they work fine but the system returns to form1 rather than form2 after each lookup
Is there any way to get the system to return to form2?
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11244
    • View Profile
Re: Lookups returning to the wrong screen
« Reply #1 on: December 21, 2010, 04:43:32 AM »
Please post an example Terry.

Cheers
Bruce

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Re: Lookups returning to the wrong screen
« Reply #2 on: December 21, 2010, 06:59:47 AM »
Hi Bruce. I have slightly modified example 33 to show my problem.
I have added a table List with a lookup which requires the alias number in one of the fields.
If you run the WebApp
Select My Test
Insert
enter any name in last name
use lookup button on update list form
Use lookup button to select a Mailbox
Select Mailbox 9 (Charles)
The app returns to List Form (there is no value in the alias number field) rather than the memory form where a filtered browse of aliases should appear.
If you click the lookup button again you will see the filtered browse.
Select any alias from the filtered browse and you return to the update list form again with the correct information in the alias number field.

What I want to avoid is the first return to the Update list
Unfortunately the tables I want to use to filter the browse are pretty large so A drop list doesn't seem to be practical.


[attachment deleted by admin]
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11244
    • View Profile
Re: Lookups returning to the wrong screen
« Reply #3 on: December 21, 2010, 11:01:13 PM »
Hi Terry,

ok, I see what you mean, you have a lookup, on a lookup.

One small bug in your example (which didn't affect what you were showing) was that the loc:MailBox field on the FormMemory_Mailbox procedure should "reset" the AliasBrowseControl field.

If that is on, and the Lookups are done in _popup_ mode then it works.

In page mode it doesn't work because the lookup settings are not re-entrant. I'll look into that, but it's quite a big change. Would your system work with the lookups in popup mode?

cheers
Bruce


terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Re: Lookups returning to the wrong screen
« Reply #4 on: December 21, 2010, 11:19:38 PM »
Thanks Bruce
I'll test using popups.
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186