Trouble with FK management in an Oracle environment


Author
Message
Kirk M Sherhart
Kirk M Sherhart
StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)
Group: Forum Members
Posts: 41, Visits: 259
I'm having trouble getting FK management working in an Oracle environment.



I notice that pre/post primary key value pairs are stored in the _PrimaryKeyPostPreSaveValues dictionary as decimals (which Oracle uses for all numeric values.) However, during the _DataLayer_AfterSave event, the procedure GetPostSavePrimaryKeyValue uses a Long value to look for the old PK value. Therefore, the old primary key value is not found, returning a null value.



Am I missing something?



Thanks!
Reply
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
Good find. I think that you may be on to something here. This should most likely have a test on types as the value does need to be determined (must be less than zero). I will look at this in the morning and see if I can come up with a test for you to try. Thanks.



GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search