The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Page is no saving changes.
Posted: 08 Oct 08 2:15 PM
|
Hi,
i added 3 new fields to the Contact Ditails web page. this 3 fields are 3 new fields on ContactX table (1 to 1 with Contact). What i notice is if i made a change on the page on these 3 fields and i hit save, the 3 fields goes blank again. I found the this is because there is no record on ContactX related to the actual record on Contact.
My question is: is it not default to SLX to create a record on a 1 to 1 table if there is no record related? or maybe im missing a step when creating the ContactX enity.
Thanks in advance.
John |
|
|
|
Re: Page is no saving changes.
Posted: 09 Oct 08 7:13 AM
|
John, the record should be created if it is not there. I would look into your relationship of ContactX to contact and ensure that it is marked as an extension of contact.
Mark |
|
|
|
Re: Page is no saving changes.
Posted: 09 Oct 08 8:24 AM
|
thank, Mark, for your reply.
You were riight it had something to do with how the relatioship was configured.
I changed it but now it saving the change to all records.
My relationship is: Contact.ContactX 1:M ContactX.Contact.
Both Include... are checked and the cascade option is at SaveUpdateDelete.
Thanks again.
John |
|
|
|
Re: Page is no saving changes.
Posted: 09 Oct 08 8:29 AM
|
John, is the ContactX table an extension table in such that it is One-2-One. If this is so delete the 1:M relationship. Open up the ContactX entity and select is ExtensionOf choosing the Contact entity. Save and try again.
Mark |
|
|
|
Re: Page is no saving changes.
Posted: 09 Oct 08 9:14 AM
|
BINGO!!!
Thanks mark it worked perfectly.
Now, continuing with this, i made the same changes on ProductX.
I'm trying to make a new Form on Account Entity based on AccountProduct with wizzard. It will be a Form with a Grid.
My problem is that i need to show fields from the ProductX table, and on the fields selection tree y only see the fields from product but no ProductX.
How can i do this.
Thanks a lot.
John |
|
|
|
Re: Page is no saving changes.
Posted: 09 Oct 08 9:35 AM
|
First make sure that you build entity interfaces after you made the relationship changes. It may be possible that you will have to Hand type the fileld names into the DataField property since it would be 2 entities deep.
Mark |
|
|
|
Re: Page is no saving changes.
Posted: 09 Oct 08 3:50 PM
|
I did what you say, but the grid wasn't showing anything when there were records on te AccountProduct Table.
Then, i found that the problem is that some of the fields that i need on the grid are from AccountProductX and this table is empty.
I found this runing a SQL query with an "INNER JOIN" between AccountProduct and AccountProductX.
Is there a way to make the grid use a LEFT JOIN or anything like that. That way it will still show the data from AccountProduct and show as empty the fields that come from AccountProductX.
Thank you very much. |
|
|
|