Radicore Forum: Transaction Patterns » Virtual Private Database and List 2 pattern

Home » RADICORE development » Transaction Patterns » Virtual Private Database and List 2 pattern (Entries from child table not visible)

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

Virtual Private Database and List 2 pattern [message #4194]

Mon, 02 June 2014 10:48

htManager
Messages: 456
Registered: May 2014

Senior Member

Hi Tony,

I am struggling with the implementation of the virtual private database system as you discribed in Implementing Virtual Private Databases and I have problems with a list 2 pattern.

I also read your article Technical Keys - their Uses and Abuses and I followed your proposal to avoid technical keys when possible.
I created tables with up to six or seven columns as Primary key. I don't know if this is the best way but all the tables are related in a one to many relation. (Cascading)

I mention this because the first colomn of these tables is always the field rdcaccount_id which is used for account access or shared access.
You described how to deal with a list 1 pattern and this works fine in my application, I see all the occourences made by a special account.
But if I want to see an account occurence in a list 2 form, I only see the entries of the shared account.

I inserted the code in the _getData() function after the code for checking the primary key:

if ($this->checkPrimaryKey AND !$this->allow_empty_where) {
// check that full primary key (or candidate key) has been supplied

I also tried inserting the code at the end of the function - same result.

So please, can you tell me where to insert the code at the right place?

Best regards,

Juergen

Report message to a moderator

[Message index]

		Virtual Private Database and List 2 pattern By: htManager on Mon, 02 June 2014 10:48
		Re: Virtual Private Database and List 2 pattern By: AJM on Tue, 03 June 2014 04:45
		Re: Virtual Private Database and List 2 pattern By: htManager on Tue, 03 June 2014 05:42
		Re: Virtual Private Database and List 2 pattern By: AJM on Tue, 03 June 2014 06:56
		Re: Virtual Private Database and List 2 pattern By: htManager on Tue, 03 June 2014 08:33
		Re: Virtual Private Database and List 2 pattern By: AJM on Tue, 03 June 2014 09:58
		Re: Virtual Private Database and List 2 pattern By: htManager on Tue, 03 June 2014 10:37
		Re: Virtual Private Database and List 2 pattern By: AJM on Tue, 03 June 2014 10:54
		Re: Virtual Private Database and List 2 pattern By: AJM on Tue, 03 June 2014 10:57
		Re: Virtual Private Database and List 2 pattern By: htManager on Tue, 03 June 2014 11:12
		Re: Virtual Private Database and List 2 pattern By: AJM on Tue, 03 June 2014 11:32
		Re: Virtual Private Database and List 2 pattern By: htManager on Wed, 04 June 2014 04:03
		Re: Virtual Private Database and List 2 pattern By: AJM on Wed, 04 June 2014 04:30
		Re: Virtual Private Database and List 2 pattern By: htManager on Wed, 04 June 2014 05:06
		Re: Virtual Private Database and List 2 pattern By: AJM on Wed, 04 June 2014 05:35
		Re: Virtual Private Database and List 2 pattern By: htManager on Wed, 04 June 2014 10:44
		Re: Virtual Private Database and List 2 pattern By: AJM on Wed, 04 June 2014 13:01
		Re: Virtual Private Database and List 2 pattern By: htManager on Thu, 05 June 2014 03:44
		Re: Virtual Private Database and List 2 pattern By: AJM on Thu, 05 June 2014 04:06
		Re: Virtual Private Database and List 2 pattern By: AJM on Thu, 05 June 2014 09:54

Previous Topic:	MULTI5
Next Topic:	PopUpForm

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Jul 07 03:52:56 EDT 2025

Total time taken to generate the page: 0.18900 seconds