Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Visual Basic ( VB ) (http://www.go4expert.com/forums/visual-basic/)
-   -   stored procedure (http://www.go4expert.com/forums/stored-procedure-t714/)

techlearner 13Apr2006 01:31

stored procedure
 
Hello,

I am working on a VB/SQL application. I have to insert records from VB forms to MS sql tables which are linked via ADO. Considering the constraints of the fields and around 36 total fields in the tables, I am not sure what would be the best and optimal option:-
1. Use an MSSQL stored procedure with all the validation checks and call in the event.
2. Use a VB global function with all the validation checks and call in the respected event.
3. Write the code directly in the event function as and when required.
I would appreciate it if someone can help with my problem.

Thanks in advance.

shabbir 13Apr2006 06:45

Re: stored procedure
 
Duplicate of Stored Procedure. Thread closed.


All times are GMT +5.5. The time now is 15:18.