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.