This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Hey Gang,
I created a new application with a details table. For some reason the data I enter into the details table does not get saved to the database. I click on new row enter the data and save the record. The data still appears on the screen (in memory), but when I go to the database, the table remains empty. I've created my relationship between the main table and details, set up the app appropriately, but it still does not work.
Any ideas?
thanks,
John
When you say the table is empty... is it completely empty? Usually when
I've seen this it's because the key fields are not being defaulted so the
rows are getting orphaned. Does SELECT COUNT(*) FROM mytable; return zero?
Chris.
On Wed, May 15, 2013 at 10:02 AM, John Ballnik <jballnik@yahoo.com> wrote:
> **
>
>
> Hey Gang,
>
> I created a new application with a details table. For some reason the
> data I enter into the details table does not get saved to the database. I
> click on new row enter the data and save the record. The data still
> appears on the screen (in memory), but when I go to the database, the table
> remains empty. I've created my relationship between the main table and
> details, set up the app appropriately, but it still does not work.
>
> Any ideas?
>
> thanks,
> John
>
>
>
>
>
Enter the key values of your child table in the appfielddefaults table
Say for example you created a child table from workorder called shipitems with workorderid as the keyfield
You need a relationship on your workorder table linking the workorderid fields then do the following insert
INSERT INTO APPFIELDDEFAULTS
(APP, DEFAULTVALUE, OBJECTNAME, ATTRIBUTENAME, APPFIELDDEFAULTSID)
('WOTRACK', ':OWNEROBJECT.WORKORDERID', 'YOURNEWTABLE', 'WORKORDERID', APPFIELDDEFAULTSSEQ.NEXTVAL );
Version 7 and above
Rgds Ian
-----Original Message-----
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Chris Lawless
Sent: 15 May 2013 18:13
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Child records not saving
When you say the table is empty... is it completely empty? Usually when I've seen this it's because the key fields are not being defaulted so the rows are getting orphaned. Does SELECT COUNT(*) FROM mytable; return zero?
Chris.
On Wed, May 15, 2013 at 10:02 AM, John Ballnik <jballnik@yahoo.com> wrote:
> **
>
>
> Hey Gang,
>
> I created a new application with a details table. For some reason the
> data I enter into the details table does not get saved to the
> database. I click on new row enter the data and save the record. The
> data still appears on the screen (in memory), but when I go to the
> database, the table remains empty. I've created my relationship
> between the main table and details, set up the app appropriately, but it still does not work.
>
> Any ideas?
>
> thanks,
> John
>
>
>
>
>
------------------------------------
Email addresses you might need:
Posting: MAXIMO@yahoogroups.com
Join : MAXIMO-subscribe@yahoogroups.com
Leave : MAXIMO-unsubscribe@yahoogroups.com
Cry : MAXIMO-owner@yahoogroups.com
Group : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************