Click here to Skip to main content
15,919,121 members
Home / Discussions / Database
   

Database

 
QuestionConnection Error [modified] Pin
Programm3r13-Sep-07 19:50
Programm3r13-Sep-07 19:50 
AnswerRe: Connection Error Pin
Blue_Boy13-Sep-07 21:00
Blue_Boy13-Sep-07 21:00 
Questionremote connection with sql2005 Pin
nicetohaveyou13-Sep-07 17:58
nicetohaveyou13-Sep-07 17:58 
AnswerRe: remote connection with sql2005 Pin
Michael Potter14-Sep-07 4:50
Michael Potter14-Sep-07 4:50 
QuestionStored Procedures - Validating Variables Pin
Mark Cabbage13-Sep-07 13:43
Mark Cabbage13-Sep-07 13:43 
AnswerRe: Stored Procedures - Validating Variables Pin
yahao13-Sep-07 21:37
yahao13-Sep-07 21:37 
AnswerRe: Stored Procedures - Validating Variables Pin
Pete O'Hanlon13-Sep-07 22:49
mvePete O'Hanlon13-Sep-07 22:49 
GeneralRe: Stored Procedures - Validating Variables Pin
Mark Cabbage14-Sep-07 0:41
Mark Cabbage14-Sep-07 0:41 
Hi Pete,

I was watching the Microsoft VB training videos by Beth Massi. She showed two things:
- using stored procedures server side to make the app more secure
- using VB code on the dataset to check data and issue error providor status for that column.

These items are supposed to keep the "business logic" away from the forms and in a central location rather than re-keying in different forms.

Well I put it into practice and it works nicely, BUT ONLY IF you type the right things in....but as we all know users rarely do as they should. I can break the system easily if I tab through all fields in the datagrid. The error provider flags them as needing attention (NULL ETC) but once you reach that last field it causes an unhandled exception. My instinct is to handle the excpetion on the form using an event like leavecell or dataerror (not sure on names sorry) BUT then I'm splitting my logic between the dataset, stored procedure and the form....and breaking the rules of centralising....

Hence I thought maybe I should look to do it in the stored procedure....but as you say that means the user doesn't get a mice message and warning......so confused


GeneralRe: Stored Procedures - Validating Variables Pin
Pete O'Hanlon14-Sep-07 1:39
mvePete O'Hanlon14-Sep-07 1:39 
GeneralRe: Stored Procedures - Validating Variables Pin
Michael Potter14-Sep-07 4:56
Michael Potter14-Sep-07 4:56 
AnswerRe: Stored Procedures - Validating Variables Pin
DerekFL14-Sep-07 9:14
DerekFL14-Sep-07 9:14 
Questionstored procedure replace function problem Pin
soniasan13-Sep-07 1:08
soniasan13-Sep-07 1:08 
AnswerRe: stored procedure replace function problem Pin
Joe13-Sep-07 2:03
Joe13-Sep-07 2:03 
AnswerRe: stored procedure replace function problem Pin
andyharman13-Sep-07 7:16
professionalandyharman13-Sep-07 7:16 
GeneralRe: .. Pin
Pete O'Hanlon13-Sep-07 23:03
mvePete O'Hanlon13-Sep-07 23:03 
GeneralRe: .. Pin
Joe14-Sep-07 0:29
Joe14-Sep-07 0:29 
GeneralRe: .. Pin
Pete O'Hanlon14-Sep-07 1:35
mvePete O'Hanlon14-Sep-07 1:35 
QuestionSQL stored porcedures Pin
OS GIKEN12-Sep-07 22:26
OS GIKEN12-Sep-07 22:26 
AnswerRe: SQL stored porcedures Pin
Pete O'Hanlon12-Sep-07 22:54
mvePete O'Hanlon12-Sep-07 22:54 
AnswerRe: SQL stored porcedures Pin
Frank Kerrigan13-Sep-07 6:11
Frank Kerrigan13-Sep-07 6:11 
AnswerRe: SQL stored porcedures Pin
Paul Conrad14-Sep-07 19:20
professionalPaul Conrad14-Sep-07 19:20 
QuestionQuery not returning distinct value Pin
miniThomas12-Sep-07 19:35
miniThomas12-Sep-07 19:35 
AnswerRe: Query not returning distinct value Pin
ritu432112-Sep-07 20:13
ritu432112-Sep-07 20:13 
GeneralRe: Query not returning distinct value Pin
/randz12-Sep-07 23:25
/randz12-Sep-07 23:25 
AnswerRe: Query not returning distinct value Pin
Michael Potter13-Sep-07 4:46
Michael Potter13-Sep-07 4:46 

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.