Click here to Skip to main content
15,887,683 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
GeneralRe: n-Tier Architecture and Async Pin
Nathan Minier10-May-19 7:32
professionalNathan Minier10-May-19 7:32 
GeneralRe: n-Tier Architecture and Async Pin
Kevin Marois10-May-19 7:36
professionalKevin Marois10-May-19 7:36 
QuestionLookup Editor Design Question Pin
Kevin Marois27-Apr-19 7:28
professionalKevin Marois27-Apr-19 7:28 
AnswerRe: Lookup Editor Design Question Pin
Mycroft Holmes27-Apr-19 13:29
professionalMycroft Holmes27-Apr-19 13:29 
GeneralRe: Lookup Editor Design Question Pin
Kevin Marois27-Apr-19 13:44
professionalKevin Marois27-Apr-19 13:44 
GeneralRe: Lookup Editor Design Question Pin
Mycroft Holmes27-Apr-19 13:49
professionalMycroft Holmes27-Apr-19 13:49 
GeneralRe: Lookup Editor Design Question Pin
Kevin Marois27-Apr-19 13:57
professionalKevin Marois27-Apr-19 13:57 
GeneralRe: Lookup Editor Design Question Pin
Eddy Vluggen28-Apr-19 1:09
professionalEddy Vluggen28-Apr-19 1: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 7:35
professionalabmv22-Apr-19 7:35 
AnswerRe: J2EE or the other stuff. Pin
Eddy Vluggen22-Apr-19 8:00
professionalEddy Vluggen22-Apr-19 8:00 
AnswerRe: J2EE or the other stuff. Pin
Gerry Schmitz22-Apr-19 8:30
mveGerry Schmitz22-Apr-19 8:30 
AnswerRe: J2EE or the other stuff. Pin
jschell27-Apr-19 7:54
jschell27-Apr-19 7:54 
QuestionDropBox Style App Pin
Kevin Marois17-Apr-19 11:07
professionalKevin Marois17-Apr-19 11:07 
AnswerRe: DropBox Style App Pin
abmv22-Apr-19 7:43
professionalabmv22-Apr-19 7:43 
AnswerRe: DropBox Style App Pin
Eddy Vluggen22-Apr-19 7:58
professionalEddy Vluggen22-Apr-19 7:58 
AnswerRe: DropBox Style App Pin
Gerry Schmitz22-Apr-19 8:36
mveGerry Schmitz22-Apr-19 8:36 
GeneralRe: DropBox Style App Pin
Kevin Marois22-Apr-19 9:08
professionalKevin Marois22-Apr-19 9:08 
GeneralRe: DropBox Style App Pin
Gerry Schmitz23-Apr-19 8:18
mveGerry Schmitz23-Apr-19 8:18 
QuestionHow to design class for hierarchical data? Pin
ND Sharma11-Apr-19 1:54
ND Sharma11-Apr-19 1:54 
AnswerRe: How to design class for hierarchical data? Pin
Gerry Schmitz11-Apr-19 5:35
mveGerry Schmitz11-Apr-19 5:35 
AnswerRe: How to design class for hierarchical data? Pin
jschell13-Apr-19 6:39
jschell13-Apr-19 6:39 
GeneralRe: How to design class for hierarchical data? Pin
Gerry Schmitz14-Apr-19 7:48
mveGerry Schmitz14-Apr-19 7:48 
GeneralRe: How to design class for hierarchical data? Pin
jschell21-Apr-19 6:39
jschell21-Apr-19 6:39 
QuestionWeb API Design Pin
Mycroft Holmes4-Mar-19 20:46
professionalMycroft Holmes4-Mar-19 20:46 
AnswerRe: Web API Design Pin
Nathan Minier5-Mar-19 1:59
professionalNathan Minier5-Mar-19 1: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.