Data Integrity Checking


Author
Message
Wang Tong Yin
Wang Tong Yin
StrataFrame Novice (61 reputation)StrataFrame Novice (61 reputation)StrataFrame Novice (61 reputation)StrataFrame Novice (61 reputation)StrataFrame Novice (61 reputation)StrataFrame Novice (61 reputation)StrataFrame Novice (61 reputation)StrataFrame Novice (61 reputation)StrataFrame Novice (61 reputation)
Group: Forum Members
Posts: 25, Visits: 46
Hi,

I have some doubts about using StrataFrame for web application.

1. Can StrataFrame automatically check for duplicate record if a user trying to add new record into a table? Do I need to add my own sql to check it?

2. Can StrataFrame autimatically check whether the record is referenced in child table before update/delete? Do I need to add my own sql to check it?

3. How can I retrieve the foreign key description from another table? Does StrataFrame provide any special function to do that?

Thanks.

Replies
Wang Tong Yin
Wang Tong Yin
StrataFrame Novice (61 reputation)StrataFrame Novice (61 reputation)StrataFrame Novice (61 reputation)StrataFrame Novice (61 reputation)StrataFrame Novice (61 reputation)StrataFrame Novice (61 reputation)StrataFrame Novice (61 reputation)StrataFrame Novice (61 reputation)StrataFrame Novice (61 reputation)
Group: Forum Members
Posts: 25, Visits: 46
Hi Ben,

Thank you for your answer. I got some ideas on how to do the above.

StrataFrame will check the child table to a degree: when a child business object saves and it's parent business object is dirty, the child will force the parent to save first.  Business objects will not, however, cascade DELETEs or UPDATEs and it is recommended to do that through the Foreign Key on SQL Server.

Is that all types of databases have cascade DELETEs or UPDATEs functionality? What I need to do if the database not supports this functionality?

StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
If the database does not support the functionality to cascade DELETE callls (I know that VFP, Access, MSSQL, Oracle, VistaDB, MySQL, PostgreSQL, etc. all do), then you can add a handler within the business object to the AfterDelete event and delete the child records within that event.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Wang Tong Yin - 19 Years Ago
StrataFrame Team - 19 Years Ago
Wang Tong Yin - 19 Years Ago
StrataFrame Team - 19 Years Ago
Chan - 18 Years Ago
Trent L. Taylor - 18 Years Ago
Chan - 18 Years Ago
                         We do not have afirm release date for 2.0. It will be after Orcas has...
Trent L. Taylor - 18 Years Ago
                             Hi, I usually take 30-50 secs to setup one BO. However, there are at...
Chan - 18 Years Ago
                                 I understand, but generally speaking you don't use all 120 at once. We...
Trent L. Taylor - 18 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search