Radicore Forum: Bug Reports » Primary Key in not complete

Home » RADICORE development » Bug Reports » Primary Key in not complete

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

Primary Key in not complete [message #832]

Wed, 16 May 2007 15:56

danpoleary
Messages: 49
Registered: February 2007

Member

This is a strange one.

when I select a record in my application, anytime I select Delete, Update, or Read, I get an:

Primary key (unique_sequence) is not complete - check selection

I have checked the classes, screens, and database. I have also checked errorlog.html, xsl, and sql output. but nothing indicates an error. The field exists, contains data, and is unique, but will not allow me to apply the above functions on selected records.

Where else could I look to resolve this?

Thanks in advance,

Dan

Report message to a moderator

Re: Primary Key in not complete [message #833 is a reply to message #832]

Wed, 16 May 2007 18:54

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

Senior Member

The error message is informing you that the primary key field with the name 'unique_sequence' is not being passed to the child form when you press the navigation button. Have you included that field in the sql query in the parent form?

If your select list only contains the fields which you are actually displaying in the parent form, and you have excluded the primary key because it is not displayed, then it is not available to be passed down to any child form.

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

Report message to a moderator

Previous Topic:	sql error adding a nav button
Next Topic:	filterWhereSqlWhere

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Jul 04 19:41:00 EDT 2025

Total time taken to generate the page: 0.09968 seconds