Stored Procedure on SQL 6.5

Results 1 to 2 of 2

Thread: Stored Procedure on SQL 6.5

  1. #1
    Keith Mar Guest

    Default Stored Procedure on SQL 6.5

    Hi guys-<BR><BR>I&#039m using a form to update fields in an SQL database using a stored procedure. I&#039m using the command object, then creating all the parameters. Problem is, it seems to be sticking the wrong field information into the field. Is there a specific order that you need to create paramters in to make it work correctly? I&#039d appreciate any help or suggestions. Thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: Stored Procedure on SQL 6.5

    From my experience, you have to append the parameters in the order they are declared in the SP. In theory you might be able to do the refresh thing and then won&#039t have to put them in order, but I have never tried that :)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts