1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

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,276
    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