Home » RADICORE development » Bug Reports » multi2
multi2 [message #752] |
Mon, 09 April 2007 16:36  |
interop
Messages: 45 Registered: October 2006
|
Member |
|
|
I've created a multi2 task and it is failing in updateRecord() at line 3176 because _dml_ReadBeforeUpdate() is passed the updated where clause not the original where clause.
e.g. I have an employee with a number of phones in a table emp_phone. I want to change the number for a phone from 555-1234 to 555-5678 and the _dml_ReadBeforeUpdate() is passed $where='employee_id='10' AND phone_number='555-5678' and returns the error Could not locate original EMP_PHONE record for updating (employee_id='10' AND phone_number='555-5678')
edit: radicore 1.23.0
[Updated on: Mon, 09 April 2007 16:36] Report message to a moderator
|
|
|
|
|
|
Re: multi2 [message #764 is a reply to message #763] |
Wed, 11 April 2007 11:04   |
interop
Messages: 45 Registered: October 2006
|
Member |
|
|
In my original design emp_phone did not have a primary key. My design was Employee(one) --> emp_phone(many). Employees could have more than one phone (cell, home, work,...). What I did was add a new column "emp_phone_id" to emp_phone (an auto_increment, primary key) and that seemed to fix my problem.
[Updated on: Wed, 11 April 2007 11:05] Report message to a moderator
|
|
|
|
Goto Forum:
Current Time: Sat Jul 05 02:42:29 EDT 2025
Total time taken to generate the page: 0.10622 seconds
|