#1
  1. No Profile Picture
    seven horses
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    Powys, Wales
    Posts
    61
    Rep Power
    11

    Delphi & SQL Server 7


    Has anybody come across a problem using TStoredProc to process a SQLServer Stored procedure. Where output parameters are used in making th procedure cal a message is returned asking for indicator variables that were not supplied but I cannot figure out how to define them. Any help appreciated.
    "Never trust an epigram"
  2. #2
  3. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    Woodland Hills, Los Angeles County, California, USA
    Posts
    9,593
    Rep Power
    4207
    http://textcontrol.com/tx/newsgroups...02/05/0002.htm

    Is it possible that your stored proc is sometimes returning a NULL somewhere
    Up the Irons
    What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
    "Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
    Down with Sharon Osbourne

    "I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    Bronx, New York City
    Posts
    3
    Rep Power
    0

    Talking Don't use TStored Procedure


    Use ADO Stored Procedure components.

    If I remember correctly TStored Procedure is a BDE based component. Its best to use ADO for M$ database product.

    HTH

IMN logo majestic logo threadwatch logo seochat tools logo