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
Chan
Chan
Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)
Group: Forum Members
Posts: 533, Visits: 2K
Hi,

I usually take 30-50 secs to setup one BO. However, there are at least 120 BOs to be created for now.

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
I understand, but generally speaking you don't use all 120 at once.  We have more than that in our medical system, but we don't use them all at once.  It would be a rare circumstance that all 120+ BOs are used within the same forms or dialogs.  So this should be one of those things that is drawn out over the duration of your application development.
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