Board index » delphi » MS SQL Server stored proc parameter problem
ih...@aol.com (IH101)
Delphi Developer |
Wed, 13 Oct 1999 03:00:00 GMT
MS SQL Server stored proc parameter problemFellow Delphians (and especially those also dabbling in MS SQL Server I am having a big problem with a query called by a stored proc - it is not Here is the query that works in ISQL/W: SELECT Here is the stored proc that always returns 0 through its default CREATE PROC sp_mpoilf Here is the code I use to obtain the value: with stpOilF do The @Field parameter _does_ contain the correct ('Coalinga') value when Here is the code I use to retrieve the value: tblMPPrintOilnCond.Value := stpOilFCOLUMN1.Value; But the table always contains 0, as the stored procs result is 0. Does Clay Shannon, |