Stack Overflow
Stack Overflow

Questions tagged [procedures]

262 questions
0
votes
2 answers

sql run querys since procedures

I tried do query since one procedure in mysql I followed the following: DELIMITER # CREATE PROCEDURE returndata(IN xtable CHAR(255), IN xcolumn CHAR(255)) BEGIN IF (xcolumn = 'XALL') THEN SELECT * FROM xtable; ELSE …
MindLerp
  • 378
  • 1
  • 3
  • 15
0
votes
0 answers

Using Triggers and Procedures to change active inventory

First starting with this table: Table estoque_folha And your records: Records My complete database code : pastebin.com/v30s9Aa1 I wanted to know how a trigger / procedure for when the quantidade field is zero, the line stow with fild ativo == 1 ,…
Vitor
  • 3
  • 1
0
votes
1 answer

Visual Basic Calling Procedures

I'm having a bit of trouble with calling procedures in my program. Basically, it is a program designed to encode a user inputted message based on a key input and it works perfectly fine when I do not define any functions or procedures and everything…
user5750023
0
votes
2 answers

MySQL Stored Function

I am trying to create a stored procedure in mySQL Workbench. The goal is to clean-up/standardize a field that reside in ad hoc tables that get loaded. Here is a snippet of the code....many many Update lines missing. CREATE…
John K
  • 1
  • 1
0
votes
0 answers

How to make "local" the label in a 8086 procedure?

The problem is that some (many) labels have the same name, in particular: there are many procedures and each works properly if run "isolated" from the others. In fact, the labels used in different procedures have all the same common names such as…
shogitai
  • 1,823
  • 1
  • 23
  • 50
0
votes
1 answer

I can't seem to declare variables inside this procedure

I can't get this code to work, i keep getting syntax errors, and i don't see anything wrong with the declare sentences. delimiter // create procedure Plsql1 (Count int) begin CREATE TABLE alumnos( …
Antonio Quijano
  • 87
  • 1
  • 1
  • 4
0
votes
1 answer

PL/SQL PROCEDURE name is already used by an existing object

so i wrote down a procedure which should take 2 parameters name and death age. After that it checks if the value of the age is null where name is ... . If it is null it should update the table if not give a following message. But after trying to…
abudabi123
  • 1
  • 1
0
votes
0 answers

Stored Procedure Declarations

In the code below, CREATE PROCEDURE UserCheck ( IN param1 VARCHAR(32) ) BEGIN DECLARE var1 INT(10); what is the difference between param1 and var1?
Dave
  • 37
  • 7
0
votes
1 answer

Read from file and find max c#

I have started learning c# just over 3 months so for homework I have an exercise where i have to read from a text file with 50 names and marks. I have to find the name with the highest mark display it and save the result to a text file.This is what…
jane.doe
  • 1
0
votes
2 answers

Variable addition is being ignored within a method

The premise is moving a character around a grid based upon their choice of direction and the value of a dice roll. The function CalculateMove is being called within PrepareMove. Within CalculateMove the variable finishX or finishY are added or…
euan jones
  • 121
  • 2
  • 7
0
votes
1 answer

Adding a Multiplies joins

I have a problema with this proc. if @p_func = '1' begin SELECT isNull(ts.num_reserva,0) as num_reserva ,ts.des_dia ,ts.des_mes ,ts.des_ano ,ts.num_sala ,th.des_hora_inil ,th.des_hora_finl ,ts.des_nome …
user5543828
0
votes
1 answer

How to write a procedure to execute set of queries automatically

I have written a procedure to grant permissions on all the tables of a particular schema to rest other schemas. create or replace PROCEDURE GRANTS_PROC IS CURSOR GRANTS_CURSOR IS SELECT 'GRANT SELECT, INSERT, UPDATE,…
sabarish jackson
  • 149
  • 3
  • 10
0
votes
1 answer

Stored proc that picks a stored procedure from a list in a table and executes it in an oracle db?

Is it possible, if yes, what would the syntax look like for a stored proc which would pick a stored procedure from a list in a table and then executes it in an oracle db?
darlene levielle
  • 1
  • 3
0
votes
0 answers

Procedures and system calls in MIPS

This program asks the user for an integer then it jumps to check511 label. There it checks whether the given number is greater or smaller than 511. If it's greater than 511 it returns 1 else it returns 0. After this it goes back to Print label and…
user3593450
0
votes
1 answer

Netlogo Procedure n-of 2 neighbors

I am trying to write a procedure in Netlogo that first identifies two random neighbors of a red patch, and then changes the two patches to blue. The patches on the grid are either red, blue or white. I put this code in the "to go" section and…
sugarquebert
  • 1
  • 1
1 2 3
…
17 18