NetTalk Central

Author Topic: NT607/8? Wizard creation  (Read 3848 times)

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
NT607/8? Wizard creation
« on: December 09, 2011, 01:10:56 AM »
Hi Bruce
I used the wizard to create an application using the attached dct and small demo tps tables.
If you access the beneficiary history menu choice and select change for any record and then just save on the form the error  message BeneficiaryID: Must be in Table Beneficiary appears.
The link must be there because when you arrive in the form the Beneficiary name appears in the entry field. I have also checked the tps files and they appear to be correct.
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: NT607/8? Wizard creation
« Reply #1 on: December 09, 2011, 01:15:49 AM »
you forgot to attach the files.

cheers
Bruce

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Re: NT607/8? Wizard creation
« Reply #2 on: December 10, 2011, 09:40:00 AM »
Doh!!!

[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

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Re: NT607/8? Wizard creation
« Reply #3 on: December 13, 2011, 09:46:42 PM »
Hi Bruce
Any feedback yet?
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: NT607/8? Wizard creation
« Reply #4 on: December 14, 2011, 12:11:50 AM »
yeah.

You have BeneficaryHistory linked to the Beneficiary table.
Beneficiary has a ID field - but not a (unique) description field. And importantly no (single component) description field key.

So, the wizard has been a little too clever, and not clever enough. UpdateBeneficiaryHistory procedure, BENH:BeneficiaryID field, Lookup Settings - "use Description instead of value" is on - and it should be off. You can obviously change that in the app.

Cheers
Bruce

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Re: NT607/8? Wizard creation
« Reply #5 on: December 14, 2011, 01:42:20 AM »
Thanks
I'll go through my dictionaries and update.
I have had this issue on and off for a while in NT5 as well
So does this mean that if (for example) I have a surname and first name I need to create a composite field with surname + firstname + ID as the unique description field created from the 3 individual fields which will be my unique description field and key
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: NT607/8? Wizard creation
« Reply #6 on: December 14, 2011, 02:26:54 AM »
So the "description in place of value" works if
a) there's a single-component description field
b) which is (preferably) unique
c) there's a single-component key on this field.

Of course this may be the round-about way of solving the problem - if names are not unique (and they're not) then the whole description-instead-of-value thing becomes somewhat moot.