Get a Jumpstart with our Sample Apps
Results 1 to 3 of 3

Thread: set expression error in A5

  1. #1
    Member
    Real Name
    Kurt Virnig
    Join Date
    Sep 2006
    Posts
    3

    Default set expression error in A5

    In A4 I was able to have a set that was linked by an expression. I used Last_Name+First_Name in both tables. Referential Integrity = Yes, Cascading Updates = yes and Cascading Deletes = yes.

    In A5 if I choose 'Cascading Changes/Deletes' I get a wonderful error telling me:

    "You can only select the 'Cascades Changes/Deletes' option for 'Referential Integrity' if the 'Parent Key'is a field, not an expression"

    If I choose 'Prevent Changes' I get another error:

    "Could not create/edit link. It is possible the child table was open in another session. Alpha 5 needs exclusive use to the child table. Try exiting from Alpha 5 and creating the link again".

    I exited, rebooted, stood on my head and spun without any progress. It would seem in this area A5 is a step backwards from A4. I was able to create the link/set with Referential Integrity set to none. Is there any hope for this working with Referential Integrity?

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    24,698

    Default Re: set expression error in A5

    Any chance of creating a calculated field in both tables that has the expression

    Last_Name+First_Name

    ?
    There can be only one.

  3. #3
    Member
    Real Name
    Kurt Virnig
    Join Date
    Sep 2006
    Posts
    3

    Default Re: set expression error in A5

    You betcha! Already did that as a workaround. Thanks for the suggestion

Similar Threads

  1. Expression in set gets error
    By khpvirnig54 in forum Alpha Four Versions 7 and 8
    Replies: 0
    Last Post: 09-11-2009, 08:15 PM
  2. A/S set Variable to Constant or Expression
    By John Gamble in forum Alpha Five Version 6
    Replies: 11
    Last Post: 12-14-2005, 06:34 PM
  3. Question about Set Variable to Expression Result
    By Robert Cheley in forum Alpha Five Version 5
    Replies: 1
    Last Post: 07-08-2003, 07:52 PM
  4. Set Linking Expression
    By Peter.Greulich in forum Alpha Five Version 5
    Replies: 6
    Last Post: 03-25-2003, 11:42 AM
  5. Set Linking Expression
    By Peter.Greulich in forum Alpha Five Version 4
    Replies: 3
    Last Post: 03-20-2002, 09:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •