Click here to Skip to main content
14,391,933 members

Design and Architecture

 
GeneralRe: n-Tier Architecture and Async Pin
Nathan Minier10-May-19 8:32
professionalNathan Minier10-May-19 8:32 
GeneralRe: n-Tier Architecture and Async Pin
Kevin Marois10-May-19 8:36
professionalKevin Marois10-May-19 8:36 
QuestionLookup Editor Design Question Pin
Kevin Marois27-Apr-19 8:28
professionalKevin Marois27-Apr-19 8:28 
AnswerRe: Lookup Editor Design Question Pin
Mycroft Holmes27-Apr-19 14:29
MemberMycroft Holmes27-Apr-19 14:29 
GeneralRe: Lookup Editor Design Question Pin
Kevin Marois27-Apr-19 14:44
professionalKevin Marois27-Apr-19 14:44 
GeneralRe: Lookup Editor Design Question Pin
Mycroft Holmes27-Apr-19 14:49
MemberMycroft Holmes27-Apr-19 14:49 
GeneralRe: Lookup Editor Design Question Pin
Kevin Marois27-Apr-19 14:57
professionalKevin Marois27-Apr-19 14:57 
GeneralRe: Lookup Editor Design Question Pin
Eddy Vluggen28-Apr-19 2:09
mveEddy Vluggen28-Apr-19 2:09 
Kevin Marois wrote:
Two different items that look close and even mean the same are really 2 PKs.
If the user doesn't know that the combination of those fields (which a PK usually is), then the user doesn't know what makes an item unique, and will be causing duplicate entries.

An overengineered solution; save a soundex of your item. If another is added, check if the soundex (or Levenshtein distance) of it is already there, and open a messagebox suggesting a similar item is already there (Google's "did you mean x?"). You can put these in a separate table.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

QuestionJ2EE or the other stuff. Pin
abmv22-Apr-19 8:35
professionalabmv22-Apr-19 8:35 
AnswerRe: J2EE or the other stuff. Pin
Eddy Vluggen22-Apr-19 9:00
mveEddy Vluggen22-Apr-19 9:00 
AnswerRe: J2EE or the other stuff. Pin
Gerry Schmitz22-Apr-19 9:30
mveGerry Schmitz22-Apr-19 9:30 
AnswerRe: J2EE or the other stuff. Pin
jschell27-Apr-19 8:54
Memberjschell27-Apr-19 8:54 
QuestionDropBox Style App Pin
Kevin Marois17-Apr-19 12:07
professionalKevin Marois17-Apr-19 12:07 
AnswerRe: DropBox Style App Pin
abmv22-Apr-19 8:43
professionalabmv22-Apr-19 8:43 
AnswerRe: DropBox Style App Pin
Eddy Vluggen22-Apr-19 8:58
mveEddy Vluggen22-Apr-19 8:58 
AnswerRe: DropBox Style App Pin
Gerry Schmitz22-Apr-19 9:36
mveGerry Schmitz22-Apr-19 9:36 
GeneralRe: DropBox Style App Pin
Kevin Marois22-Apr-19 10:08
professionalKevin Marois22-Apr-19 10:08 
GeneralRe: DropBox Style App Pin
Gerry Schmitz23-Apr-19 9:18
mveGerry Schmitz23-Apr-19 9:18 
QuestionHow to design class for hierarchical data? Pin
ND Sharma11-Apr-19 2:54
MemberND Sharma11-Apr-19 2:54 
AnswerRe: How to design class for hierarchical data? Pin
Gerry Schmitz11-Apr-19 6:35
mveGerry Schmitz11-Apr-19 6:35 
AnswerRe: How to design class for hierarchical data? Pin
jschell13-Apr-19 7:39
Memberjschell13-Apr-19 7:39 
GeneralRe: How to design class for hierarchical data? Pin
Gerry Schmitz14-Apr-19 8:48
mveGerry Schmitz14-Apr-19 8:48 
GeneralRe: How to design class for hierarchical data? Pin
jschell21-Apr-19 7:39
Memberjschell21-Apr-19 7:39 
QuestionWeb API Design Pin
Mycroft Holmes4-Mar-19 21:46
MemberMycroft Holmes4-Mar-19 21:46 
AnswerRe: Web API Design Pin
Nathan Minier5-Mar-19 2:59
professionalNathan Minier5-Mar-19 2:59 

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.