Radicore Forum: How To » Use a table with only rdcaccount

Home » RADICORE » How To » Use a table with only rdcaccount_id as primary key

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

Re: Use a table with only rdcaccount_id as primary key [message #1796 is a reply to message #1795]

Thu, 06 November 2008 13:27

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

Senior Member

The documentation at http://www.tonymarston.net/php-mysql/virtual-private-databas e.html#implementation clearly indicates that you must use rdcaccout_id IN ADDITION to an existing key, so it is not possible to use it on its own.

It is possible to go to an UPDATE1 screen without starting at a LIST1 or LIST2 screen, but only if the current screen has the identity of the correct record in its WHERE string. Alternatively you can put code in the _cm_initialise() method to supply the relevant value manually, which means that the contents of the WHERE string as provided by the parent form becomes irrelevant.

If you are saying that the contents of the LIST1 screen should only show a single record, then you need to modify the ADD1 screen so that it will not allow additional records to be created. This can be done by hard-coding a single value for the primary key, thus avoiding the possibility of any user providing a different value.

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

Report message to a moderator

[Message index]

		Use a table with only rdcaccount_id as primary key By: gpatti on Thu, 06 November 2008 11:02
		Re: Use a table with only rdcaccount_id as primary key By: gpatti on Thu, 06 November 2008 11:08
		Re: Use a table with only rdcaccount_id as primary key By: AJM on Thu, 06 November 2008 13:27
		Re: Use a table with only rdcaccount_id as primary key By: gpatti on Fri, 07 November 2008 11:31

Previous Topic:	How do you activate the new Google Style Pagination
Next Topic:	Where does <imagename> search for the image in pdf multi?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Sep 27 05:16:40 EDT 2024

Total time taken to generate the page: 0.00974 seconds