[procedure] Forum Topics

hello i need solution for to create a insert/select/delete/update stored procedure in mysql and how to call them from php currently i am using xampp 1.6.6 version of software thank you

Hi I have a stored procedure with a cursor which check if a field is filled in after a certain deadline. DELIMITER $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `controleDeadlines`() BEGIN #declaratie variabelen die nodig zijn declare cId int; declare cDeadline text; declare cUitgevoerd date; declare cOpmerking text; declare cStatus text; declare DONE …

Hi I have database in structure like below Newspaper State1 state2 state3 state4 ABC 1000 5684 5687 246 DEF 879 2547 2578 2357 But I need to the structure like below How can i change this Newspaper State copies ABC State1 1000 ABC State2 5684 ABC State3 5687 ABC State4 …

Hi i have issue in stored procedure converting data type Destination table dbo.Z_tbl_CirculationCopy_TEMP has numeric data type But source table Z_tbl_Import_temp have VarChar Type If I export data from source, I have error message Msg 8114, Level 16, State 5, Procedure Z_usp_IMPORT_EXCEL_UNPIVOT_1, Line 10 Error converting data type varchar to …

I am trying to create stored procedure which will insert one row in the first table and identity of inserted row in other two tables. For some reason I am receiving error "Procedure or function expects parameter '@id', which was not supplied.". My code is as follows: ALTER PROCEDURE InsertProf …

Hi, is it possible to combine Stored Procedure and Text Command Type in Select Statement? I have a stored procedure that compute available items, it quite a bit long select statement, now i need to call this statement in another select statement which is in text command type, how will …

Hi all I'm trying to write a Procedure to subtract days from a data but Ignoring weekends. This is what I have so far but I have a Syntax error Unexpected END, Expecting `;` I have put a ; after the last END but still get the same error. DELIMITER …

Hi guys, I'm still new to .NET and your answers to my questions have been so helpful. I have another question yet again, however. This time my question has to do with sql server and handling it with code behind. I am creating a stored procedure which is supposed to …

CREATE OR replace FUNCTION fn_findraise (dept_in IN VARCHAR2, salary_in IN FLOAT) RETURN NUMBER IS salaryraise NUMBER; BEGIN IF dept_in = 'MIS' THEN salaryraise := salary_in * .10; ELSIF dept_in = 'SALES' THEN salaryraise := salary_in * .15; ELSIF dept_in = 'HR' THEN salaryraise := salary_in * .20; END IF; RETURN …

HI All, I'm writing an application in Visual Basic .NET but the application will use a SQL backend. If the user runs the application and the backend database is not set up, I want the user to select a SQL Database Instance, supply an administrator user ID (sa) and Password …

Hey guys, We recently got a couple of new staff computers over here, and I generally just pull the older HDs out, archive them in the tech closet, and throw new ones in there before reinstalling and redistributing them to less fortunate staff members. I keep the old ones in …

I recently moved a script I created for Google Maps over from my development site and I changed the information in the mysqli line and now I'm recieving an error mesage -- any idea what's going on here? Here's the error message: [CODE]Warning: mysqli::mysqli() [mysqli.mysqli]: (28000/1045): Access denied for user …

Hi, Does anyone know on how to convert vb.net to excel. I am new in this company and they are using Microsoft SQL Server Management Studio for their database. FYI, they are using stored procedure as well. Thank you

Dear Sir/Madam, I have a small programe created in VB 6.0 and database MS Access. Where user can insert their only name & address and can retrieve the existing records. Just for test, I have kept this programe (.exe file and database file) in the share document of a computer …

hi guys! it's my first post on vb.net, it's just that u can't develop on windows 7 anymore using vb6, guess we'll just have to get used-huh. i'm developing this procedure using a timer object.the thing is the procedure is not in the timer's event procedure but i want it …

I am relatively new to delphi. what i am try to do it to open a new form from the main one as a pop-up window, let the user input certain values in there (two integers and a check box), and use these values as parameters in a procedure to …

hi, how to call code-behind function in java scrip. i am working on asp.net please help me to call the procedure with js. thanks in advance. jack

I have this program I'm trying to write, a simple application with gui: a menu and a button. Whenever I go to run it, this is the error I get: Traceback (most recent call last): File "/Users/[I]myname[/I]/Documents/School/Programming/Window.py", line 27, in <module> app = Application() File "/Users/[I]myname[/I]/Documents/School/Programming/Window.py", line 14, in __init__ …

Hi all, I have a procedure which needs to be used by a wide range of functions. I have a created a very basic program which should highlight my problem : [CODE] program untitled; function addnumbers(num1 : integer) : integer; begin result := num1 + 3; end; procedure sequence(I want …

I have created a procedure, exitFailure() that is invoked if a file doesn't exist: [CODE] int exitFailure() {//start exitFailure() printf("Failure, hit any key to exit and press enter.\n"); scanf("%d", &counterx); return 1; }//end exitFailure() [/CODE] Below is the snippit of code that invokes exitFailure() [CODE] inFile.open(inputFilename, ios::in); if (!inFile) { …