multiple items with the same database column name [message #487564] |
Tue, 28 December 2010 18:39 |
|
john70carlson
Messages: 2 Registered: December 2010 Location: United States
|
Junior Member |
|
|
Hi,
I am coming across a requirement wherein a databse cloumn is shred by 2 fields..( need to append the value to the data-base column for the 2nd field.
I dint test it yet but the form compliled with warning
FRM-30431: Warning: Duplicate column name in same block
is it ok to further go or its not allowed at all?
ALso , if anybody has idea how to implement this.
Thanks
John
|
|
|
Re: multiple items with the same database column name [message #487597 is a reply to message #487564] |
Wed, 29 December 2010 01:26 |
|
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
No, you can't do that - as Forms already told you, this is an error.
Something's wrong with either data model or its implementation. If the requirement says that there should be two form items, then the table should contain two columns (instead of one). Or, if it *must* be a single column, then you'd also use a single form item.
However, if you insist, then create two non-database items that are visible on the form. A database item doesn't have to be visible; populate it in one of form triggers (either after those two non-database items are populated - that might be a WHEN-VALIDATE-ITEM on the second item), or before inserting records into the database (in that case, you'd use PRE-INSERT trigger).
|
|
|
|
|