Reply from Chen Chang on Dec 30 at 11:41 AM You may be able to leverage the ActiveRowCount property of the Grid/Rowset. So the codes would look something like (** place in RowInsert event)
&RS = GetLevel0()(1).GetRowset(Scroll.X_ITL_OFC_SET);
&CNT = &RS.ACTIVEROWCOUNT;
If &CNT > 10 then
MessageBox(0, "", 0, 0, " Only allow Max 10 rows?");
End-if
Again, this is only a reminder message, which user can keep insert more rows, unless you use the much stronger action like
ERROR "Exceed 10 rows";
| | | ---------------Original Message---------------
From: Limitation_on_rows
Sent: Friday, December 30, 2011 10:28 AM
Subject: How to Set a Limitation on the Number of Rows that Can Be Entered By a User
When a user inserts rows past ten we have a warning message appearing that tells them the number of remarks have been exceeded. The limit has been set at ten. The query has been placed on the save/edit. This works fine, but we don't want to let them have the capability of still exceeding this limit and being able to save. How do we stop it at ten? |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
No comments:
Post a Comment