Click here to Skip to main content
16,020,315 members
Home / Discussions / Database
   

Database

 
QuestionBetter way of matching a customer address Pin
jkirkerx24-Apr-15 6:25
professionaljkirkerx24-Apr-15 6:25 
AnswerRe: Better way of matching a customer address Pin
jkirkerx24-Apr-15 6:40
professionaljkirkerx24-Apr-15 6:40 
GeneralRe: Better way of matching a customer address Pin
PIEBALDconsult24-Apr-15 7:47
mvePIEBALDconsult24-Apr-15 7:47 
GeneralRe: Better way of matching a customer address Pin
jkirkerx24-Apr-15 12:31
professionaljkirkerx24-Apr-15 12:31 
GeneralRe: Better way of matching a customer address Pin
PIEBALDconsult24-Apr-15 12:36
mvePIEBALDconsult24-Apr-15 12:36 
GeneralRe: Better way of matching a customer address Pin
jkirkerx24-Apr-15 12:50
professionaljkirkerx24-Apr-15 12:50 
AnswerRe: Better way of matching a customer address Pin
jschell26-Apr-15 7:26
jschell26-Apr-15 7:26 
GeneralRe: Better way of matching a customer address Pin
jkirkerx26-Apr-15 8:34
professionaljkirkerx26-Apr-15 8:34 
I should of removed all the chars that are not A-Z a-z 0-9 first.

Well so far so good, much better than before.

I was creating a card record with the billing and shipping address. Worked fine for 10 years.
The users on the back end complained about it. Users with no programming experience complained that if they wanted to ship to a different address, they had to create a new card record and enter all the information again.

So I split everything up into separate records, and recorded the ID's of each record in the order record.
But a problem surfaced with duplicate records, in which I did a horrible job in checking for duplicates.
So checking a card record was easy, but checking a address record became more complicated.

QuestionExporting Database in XML Pin
MattAtCetraCom22-Apr-15 7:54
MattAtCetraCom22-Apr-15 7:54 
AnswerRe: Exporting Database in XML Pin
David Mujica22-Apr-15 9:36
David Mujica22-Apr-15 9:36 
QuestionRe: Exporting Database in XML Pin
Eddy Vluggen22-Apr-15 10:33
professionalEddy Vluggen22-Apr-15 10:33 
AnswerRe: Exporting Database in XML Pin
MattAtCetraCom23-Apr-15 7:37
MattAtCetraCom23-Apr-15 7:37 
GeneralRe: Exporting Database in XML Pin
Eddy Vluggen23-Apr-15 7:48
professionalEddy Vluggen23-Apr-15 7:48 
QuestionCreating SSIS OLE DB Source with Parameters programmatically with .NET Pin
Dr Miroslav Stimac22-Apr-15 5:10
professionalDr Miroslav Stimac22-Apr-15 5:10 
AnswerRe: Creating SSIS OLE DB Source with Parameters programmatically with .NET Pin
PIEBALDconsult22-Apr-15 5:15
mvePIEBALDconsult22-Apr-15 5:15 
GeneralRe: Creating SSIS OLE DB Source with Parameters programmatically with .NET Pin
Dr Miroslav Stimac22-Apr-15 5:31
professionalDr Miroslav Stimac22-Apr-15 5:31 
QuestionMaster slave model in databases Pin
holykrish20-Apr-15 19:10
holykrish20-Apr-15 19:10 
SuggestionRe: Master slave model in databases Pin
Richard MacCutchan20-Apr-15 21:45
mveRichard MacCutchan20-Apr-15 21:45 
AnswerRe: Master slave model in databases Pin
Mycroft Holmes21-Apr-15 0:43
professionalMycroft Holmes21-Apr-15 0:43 
QuestionAlert when row deleted (SQL Server 2012) Pin
Member 1151899220-Apr-15 2:03
Member 1151899220-Apr-15 2:03 
AnswerRe: Alert when row deleted (SQL Server 2012) Pin
Tim Carmichael20-Apr-15 2:14
Tim Carmichael20-Apr-15 2:14 
AnswerRe: Alert when row deleted (SQL Server 2012) PinPopular
David Mujica20-Apr-15 3:31
David Mujica20-Apr-15 3:31 
GeneralRe: Alert when row deleted (SQL Server 2012) Pin
Member 1151899220-Apr-15 23:44
Member 1151899220-Apr-15 23:44 
QuestionDebugging DAO to ADO Conversion Errors Pin
Kyudos14-Apr-15 13:20
Kyudos14-Apr-15 13:20 
AnswerRe: Debugging DAO to ADO Conversion Errors Pin
Mycroft Holmes14-Apr-15 14:11
professionalMycroft Holmes14-Apr-15 14:11 

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.