38 Topics
| |
Where is the SQL Server Database Trigger Wizard or Dialog Box? This question is about SQL Server In the past, I have created a stored procedure that was run on a timely basis by (if I remember correctly) a database trigger. As I recall, there was a wizard (dialog box … | |
Hello Could I please ask for assistance? I need a file that I am able to download that holds all the streets and postal codes of the Ireland. | |
I have a MySQL table that lists delivery records (customerId, date, quantity, productId, cost). I have a requirement to log certain items from the delivery table into a separate table to track items being sent to quarantined areas. All quarantined products must have a serialized tag affixed for tracking with … | |
I'm trying to create a trigger that does two things, first take an ip that's in dot notation and run inet_aton on it and put the result in another field. Second, checks a lookup table to identify an ip range that the result of the first action falls into and … | |
# MySQL Stored Routines: Another Useful Scenario # [In a past guide](http://blog.bobbyhensley.com/sql-procedures-functions-authentication-example/) I discussed MySQL stored routines within MySQL. Now I’m back with another guide on MySQL stored routines. And this time it’s a more concrete case; one that you may run into yourself in the future (or maybe you … | |
Funnily enough, I have absolutely no experience with MySQL foreign keys. I'd like to change that :) My database schema is rather complicated, and I have a lot of work ahead of me, but let's simplify things. Suppose I have **Members Table:** id (PRIMARY KEY) username first_name last_name company etc … | |
I have a code for countdown timer and it works perfectly fine.. <html> <title>project prelim</title> <head> <script type="text/javascript"> var ss = 10; function countdown() { ss = ss-1; if (ss<0) { window.location="testover.html"; } else { document.getElementById("countdown").innerHTML=ss; window.setTimeout("countdown()", 1000); } } </script> </head> <body onload="countdown()"> <center> <table width="100%" height="600px" style="text-align:center;"> <tr><td … | |
I am new in apex. I want to write a trigger in apex for before insert. I have to standard object (Contact, Opportunity). SELECT sum(amount), Bussiness__c from opportunity where stagename='Closed Won' and id='006i000000Kt683AAB' group by Bussiness__c I want when trigger runs this get sum(Amount) field and Bussiness__c value and then … | |
Hi, I am getting below error after triggering in my table. ORA-04098: trigger 'HRMS2.NTS_ADVERTISEMENTS_TRIGGER' is invalid and failed re-validation and the below is the query for triggering i used. create sequence nts_advertisements_seq start with 1 increment by 1 nomaxvalue; create trigger nts_advertisements_trigger delete insert on nts_advertisements for each row begin … | |
When I try to migrate from SQL Server 2000 to SQL Server 2008 R2 Express, when I run the application program there is an error message transaction aborted by the trigger, whereas before when I was using SQL Server 2000 does not exist error. after there was a note on … | |
Hi, Please look at this code <div class="box"> <a href="http:www.google.com" target="_blank">click</a> </div> //css .box { width:250px; height:250px; border:1px solid red; } //script $('.box').click(function(){ $(this).find('a').trigger('click'); }); How to set target _blank when clicking the div.box. click is working fine but it opens the page in same window. Can you anyone have … | |
I am completely new to Triggers but I hear they can help me with a specific problem. I have a table: picid picture recordListingID 1 danny.jpg 0 2 jane.jpg 0 3 ralph.jpg 0 In the recordListingID column (int) i would like to generate numbers sequentially upon an INSERT. Is it … | |
Hello all, I need help with part of an assignment that is due Sunday. This is my first week learning mySQL so clear and simple descriptions will be well liked. Here are the instructions. a)When adding a customer, add the customer's balance times the sales rep's commission rate to the … | |
hi I had a question in an exam that asked for the code of a trigger that cancels a transaction if a query result doesn't meet a condition in oracle database. is it possible? I am googleing but I can't find an answer thanks | |
I am creating a basic PM system for my website. I have just a basic table for a pm: mysql>describe PM; +--------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+----------------+ | PMID | mediumint(9) | NO | PRI | NULL | auto_increment | | … | |
I have a trigger(that prohibits the attribution of more than 10000 dollars to a worker that is not manager nor president) that i want to modify. CREATE OR REPLACE TRIGGER restrict_salary BEFORE UPDATE ON EMP FOR EACH ROW WHEN (new.sal > 10000) DECLARE job ename.job%type; BEGIN select job into job … | |
I'm new to triggers, but have been working with MySQL for quite a while. Now I need to implement a trigger. I want to create a trigger on my 'persons' table so that after an update, ***if the attribute clubid is changed***, attribute clubname should be changed. I have a … | |
Hi, i got tis trigger CREATE PROCEDURE updateG AFTER INSERT ON gnojidba FOR EACH ROW BEGIN DECLARE box int; SELECT quantity INTO box FROM stock WHERE name = NEW.name; IF (box >= NEW.Qty_value) THEN UPDATE stock SET quantity = (quantity-NEW.Qty_value) WHERE name = NEW.name; ELSE UPDATE 'Error!' SET x=1; END … | |
Hello everyone, im doing a small program where i have a stock table with my Items and the current stock status. How do i substract from that stock status when i insert a new order in my ordertable. My tables are: STOCK: Item_ID Stock status ORDER Item_FK: Qty So i … | |
Hi, I have this question about the control triggers, I have this project that have textbox, using it's textChanged function and setting the autopostback in to true. Now, when I trace the command I have notice that the function have been triggered twice, and I just want to know now … | |
I am trying to insert values from a table to another table. The thing is I want it such that only a row in the source table that does not exist in the destination table should be inserted. I have set each table to have a column that automatically increments … | |
I need help making this mysql trigger. I'm creating this student enrollment project and the trigger I need needs to check that there is no course schedule conflicts when a student enrolls in course. Everytime a student enrolls in a class a row is added to the courses database. I … | |
Hello Using MySQL, I have DB 1 with table T1 on Server 1 and DB 2 with table T1 on Server 2. Not on the same network and T1 contain the same columns with the same datatypes. I want to create a trigger on DB 1 so when there is … | |
I'm looking for an "auto-SMS VB.Net programme module" for window mobile 6.0 professional. my application will operate like below: 1. User required pair his hp bluetooth device with his car bluetooth device for first. 2. If the accident happened the car sensor will automatic trigger the car bluetooth device to … | |
hi, how can i trigger an update query on a certain record if that record was not update within last say: 1 minute???/ can i doit without using any scripting? if can't then php. | |
Hi, Is there a way to trigger F11 trough javascript or jquery so.. i can go into full-screen mode? If so how can i do it.? Thanx... | |
what;s wrong with this mysql trigger logically?? [CODE] DELIMITER | CREATE TRIGGER comment_count AFTER INSERT ON comments FOR EACH ROW BEGIN UPDATE sub_sections as t1 SET t1.published_comment_count = (select count(id) as cnt from comments where article_id=t1.id and published=0 and status=0) WHERE id= (select article_id from comments order by date_modified desc … | |
Hi, Actually I don't know if my question belongs in this topic or in the mysql topic. But I'm making a VB.net application with a mysql database and i have to make a trigger but I don't know where I have to use or implement it in my application. I … | |
Hi, Actually I don't know if my question belongs in this topic or in the VB.net topic. But I'm making a VB.net application with a mysql database and i have to make a trigger but I don't know where I have to use or implement it in my application. I … |
The End.