Is it possible Limit size of table?

Question

0.00/5 (No votes)

See more:

on creation of a table is it possible to configure the size of the table
like we do with an array upper bounds , say 1 to 100.

The reason I ask is because I'm looking at a ways of making a demo program
other than time limited or number of times program has been run etc.

would be neat if i could just set the max amount of data in a table at design time
and then switch off this feature when required.

If the answer is NO, It would be nice if you could actualy offer up some real suggestions, alternative approaches, guidance please.

thanks in advance

Posted 27-Aug-12 7:58am

It is what it is

Add a Solution

2 solutions

Solution 2

CPallini solution is very good. It shows a way to achieve the problem using database definition.

I think, you can do it programmatically. Each time, when user will add every single record to the database, just check the recordcount. Simple?

Posted 27-Aug-12 9:11am

Maciej Los

Comments

It is what it is 31-Aug-12 5:17am

Hi thanks for your input, yes I think CPallini has done a good job with his suggestion, but i'm also interested in having a look at your idea, maybe I should have said I'm not a professional so can I ask you what object does the "recordcount" belong to?, or can you elaborate with a code sample

Thanks

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CPallini · Accepted Answer · 2012-08-27T08:05:00

Solution 1

Here[^] a way to do that.

Posted 27-Aug-12 8:05am

CPallini

Comments

Maciej Los 27-Aug-12 15:07pm

Good link, 5!