Search Results

Search found 3630 results on 146 pages for 'procedure'.

Page 12/146 | < Previous Page | 8 9 10 11 12 13 14 15 16 17 18 19  | Next Page >

• Finding the stored procedure that a Crystal Report is using

  - by Brandon

  I need to retrieve the name of the stored procedure that a crystal report is running. Is there any way to do this in C# using the CrystalDecisions.CrystalReports.Engine.ReportDocument object? I can't seem to find a property that will give me the stored procedure name. Is this even possible? I've been through almost all the properties I can think…

  Read the article

• SQL CLR Stored Procedure and Web Service

  - by Nathan

  I am current working on a task in which I am needing to call a method in a web service from a CLR stored procedure. A bit of background: Basically, I have a task that requires ALOT of crunching. If done strictly in SQL, it takes somewhere around 30-45 mins to process. If I pull the same process into code, I can get it complete in seconds due to…

  Read the article

• Pass Array to a MySQL stored procedure

  - by moustafa

  How can we pass an Array to a Stored Procedure in MySQL 5.1 so that I can use it like: Select column1 FROM table where column2 IN in_array Thanks

  Read the article

• One project in Delphi 2007 doesn't show procedure name in the IDE Obj Inspector's Events

  - by lgallion

  I have a Delphi project in 2007 that doesn't show the procedure names in the Object Inspector's Events such as Form OnClose, OnCreate or OnShow in the IDE. The code is there and if you click on OnCreate (for example) you are taken to the code and the IDE fills in the name of procedure. However on reload, the procedures are missing from the IDE…

  Read the article

• Step through mysql stored procedure

  - by Midhat

  Is it possible to step through a mysql stored procedure, watching the values of variables at each step.

  Read the article

• switch between two cursors based on parameter passed into stored procedure

  - by db83

  Hi, I have two cursors in my procedure that only differ on the table name that they join to. The cursor that is used is determined by a parameter passed into the procedure if (param = 'A') then DECLARE CURSOR myCursor IS SELECT x,y,z FROM table1 a, table2 b BEGIN FOR aRecord in myCursor LOOP …

  Read the article

• Procedure or function expects parameter which was not supplied

  - by eftpotrm

  Driving me mad on a personal project; I know I've done this before but elsewhere and don't have the code. As far as I can see, I'm setting the parameter, I'm setting its value, the connection is open, yet when I try to fill the dataset I get the error 'Procedure or function expects parameter "@test" which was not supplied'. (This is…

  Read the article

• Java framework "suggestion" for persisting the results from an Oracle 9i stored procedure using Apac

  - by chocksaway

  Hello, I am developing a Java servlet which calls an Oracle stored procedure. The stored procedure is likely to "grow" over time, and I have concerns the amount of time taken to "display the results on a web page". While I am at the implementation stage, I would like some suggestions of a Persistence framework which will work on…

  Read the article

• Stored Procedure in Entity Framework

  - by kamal

  Hi I had added the Stored procedure in my Entity framework and i also imported the functions in the edmx. Is it must to add all the three functions insert, update, and delete functions to a table. I had tried with insert alone and also with all, but why can't i get the name of the stored procedure in the connection string. Let…

  Read the article

• delphi tidhttp get procedure not working on some urls

  - by davy yabut

  Hi guys, I am encountering a problem in delphi Tidhttp component wherein the GET procedure cant fetch a specific url but on other urls it is working. Example this code cant fetch the error_url but if you change the error_url to any valid url its working: procedure TForm1.Button1Click(Sender: TObject); var Response :…

  Read the article

• Why SQL2008 debugger would NOT step into a certain child stored procedure

  - by John Galt

  I'm encountering differences in T-SQL with SQL2008 (vs. SQL2000) that are leading me to dead-ends. I've verified that the technique of sharing #TEMP tables between a caller which CREATES the #TEMP and the child sProc which references it remain valid in SQL2008 See recent SO question. My core problem remains a critical…

  Read the article

• Php mysqli and stored-procedure

  - by Mneva skoko

  I have a stored procedure: Create procedure news(in dt datetime,in title varchar(10),in desc varchar(200)) Begin Insert into news values (dt,title,desc); End Now my php: $db = new mysqli("","","",""); $dt = $_POST['date']; $ttl = $_POST['title']; $desc = $_POST['descrip']; $sql = $db-query("CALL…

  Read the article

• Delphi> Please explain this: type... procedure of object

  - by Richard Woolf

  I've encountered some code that's new to me... I've never really seen a type declaration of a procedure of object, and I just don't see the point. Why couldn't the developer simply keep a field of type Boolean? interface type TFinishedCaptureEvent = procedure(AFinished: Boolean) of object; …

  Read the article

• Stored Procedure to create Insert statements in MySql ??

  - by karthik

  I need a storedprocedure to get the records of a Table and return the value as Insert Statements for the selected records. For Instance, The stored procedure should have three Input parameters... 1- Table Name 2- Column Name 3- Column Value If 1- Table Name = "EMP" 2- Column Name = "EMPID" 3-…

  Read the article

• Stored procedure error when use computed column for ID

  - by Hari

  I got the error: Procedure or function usp_User_Info3 has too many arguments specified When I run the program. I don't know the error in SP or in C# code. I have to display the Vendor_ID after the user clicks the submit button. Where the thing going wrong here ? Table structure : CREATE…

  Read the article

• Why can we not execute a stored procedure inside a function

  - by anand-juventus

  Why can we not execute a stored procedure inside a function however the opposite is possible?

  Read the article

• Mysql stored procedure

  - by Nirmal

  How to create optional parameter in mysql stored procedure?

  Read the article

• MS SQL Server 2008 Stored Procedure Result as Column Default Value

  - by user337501

  First of all, thank you guys. You always know how to direct me when I cant even find the words to explain what the heck im trying to do. The default values of the columns on a couple of my tables need to equal the result of some complicated calculations on other columns in other tables. My first…

  Read the article

• Inline Conditional Statement in Stored Procedure

  - by Jason

  Here is the pseudo-code for my inline query in my code: select columnOne from myTable where columnOne = '#variableOne#' if len(variableTwo) gt 0 and columnTwo = '#variableTwo#' end I would like to move this into a stored procedure but am having trouble building the query correctly. I…

  Read the article

• Stored procedure does not return result when using Temp table

  - by Muhammad Akhtar

  I have used temp table in my stored procedure and unable to get the result when executing. It return result fine when running the same as query. my query structure is something like... ALTER PROCEDURE [dbo].[test] as begin SET NOCOUNT ON; SELECT * INTO #Dates FROM Dates -- Used temp table …

  Read the article

• Is it possible to execute stored procedure through a Linked server

  - by TonyP

  Is it posible to execute Oracle 10g stored procedure on a sql 2005 Linked Server.

  Read the article

• How to write stored procedure in SQL Server 2008 that generates 3 million random no

  - by anil

  How to write stored procedure in SQL Server 2008 that generates 3 million random no in two columns in integer datatype.

  Read the article

• What is the difference between remote procedure call and web service

  - by xiao

  Is there any clear definition about RPC and Web Service? A quick wikipedia search shows: RPC: Remote procedure call (RPC) is an Inter-process communication technology that allows a computer program to cause a subroutine or procedure to execute in another address space (commonly…

  Read the article

• Dynamically Specify Linked Server and DB Names in Stored Procedure

  - by hgulyan

  I have the same query in a stored procedure that needs to be executed on different servers and databases according to parameters. How can I arrange this without exec or sp_executesql? I'm using SQL Server 2008. Thank you. UPDATE I've found some links …

  Read the article

• Union All Won't work in stored procedure

  - by MyHeadHurts

  ALTER PROCEDURE [dbo].[MyStoredProcedure1] @YearToGet int AS Select Division, SDESCR, DYYYY, Sum(APRICE) ASofSales, Sum(PARTY) AS ASofPAX, Sum(NetAmount) ASofNetSales, Sum(InsAmount) ASofInsSales, …

  Read the article

< Previous Page | 8 9 10 11 12 13 14 15 16 17 18 19  | Next Page >