Stack Overflow
Stack Overflow

Questions tagged [procedures]

262 questions
97
votes
11 answers

SQL Server - copy stored procedures from one db to another

I am new to SQL, and what I needed to do was to combine 2 .mdf databases into one. I did that using SQL Server 2008 Manager - Tasks > Import/Export tables.The tables and views were copied successfully, but there are no Stored procedures in the new…
Oak
  • 1,159
  • 3
  • 13
  • 21
34
votes
1 answer

How to program a MySQL trigger to insert row into another table?

I'm looking to create a MySQL trigger on a table. Essentially, I'm creating an activity stream and need to log actions by users. When a user makes a comment, I want a database trigger on that table to fire and: Grab the ID of the last inserted row…
Eric
  • 817
  • 2
  • 10
  • 17
10
votes
2 answers

How to run procedure from another unit?

Well this kind of n00b question but I still can't figure it out. I have unit main with procedure Discard() in it. Now I have another unit engine and I want to run from it procedure Discard() of unit main. I have main in uses section of engine.pas.…
Vlad
  • 337
  • 1
  • 7
  • 12
9
votes
1 answer

Reasons why PL/SQL Developer's debugger won't enter a procedure?

I am trying to debug a procedure using PL/SQL developer's built-in debugger. After stepping over the BEGIN, when the debugger is over the actual procedure call, the "step-into" button will just execute the procedure without entering it. Any…
Nico Mezeret
  • 193
  • 1
  • 1
  • 7
7
votes
1 answer

Is there a way to use ONE procedure for multiple buttons in Pascal?

I am looking for a way to use one procedure for multiple buttons. It's for a quiz like you have to press Button 1 for question 1, but copy and pasting the whole code for 36 buttons and changing the variables for 36 buttons isn't really fun for…
Pascalerino
  • 81
  • 4
6
votes
6 answers

How to execute stored procedure multiple times in C#

I have a time sheet app where users enter their time in/out for different days of the week. The form processes the in/out from each day, stuff them as parameters into a stored procedure and add them to the database. How would I accomplish this most…
dam
  • 171
  • 1
  • 6
  • 17
6
votes
4 answers

PHPMyAdmin: You might be lacking the necessary privileges to edit this routine

Error in processing request: No routine with name 'daily_difference' found in database 'chamelis_wp'. You might be lacking the necessary privileges to edit this routine.
Tasnim Khan
  • 207
  • 3
  • 12
6
votes
6 answers

Blocks & Procs in Ruby

I have started learning Ruby, and I have read a couple of tutorials and I even bought a book ("Programming Ruby 1.9 - The Pragmatic Programmers' Guide"), and I came across something new that I haven't seen before in any of the other languages I know…
Nilks
  • 446
  • 4
  • 14
6
votes
2 answers

How do I get Oracle, see what procedures are running?

Good afternoon. How do I get Oracle, see what procedures are running?
Daniel Sousa
  • 61
  • 1
  • 1
  • 4
6
votes
2 answers

How to use append-map in Racket (Scheme)

I don't fully understand what the append-map command does in racket, nor do I understand how to use it and I'm having a pretty hard time finding some decently understandable documentation online for it. Could someone possibly demonstrate what…
kjh
  • 3,407
  • 8
  • 42
  • 79
6
votes
2 answers

Assembly language: macros vs procedures

I'm new to assembly language and this question came across to my mind: Which is better solution for structuring my code, macros or procedures? While code included in a macro is just copied to the sections needed, and allowing executions of code…
Catalin Vasile
  • 367
  • 5
  • 17
6
votes
4 answers

The MySQL "DELIMITER" keyword isn't working

Ok so, I've been ripping my hairs ou on this one, why doesn't this work? DELIMITER | CREATE PROCEDURE Decrypt_pw() READS SQL DATA BEGIN SELECT 'Hey Select'; END| It's so basic and I'm pretty sure I'm using the correct syntax, what am I…
Pedro 'Xympa' Nascimento
  • 105
  • 1
  • 2
  • 8
5
votes
3 answers

How to use a case-when statement in a mysql stored procedure?

I want to set the session_id automatically using the request_time parameter so i opted for a mysql stored procedure that contains a case statement.Here goes. create procedure upd_userinput(in request_time timestamp, out user_session_id int) begin…
watkib
  • 347
  • 3
  • 11
  • 25
5
votes
2 answers

vba Show references to other procedures

Today i want to ask this question. say i have a module and in that module i call different procedures (subs or function ) which are located in other modules, how can i list all the procedure names and their module or class in a simple way in case i…
Ali_R4v3n
  • 377
  • 5
  • 15
5
votes
3 answers

Delphi - Calling procedure with optional VAR parameters?

Delphi 2010 - I have a routine which takes a string and processes it. There are 3 different types of processing, and I may need any combination, including all 3 ways of processing. I am trying to determine how to call my routine, but everything I…
user1009073
  • 3,160
  • 7
  • 40
  • 82
1
2 3
…
17 18