This topic is locked

Master id in the Details table stopped working after migration to phpr 9.6

1/24/2017 4:42:59 AM
PHPRunner General questions
L
lmb_hs_sp author

Hi
Product: phprunner 9.6 build 27604 x64.
I have phpr application that I am migrating from v8.1 build 25268 x64 to phpr v9.6 build 27604 x64.
In the application I have Master <-> Details php views.
In the app built with phpr 8.1 when I do an inline add of a record in a Details table, the record id from the Master record was automatically updated in the Details table.
The scenario:

  • I have a customer 'Customer C' with a customer id '3' in the master table 'Customer'.
  • I also have a Details table 'Invoices', declared as a detail table for the Master table 'Customer' in phpr.
  • When I do an inline add of a new record 'Invoice 100' in the Details table 'Invoice' for the customer C then the customer_id of the new record 'invoice 100' (invoice_id: 100) is automatically created with the value '3' (the customer_id for the customer 'Customer C' in the table 'Customer').
    This is the intended behavior
    BUT now that I have recompiled with phpr v9.6 the behavior has changed:

    For the same customer 'Customer C' with a customer id '3' in the master table 'Customer'. When I do an inline add of a new record "Invoice 100" in the Details table "invoice" for the customer C then the customer_id of the new record 'invoice 100' (invoice_id 100) is automatically created with the value '1': the first id in the table 'Customer'. It seems to ignore the fact that we added "Invoice 100" as a Detail record of 'Customer C'.

    This is NOT the intended behavior...
    Am I missing something here? How can I get the old behavior back?
    Thanks for your help!