1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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,287
    Likes Received:
    364
    Trophy Points:
    83
    Duplicate of [thread=715]Stored Procedure[/thread]. Thread closed.
     
Thread Status:
Not open for further replies.

Share This Page