Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
osirisa
Constraint Violating Yak Guru
289 Posts |
 Posted - 2009-07-06 : 10:43:08
|
Good Morning Group:I have the following dilema. I am building an application with an already in place database. Number one Problem with this database is inconsistence. I have to create an application front end that is using several tables from this database. This table needs to be in agreement with a hidding table. The Front End Table is called Approver Table field are:id , Location_Code, Application_Name, Resp_Begin_With, Approver_Main, Approver_UserId How can I create a Trigger that gets update when the user enter a new approver name or update an already exist one (from Approver Table).Any help is greatly appreciate it. Thank you. |
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-07-06 : 11:00:59
|
| so you want to have two tables, one for the front end and other hidden by DBA's? |
 |
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2009-07-06 : 11:10:05
|
| I know, sounds crazy. Unfortunate, the way that this database has been created is a little confuse. On the front end they are using a querie out design, instead of ussing the full name of the application they are using a querie. when they manually query out this hidding table the result can be something around 1,500 records. So, really I don't know a better way to update the hidding table or to enter new records unless I use some kind of trigger. Thanks for your comments. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Need Help on Logic - finding the best way