Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cpark87

    Trigger Help

    I found this question posted and it basically is the same problem has mine.. Just looking to see if there is a fix or this is just an issue when using a front end like an access project http://www.tek-tips.com/viewthread.cfm?qid=535231
  2. cpark87

    Trigger Help

    I read that in an article and tried. My trigger doesn't currenty have the @@identity in it. The select @@identity is being picked up from the trace I ran and it only occurs when adding records to sql using access adp, data access page, or in sql enterprise manager. I haven't found a way to stop...
  3. cpark87

    Trigger Help

    ...int,@P6 datetime,@P7 nvarchar(7)', 123, N'123', N'123', N'123', 0, 'Jan 20 2005 2:13:49:000PM', N'parkxcx' go SELECT @@IDENTITY go exec sp_executesql N'SELECT * FROM (SELECT "tangram"."tblMapping_Sft".* FROM "tangram"."tblMapping_Sft") AS DRVD_TBL WHERE "AltNameID" = @P1', N'@P1 int', 415 go
  4. cpark87

    Update Trigger Write Conflict

    The first table is my standard table the second I am using for audit history. The trigger sits on the table tangram.tblIssueLog. The field a_issueID is not an identity field and is used to store the issueID from the main table. I am not currently running this through a stored procedure just on...
  5. cpark87

    Update Trigger Write Conflict

    Here is the trigger code: Create TRIGGER tangram.Insert_tblIssueLog ON tangram.tblIssueLog FOR INSERT AS Insert into tangram.tblIssueLog_Audit (a_IssueID, a_DivisionID, a_DeptID, a_CategoryDesc, a_Issue_Desc, a_Contact, a_DateFirstReported, a_Est_ResolutionDate, a_Actual_ResolutionDate...
  6. cpark87

    Update Trigger Write Conflict

    Refresh does not seem to be a valid command in a SQL Server Trigger. Do you have any additional info on the refresh command
  7. cpark87

    Update Trigger Write Conflict

    Have any of you run into this before.. I have an insert trigger on a table that takes the inserted record and copies all of the fields into an audit table to keep track of when someone inserts a record. However when using Access ADP and SQL Server I get an error on the table with the insert...
  8. cpark87

    Data Access Page - Redirecting Hyperlinks

    I've created a data access page with an inline frame. I am trying to redirect a hyperlink to the inline frame instead of a new window. I've added the code to move to a frame titled iFrm however it continues to open in a new window. Any ideas why this keeps happening.
  9. cpark87

    Data Access Page - Formatting Question

    How about performing this action with an Access Form??
  10. cpark87

    Formating a Continuous Form

    I have a continuous form where I would like to change the backgroud color for every other record. I've seen some example with conditional formatting but not sure if this will work. I would like to do this with code and not by some value present within the table.
  11. cpark87

    Data Access Page - Formatting Question

    I have created a data access page in a tabular format. The page works great however I have a lot of fields in the page which force the user to scroll horizantally. I would like to know if there is a way to add a freeze panes to the page like in excel. Or is there another way to arrange the page...
  12. cpark87

    Update Trigger Write Conflict

    I did want to mention that even know I got the error while trying to do the update, the changes did take affect. I also wanted to mention I received this error only in Access Project and not in Access 2002, 2003 or SQL Server Enterprise Manager. Ive decided to go with a different method on...
  13. cpark87

    Update Trigger Write Conflict

    Were you able to find a solution this problem. I am encountering the same issue.
  14. cpark87

    Question about Triggers

    Another question.. This trigger does work however I am using a Microsoft Access Project as the front end and I receive the following error in access but not in sql enterprise manager Key Column Information is incorrect or insuffient.. Too many rows affected by update.
  15. cpark87

    Question about Triggers

    I came up with this without needing the the temp table and joining through a common field that will not be updated CREATE TRIGGER Sft_Filtered ON tangram.XPC_Software_MasterList_Combined FOR UPDATE AS IF UPDATE (Sft_Filtered) BEGIN UPDATE tangram.XPC_Software_MasterList SET...
  16. cpark87

    Question about Triggers

    I am new to using Triggers and have create one using the code below. I need to enhance it thought and do not know how... CREATE Trigger ti_Filtered on tangram.XPC_Software_MasterList_Combined FOR Insert, Update AS Update XPC_Software_MasterList Set XPC_Software_MasterList.Sft_Filtered = 1...
  17. cpark87

    Combining Records

    Here is my current situation: Table called tblSoftware_Master I have fields within this table labeled Sft_Path and Sft_FileName. Many of the records in this table will have the same value for Sft_Path but different fileNames. I would like to create a view or sp that Groups Together the...
  18. cpark87

    Extracting data from a text value

    I would be running in SQL. Thanks for the feedback I will try doing some more research....
  19. cpark87

    Extracting data from a text value

    Thanks... That did work.. Say I wanted to trim off the \\SomeValue\ of that field and insert into a different table. I have seen some references on using the LEFT or RIGHT commands but usually referring to the amound of characters.
  20. cpark87

    Extracting data from a text value

    I know what you are saying.. If I was going one by one it would work... I wanted to try and run a query and build a relationship between the two tables to come up with a match. Here is an example... v_WIN_PRINTERS_T_TH.WPT_WPN_PORT = \\ATR110F03\PQ_CLP1620_TEST jetadmin.IPX_Name =...

Part and Inventory Search

Back
Top