Helpful Information

Category: Delphi Programming

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.

http://textcontrol.com/tx/newsgroups/borland_public_delphi_database_sqlservers/2002/02/05/0002.htm

Is it possible that your stored proc is sometimes returning a NULL somewhere

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