Search results for query: *

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...

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...

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...

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...

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...

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...

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...

I need to update a sql server 2000 table from an Access adp form. The form record set property 'unique table' is assigned; however the fields on the many side of the relationship are not updateable. I have developed VB code to call a SP via ado with lots of issues. Most currently I am stuck on...

I have created a sql sp with a cmd prompt to run sp with parameters to update form and receive error "parameter is improperly defined. Inconsistent or incomplete information was provided." I have posted code below and would appreciate input. Thank you! Private Sub Update_Record_Click() 'Declare...

I wish to update database data housed on sqlserver2K via Access 2003(.adp) front-end. My current codes is noted below for table: Consent:icd_id (int), pt_id(int), vdt_con (smalldatetime), cons_dt(smalldatetime), vdt_hip1(smalldatetime), hipa_dt(smalldatetime). My code thus far is not...