Click here to Skip to main content
15,902,853 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionUpto what size we can store a data in a file Pin
himuskanhere29-Jun-06 20:18
himuskanhere29-Jun-06 20:18 
AnswerRe: Upto what size we can store a data in a file Pin
Dave Kreskowiak30-Jun-06 4:04
mveDave Kreskowiak30-Jun-06 4:04 
QuestionSocket Permissions Pin
elms29-Jun-06 18:25
elms29-Jun-06 18:25 
AnswerRe: Socket Permissions Pin
Colin Angus Mackay29-Jun-06 21:45
Colin Angus Mackay29-Jun-06 21:45 
AnswerRe: Socket Permissions Pin
Dave Kreskowiak30-Jun-06 3:58
mveDave Kreskowiak30-Jun-06 3:58 
Questionvs 2005 maskedtext box Pin
amilapradeep29-Jun-06 17:56
amilapradeep29-Jun-06 17:56 
Questionhow to validate a primary or unique key [modified] Pin
changeez29-Jun-06 14:10
changeez29-Jun-06 14:10 
AnswerRe: how to validate a primary or unique key [modified] Pin
Dave Kreskowiak29-Jun-06 16:43
mveDave Kreskowiak29-Jun-06 16:43 
Really, the user shouldn't be entering Primary Key values. They should either be autogenerated and/or built from fields in the data, otherwise known as a compound Key. Part of this reason isn't necessarily because of the possibility of duplicate keys, but getting the keys entered consistantly.

The only way to verify that the new Key doesn't exist is to look it up in the database and see if it returns anything. Performance can become an issue if your table contains a large number of rows and/or you don't have your index built correctly.


Dave Kreskowiak
Microsoft MVP - Visual Basic



-- modified at 22:43 Thursday 29th June, 2006
GeneralRe: how to validate a primary or unique key [modified] Pin
changeez30-Jun-06 9:17
changeez30-Jun-06 9:17 
QuestionHelp: MS Access "Relationship" Style View Pin
jgyie229-Jun-06 9:54
jgyie229-Jun-06 9:54 
GeneralRe: Help: MS Access "Relationship" Style View Pin
User 171649229-Jun-06 13:53
professionalUser 171649229-Jun-06 13:53 
GeneralRe: thanks, Richard. A good, yet slightly complicated reference Pin
jgyie229-Jun-06 20:51
jgyie229-Jun-06 20:51 
QuestionReading File Records Pin
Thaddeus_jenkins29-Jun-06 8:49
Thaddeus_jenkins29-Jun-06 8:49 
AnswerRe: Reading File Records Pin
Dave Kreskowiak29-Jun-06 10:23
mveDave Kreskowiak29-Jun-06 10:23 
AnswerRe: Reading File Records Pin
Mekong River29-Jun-06 15:35
Mekong River29-Jun-06 15:35 
Questionpatching a program Pin
microuser_200029-Jun-06 5:51
microuser_200029-Jun-06 5:51 
AnswerRe: patching a program Pin
Dave Kreskowiak29-Jun-06 7:45
mveDave Kreskowiak29-Jun-06 7:45 
QuestionWindow Service Pin
nitin_ion29-Jun-06 1:45
nitin_ion29-Jun-06 1:45 
QuestionPGP Pin
punam3029-Jun-06 1:10
punam3029-Jun-06 1:10 
AnswerRe: PGP Pin
Dave Kreskowiak29-Jun-06 4:39
mveDave Kreskowiak29-Jun-06 4:39 
QuestionPre and Post build steps Pin
PaulPrice29-Jun-06 1:07
PaulPrice29-Jun-06 1:07 
AnswerRe: Pre and Post build steps Pin
Duncan Edwards Jones29-Jun-06 1:26
professionalDuncan Edwards Jones29-Jun-06 1:26 
AnswerRe: Pre and Post build steps Pin
Kevin McFarlane30-Jun-06 0:22
Kevin McFarlane30-Jun-06 0:22 
Question[2005] HTTP:POST form emulation - don't even know where to start? Pin
Duncan Edwards Jones28-Jun-06 23:53
professionalDuncan Edwards Jones28-Jun-06 23:53 
QuestionMscomm and draw chart Pin
codeadair28-Jun-06 22:44
codeadair28-Jun-06 22:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.