Before Insert check Recordcount of DBGrid1.Datasource
If >= 20 then abort
(nicer
ShowMessage('No More I can't deal with it :-} ');
abort;
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of James Low
Sent: Monday, 15 September 2003 1:25 p.m.
To: Multiple recipients of list delphi
Subject: RE: [DUG]: Limiting Entry
My only concern with using beforepost would be that the user could enter all
their data then attempt to post only to find that it was a no go. If you
control the insert and append processes/ events that might be better. Ie
Counting the records on beforeinsert and aborting if 21 would be better (I
think).
Regards
-----Original Message-----
From: vss [mailto:[EMAIL PROTECTED]
Sent: Monday, 15 September 2003 1:14 PM
To: Multiple recipients of list delphi
Subject: [DUG]: Limiting Entry
Hi All.
IS ther a "Nice" way to limit how many records someone enters into a
DBGrid?
Basically I want to limit people to only entering 20 items into a
DBGrid, or better still tell the table to only accept 20 records, but I
think this will be a frontend thing.
I was thinking the best way to do it is to look at the beforepost event
and cound the records, (or even rows in the dbgrid) and say they cant
add anymore if they already have 20.
This sound logical? or is there a nicer way to handle this?
Cheers, Jeremy
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
**********************************************************************
This e-mail message has been swept for content and viruses. No viruses were
detected.
Contact the Helpdesk on extension 9CIS (9247) for assistance, if required.
Email disclaimer: This email and any attachments are confidential. If you
are not the intended recipient, do not copy, disclose or use the contents in
any way. If you receive this message in error, please let us know by return
email and then destroy the message. Environment Bay of Plenty is not
responsible for any changes made to this message and/or any attachments
after sending.
******************************************************
This e-mail has been checked for viruses and no viruses were detected.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
