stored procedure

Discussion in 'Visual Basic ( VB )' started by techlearner, Apr 12, 2006.

Thread Status:
Not open for further replies.
  1. techlearner

    techlearner New Member

    Joined:
    Apr 6, 2006
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    0
    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.
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    Duplicate of [thread=715]Stored Procedure[/thread]. Thread closed.
     
Thread Status:
Not open for further replies.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice