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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by LTusing

  1. LTusing

    create sp to update foreign key identity columns

    Please disregard this post, I have read a few other postings which explained how update queries work with .adp databases and I think that update queries will be the best way to accomplish the task. Thank you!
  2. LTusing

    create sp to update foreign key identity columns

    I am trying to create a stored procedure that I can call when I have completed data entry for the assessments that occurred for a patient at a visit. I want the stored procedure to update the tbl_Patient_Visit with the FK identity columns found in each assessment table. Thus far I have...
  3. LTusing

    Best Practice triggers and referential integrity

    I have a table, Patient_Visit v_id (auto_id) (PK) date rater columnA(FK) columnB(FK) columnC(FK) with a 1:M relationship between multiple assessment tables. Each assessment table has a Unique Primary PK which is a FK in tbl.Patient_Visit (ex. column A[FK] There is also a FK (v_id) in each...
  4. LTusing

    cannot open requested database

    Thank you, I figured it out. Apparently, a trigger command which was being called at a similar time was conflicting with ability to call a similar named procedure. Thanks much!!
  5. LTusing

    updatetrigger for logging and update stored proc conflict

    Thank you for taking time to look at my code: This VB code calls the stored procedure to update data. Private Sub Update_Record_Click() Dim cnn As New ADODB.Connection Dim cmd As New ADODB.Command Dim rsConsent As New ADODB.Recordset Dim param1 As ADODB.Parameter Dim param2 As ADODB.Parameter...
  6. LTusing

    updatetrigger for logging and update stored proc conflict

    Yes, when calling the update stored procedure with the triggers in place, it responds unable to connect to 'mydatabase' OR it will state error 'invalid item' and will not edit data. However, if I remove the Update trigger, the command to call the update stored procedure will edit data without...
  7. LTusing

    updatetrigger for logging and update stored proc conflict

    I have an update trigger for each column in my tables that log when items are inserted, updated, and deleteted. I am also calling a stored procedure to update the tables and there seems to be a conflict. Both programs work when isolated but not one with the other. Does any one know how I may...
  8. LTusing

    Update stored procedure and Update Trigger ? Conflict

    I have an update trigger for a table and a VB command procedure which calls an update sql proc for editing of table fields. I am receiving an error message when updating fields noting that database is not available. However, if I delete the update trigger, and then populate the update...
  9. LTusing

    cannot open requested database

    I have an Access form connected to data located on SQL Server. The Access form contains a command button to call a SQLServer sproc. The command button works fine in another form that has the following datatypes: int and smalldatetime. However when adding the connection string in another form...
  10. LTusing

    passing string parameter via VB.ODBC.SQLServer

    I am trying to call a SQLServer 2000 proc to update .adp record columns. We are able to complete task for data and int columns but have run into difficulty in passing nvarchar and char columns. We are receiving error "Cannot open database"mydatabase" requested in login. Login Failed. The...
  11. LTusing

    Cant update Recordset

    I am having the same problem. I have an Access (.adp) project and all forms are unbound. My tables are located on SQL Server 2000 and communicate to Access Forms via ODBC/ADO. I have changed the property setting 'uniquetable' to the appropriate recordset for each form. Fields of tables on...
  12. LTusing

    updating sql table and returning value to .adp form

    Thank you much! lt
  13. LTusing

    UPDATE SQL SERVER Table procedure

    The enterprise manager states that the syntax is acceptable. However, I have a cmd procedure in VB that calls the proc_ConsentUpdate from an Access, 2003, Form (.adp). The table has the following fields: icd_id, pt_id, vdt_con, cons_dt, vdt_hip1, hipa_dt. I wish for the procedure to update 1...
  14. LTusing

    updating sql table and returning value to .adp form

    Thank you, very much. I have made all revisions and continue to be at a dead-lock. I am currently receiving message "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another". I have revised information from the ADO mapping site, as recommended. I...
  15. LTusing

    UPDATE SQL SERVER Table procedure

    I have copied the following code for updating/editing sql server 2000 table data, which has errors that I do not understand how to resolve. I would greatly appreciate guidance. CREATE PROCEDURE procConsentUpdate( @icd_id int = NULL, @pt_id int = NULL, @RetCode int = NULL OUTPUT, @RetMsg...
See more

Part and Inventory Search

Back
Top