| |
by: Mike Miller |
last post by:
When you import data using DTS into a table that has triggers - do the triggers fire off if there are triggers for on insert or on after insert?
Thanks,
--Micah
|
by: Mark Flippin |
last post by:
I'm just starting to use triggers in my databases and find the support
in Enterpise Manager lacking.
Using Enterprise Manager and Query Analyzer you can maintain the
triggers, but it's cumbersome.
Are there better tools for creating and managing triggers?
Mark Flippin
|
by: William Payne |
last post by:
Ok, in my program I have a std::list<Document*>, where Document is one of my
own classes.
I need to go through this list and check each item if it's ready for
deletion. If it's not, skip to next, if it's ready I take steps to delete
it. The thing is that the list is part of a gui application and the system
removes the Document* from the list during the execution of the loop body.
That means I cant use iterators to iterate over the list....
|
by: tim.pascoe |
last post by:
I'm trying to generate scrips for a database, and everything so far has
worked fine, except for the triggers. When I try and script existing
triggers, all I get is a blank file - no SQL script. I tried single
files for each object, all in one file, triggers only, the entire
database. I can't figure it out, but I know the triggers are there.
Any suggestions, or am I missing something undocumented in SQL-Server
2000?
|
by: xtra |
last post by:
Hi Folk
I have about 1000 procedures in my project. Many, many of them are along
the lines of
function myfuntion () as boolean
on error goto er
'-
Dim Dbs as dao.database
Dim Rst as dao.recordset
|
| |
by: Lucky |
last post by:
hi guys!
Currently i'm facing a bit odd situation. i cant modify my code so i
have to make changes in SQL Server.
the problem is, i've modified one table by adding new column and now i
want only those row which has not null value in that column whenever
the select statement gets fire. i mean in every select statement only
those rows should be returned which has NOT NULL value in the newly
added column.
|
by: nDaKota |
last post by:
I am current converting PowerBuilder to C#. Now I'm having problem on triggers.
I understand what a triggers does.
The problem is what happens if a trigger is being triggered?
Example: I execute a trigger say "trigger A"so the current process executed in the queue is paused. Then i issue another trigger "trigger B".
Scenario 1: Considering the two triggers are not related. Upon issuing trigger B should trigger A be paused? Or Is it...
|
by: =?Utf-8?B?SmFrb2IgTGl0aG5lcg==?= |
last post by:
I am new to AJAX.
I am applying AJAX to a current web solution to get the "instant behaviour".
On my main page I have two sets of criteria: Specific and Wide.
Each set is placed in a View container.
I am not sure that I configured the Triggers correct, but the behaviour is OK.
When I click the linkbuttons they switch between two sets of search controls.
When I click the search buttons they reload the display panel.
BUT .... if the...
|
by: debasisdas |
last post by:
trigger sample code Ex#10
=======================
INSTEAD OF TRIGGER
----------------------------------------
create or replace trigger mytrig instead of delete or insert or update on eview
declare
a number(2);
begin
|
by: debasisdas |
last post by:
This thread contains some useful tips/sample codes regarding TRIGGERS in oracle, that the forum members may find useful.
TRIGGERS:
===============
Database trigger is a PL/SQL block that is executed on an event in the database.
The event is related to a particular data manipulation of a table such as inserting, deleting or updating a row of a table.
Triggers may be used :
1.To implement complex business rule, which cannot be...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
2
