Radicore Forum: Transaction Patterns » add1 in shared account

Home » RADICORE development » Transaction Patterns » add1 in shared account

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

add1 in shared account [message #5347]

Thu, 28 January 2016 05:35

htManager
Messages: 456
Registered: May 2014

Senior Member

Hello Tony,

is it possible to insert records from a normal account in a shared account?

I have a contact-pool table where all new inserted records should be available for everyone. I want to do this by changing the key values in $fieldarray[] (user_id, user_seq_no, rdcaccount_id) in the _cm_getInitialData() method in the class file.

function _cm_getInitialData ($fieldarray)
{
// get next available number for user_seq_no for user HTM
$where = "user_id='HTM'";
$query = "SELECT max(user_seq_no) FROM $this->tablename WHERE $where";
$count = $this->getCount($query);
$fieldarray['user_id'] = 'HTM';
$fieldarray['user_seq_no'] = $count + 1;
$fieldarray['rdcaccount_id'] = '1';

return $fieldarray;

} // _cm_getInitialData

But when pressing the New button I get the following error message: [rdcaccount_id] User's account (4) is not compatible with record's account (1)
When commenting out $fieldarray['rdcaccount_id'] the add1 task works fine with the next available user_seq_no for user HTM but with rdcaccount=(4).

So is there a possibility to realize that?

Report message to a moderator

Re: add1 in shared account [message #5349 is a reply to message #5347]

Thu, 28 January 2016 08:56

AJM
Messages: 2386
Registered: April 2006
Location: Surrey, UK

Senior Member

Anyone who is logged in with an rdcaccount_id which is greater than 1 can only add records with their rdcaccount_id. Only someone who is logged in with an rdcaccount_id of 1 (or null) can add records to the shared account. You therefore need to have a separate user_id set up who can add records to the shared account.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: add1 in shared account [message #5352 is a reply to message #5349]

Fri, 29 January 2016 04:38

htManager
Messages: 456
Registered: May 2014

Senior Member

Thank you for the confirmation.

Report message to a moderator

Previous Topic:	Del1 - no table name in query
Next Topic:	PopUp - Selection criteria

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Jan 02 13:11:54 EST 2026

Total time taken to generate the page: 0.01078 seconds