Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kjaz11

    Parameter Double Prompting

    I have a crystal report which links to a stored procedure. The stored procedure accepts 1 parameter (siteid). The report works great, except that the siteid parameter is always blank with no choices. I've added both a table and command prompt, so I can dynamically choose the SiteID (not at...
  2. kjaz11

    Cannot Run Stored Procedure through Crystal

    I am using SQL Server 2000. I am not finding reference to REF CURSOR for SQL Server. What am I missing?
  3. kjaz11

    Cannot Run Stored Procedure through Crystal

    Here is the stored procedure with correct syntax: CREATE PROCEDURE [usp_PlayerLookup] @piPlayerID AS integer AS SELECT FirstName, MI, LastName FROM dbo.tbl_Player WHERE PlayerID = @piPlayerID GO
  4. kjaz11

    Cannot Run Stored Procedure through Crystal

    Here is the stored procedure: CREATE PROCEDURE [usp_PlayerLookup] @piPlayerID AS integer AS SELECT FirstName, MI, LastName, FROM dbo.tbl_Player WHERE PlayerID = @piPlayerID GO
  5. kjaz11

    Cannot Run Stored Procedure through Crystal

    I have a simple stored procedure that accepts one integer parameter. The stored procedure works fine in query analyzer. The database is SQL server 2000. I use crystal all the time to retrieve data from tables and views, but when I try a stored procedure (through the same odbc connection) I...

Part and Inventory Search

Back
Top