Questions tagged [procedures]
262 questions
1
vote
0 answers
MySQL error 1142 DROP command denied
I can't drop a table from a procedure.
This is the procedure in which it gives me the error.
CREATE PROCEDURE `procDropAllTables`()
BEGIN
DECLARE table_name VARCHAR(255);
DECLARE end_of_tables INT DEFAULT 0;
DECLARE cur CURSOR FOR
…
Soundbite
- 93
- 4
- 11
1
vote
1 answer
MySQLdump hangs with routines
I am trying to use a bat file to do a complete copy of a database to a different database. There are procedures and functions which need to be transferred over which is my biggest problem.
When I use
mysqldump -u user -p password db1 -v -R | mysql…
Conflict
- 13
- 3
1
vote
2 answers
MySQL date calculation and selecting greater than 55
I have calculated age from date of birth but I would like to select greater than 55 only in a stored procedure. Below is what I have done.
DELIMITER //
CREATE PROCEDURE p6()
BEGIN
SELECT Firstname, Lastname, telephone_number,…
Ameen
- 50
- 9
1
vote
1 answer
Procedures and functions in C
From what I have learned, there is a difference between a function and a procedure. I know that a function returns a value whereas a procedure just executes commands one after the other. Today on the other hand, my professor stated that we can also…
Module
- 250
- 2
- 13
1
vote
3 answers
Why does this Python code work as it does? Please explain
In the CS101 course at Udacity, the trainer demonstrates procedures in Python by writing the following code to print out the bigger number of the two parameters n1 & n2
def bigger(n1,n2):
if n1 > n2:
return n1
return n2
So, for…
Ricardo Pomalaza
- 27
- 1
- 7
1
vote
3 answers
Multiple records in a table matched with a column
The architecture of my DB involves records in a Tags table. Each record in the Tags table has a string which is a Name and a foreign kery to the PrimaryID's of records in another Worker table.
Records in the Worker table have tags. Every time we…
sahibeast
- 341
- 3
- 13
1
vote
1 answer
Oracle Bind Variables, Procedures and a headache
I am wondering if you can point me in the right direction. I have spent the last little while trying to work out how to use Bind Variables in block code with declares. My issues is that every time I try run the code block in SQL Developer, its…
Doug
- 547
- 10
- 23
1
vote
1 answer
Why am I getting an Ada error?
This is, as you could tell, a programming assignment for a class. It's far over due and I'm not getting any points however there is a test coming up soon and I'd rather like to know how to use the specific functions in ADA. The program is…
C0C0B
- 11
- 2
- 4
1
vote
1 answer
How to access object variables between sub in Access
I have an access module sub() that is creating several hundred statistic lists via queries. I began with using the recordset method to create the list then transfer the values to an excel spreadsheet. My problem is that I get an error that my…
CrossFunction
- 15
- 3
1
vote
0 answers
Select count return 0 mysql JDBC
I'm trying to store messages, so i create 2 tables in mysql with HeidiSql, the first one is msg and the second one is users. I wrote a store procedure to get the number of messages that have as sender the first parameter, as recipient the second…
Caco85
- 23
- 6
1
vote
1 answer
Working with strings in Pascal
Please. help me determine how many small and big letters "s" and the sign "=" occurs in a given text. Print lines in which these characters are missing.
How do I implement validation text and how to recognize the line where there is no such…
Luchnik
- 1,067
- 4
- 13
- 31
1
vote
2 answers
How to call a procedure from inside another procedure
There is this link How do I Invoke a procedure when inside another procedure in Pascal But its not exactly my case.
procedure TForm1.Button1Click(Sender: TObject);
var
[...]
begin
// click on button
[...]
end;
and I have this procedure…
user1986815
1
vote
1 answer
Making calculator in Pascal with procedures
As title says, I've just learned something called procedures in Pascal, but i bumped in one problem. So, calculator is simple and it has only 4 operations (still learning procedures). The problem is when you type in operation (+, -, * or /) it just…
eqaL
- 15
- 1
- 1
- 3
1
vote
0 answers
SSRS report - main dataset sproc executes once FOR EACH dynamic default parameter
I've been trying to get around this issue, and was hoping someone here might have paced the same problem.
My SSRS report has some default parameters that are set dynamically. What is happening is that when a report page is first opened (these…
Ben
- 337
- 1
- 6
- 20
1
vote
1 answer
plsql procedure to compare two tables where structure of table is not known
So the problem goes like this:
I have a table with two columns namely source query and target query.
each row contains a sql query for a informatica mapping from source side and target side and we needed to build a reconciliation procedure which…
Egyptian
- 63
- 1
- 3
- 9