Click here to Skip to main content
11,417,750 members (46,604 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-CE SQL-Server
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 8:58am
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Here[^] a way to do that.
  Permalink  
Comments
losmac at 27-Aug-12 15:07pm
   
Good link, 5!
Rate this: bad
good
Please Sign up or sign in to vote.

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?
  Permalink  
Comments
PaulAnthonySamson at 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

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

  Print Answers RSS
0 Sascha Lefévre 340
1 Abhinav S 339
2 OriginalGriff 315
3 Sergey Alexandrovich Kryukov 255
4 deepankarbhatnagar 121
0 Sergey Alexandrovich Kryukov 9,345
1 OriginalGriff 7,712
2 Maciej Los 3,758
3 Abhinav S 3,601
4 Sascha Lefévre 3,198


Advertise | Privacy | Mobile
Web02 | 2.8.150427.4 | Last Updated 27 Aug 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100