Stored Procedure

[Jigyasa]

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.

[YottaHertz]

Welcome to TechIMO!

First off, is this a web-based app? If it is you could use JavaScript to perform all the validity checks... I think the best way to go it terms of flexibility would be a stored procedure... PL/SQL

[Jigyasa]

Thanks for your reply. No, it is not a web based aplication. It's just a usual small office level application.
The only concern I had with using stored procedure was the number of arguments(which would be more than 36 for some inserts) that I would have to pass to the procedure from the VB GUI. Some tables have a lot of fields and to update or insert, the number of arguments thus would be a lot, unless I am thinking on the wrong or not so optimal lines. Any suggestions please.

Thanks very much for your help.

[jkrohn]

Quote:

If it is you could use JavaScript to perform all the validity checks...

Please for the love of god, NEVER use javascript to sanitize variables prior to use in SQL queries. Well unless you like SQL injection, in which case use javascript for your checks.

There really isn't a compelling case (performance wise) to dump it into a stored procedure. You should just drop it into the event code. DO NOT use a global function for this or anything else, ever.

Jkrohn