Click here to Skip to main content
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 Sergey Alexandrovich Kryukov 370
1 OriginalGriff 195
2 Zoltán Zörgő 124
3 Dave Kreskowiak 120
4 DamithSL 115
0 OriginalGriff 7,610
1 DamithSL 5,559
2 Sergey Alexandrovich Kryukov 5,324
3 Maciej Los 4,961
4 Kornfeld Eliyahu Peter 4,539


Advertise | Privacy | Mobile
Web02 | 2.8.141223.1 | Last Updated 27 Aug 2012
Copyright © CodeProject, 1999-2014
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