MS-SQL Trigger Mgr in .net (ID:1504)
Project Creator: |
RoyalImaging
FC Member For 6695 Days
Credits 20 Completed Proj. Num. 0 / 1 Total payment USD Avg Daily Online 0.00 h (From 21/5/2007) Available on MSN/Skype No Last Login 10/29/2006 Peers Rating 0.00% ![]() ![]() ![]() |
---|---|
Budget: | Not Sure/Confidential |
Created: | 10/27/2006 12:31:40 PM EST |
Bidding Ends: | 11/3/2006 12:31:40 PM EST ( Expired ) |
Development Cycle: | 14 Days |
Bid Count: | 13
|
Average Bid: | 342.69 |
Project Description:
Application Specs: Prefer VB.NET or C# Create and modify trigger per table (would need to be able to switch to different tables) Actions will be based on field values Goal ¡¡¡¡Would like to create a user friendly application that can add, update, or delete ¡¡¡¡triggers on table. This application will manage specific triggers that will notify a ¡¡¡¡person if field values match a criteria. Example logic: ¡¡¡¡If field1 = “abc” and field2 = “1234 and field3 = “john” then ¡¡¡¡¡¡¡¡Email john@royalimaging.net ¡¡¡¡If field1 =”xyz” then ¡¡¡¡¡¡¡¡Email mary@royalimaging.net ¡¡¡¡If field1 = “abc” and field 3 = “hank” then ¡¡¡¡¡¡¡¡Email hank@royalimaging.net ¡¡¡¡If field1 = “abc” or Field1 = “xyz” or field 4 = “smith” ¡¡¡¡¡¡¡¡Email harry@royalimaging.net ¡¡¡¡If field1 = “abc” or Field1 = “xyz” and field 4 = “smith” ¡¡¡¡¡¡¡¡Email sarah@royalimaging.net Interface: ¡¡¡¡Flexible on GUI. Would like to be able to view and modify all information (fields ¡¡¡¡and values) per table Architecture: ¡¡¡¡Will only need to manage SQL server triggers via a SQL connection (dbo rights) |
|
Job Type | .NET |
Attached Files: | 20061027123035.pdf |