[AccessD] Update Query Problem in Access 2000 ADP

BOL = Books OnLine, the help for SQL Server.
 
Charlotte Foust

	-----Original Message-----
	From: Liam Meadows [mailto:accessd-bounces at databaseadvisors.com]
On Behalf Of Liam Meadows
	Sent: Monday, July 28, 2003 7:58 AM
	To: Access Developers discussion and problem solving
	Subject: RE: [AccessD] Update Query Problem in Access 2000 ADP
	
	
	Sorry to appear daft but what is BOL ?
	 
	This was the old Access code
	 
	UPDATE TBLstock INNER JOIN ViewPOLNTGrouped ON
TBLstock.Partnumber = ViewPOLNTGrouped.Partnumber SET
TBLstock.OnOrderQty = [TBLstock]![OnOrderQty]+[ViewPOLNTGrouped]![POQty]
	WHERE (((ViewPOLNTGrouped.POTransfered)=False));
	
	 
	How do you use stored procedures ?
	 
	Regards
	 
	Liam

		-----Original Message-----
		From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Geller
		Sent: 28 July 2003 16:35
		To: Access Developers discussion and problem solving
		Subject: RE: [AccessD] Update Query Problem in Access
2000 ADP
		
		
		I would execute a stored procedure to do that.  The SQL
in the sproc would be similar to an update query in access.  Looks in
BOL for a sample of a SQL server update query.  Let me know if you don't
know how to execute a sproc from your adp.
		 
		--Susan
		 

			-----Original Message-----
			From: Liam Meadows
[mailto:liam at energyexhausts.co.uk] 
			Sent: Monday, July 28, 2003 4:58 AM
			To: Access Developers discussion and problem
solving
			Subject: RE: [AccessD] Update Query Problem in
Access 2000 ADP
			
			
			Its not the view I want to update but use the
views grouped value to update the stock table
			 
			How would you update a field in one table based
on a field in another linked by partnumber. ?
			( Not as simple as access update query)
			 
			So TBLstock.OnorderQty.value =
VIEW1.TotalQty.value + TBLstock.OnorderQty.value with join of Partnumber
			(Above ref only).
			 
			 
			Liam

				-----Original Message-----
				From:
accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Arthur Fuller
				Sent: 25 July 2003 06:58
				To: 'Access Developers discussion and
problem solving'
				Subject: RE: [AccessD] Update Query
Problem in Access 2000 ADP
				
				
				AFAIK you cannot update such a view from
an ADP file. Since it is grouped the best you can do (with work) is
update the GroupBy fields. Of course you can do it behind the scenes
with a SQL statement but not from the form. It will take executing an
update query.
				 
				Arthur
				 
				 -----Original Message-----
				From:
accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Liam Meadows
				Sent: July 24, 2003 2:21 PM
				To: accessd at databaseadvisors.com
				Subject: [AccessD] Update Query Problem
in Access 2000 ADP
				
				

				Is there anyway around the problem I
have in ADP update queries. I suppose I have been to use to Access MDB's
but I am having problems trying to update a field from another field.

				Firstly I have a view (VIEW1) which is a
grouped query listing partnumbers and an onorder qty total 
				VIEW1 
				         Partnumber 
				         POQTY 

				I want to update the stockfile onorder
qty by onorder qty+poqty 

				STOCK 
				         Partnumber 
				         OnOrderQty = OnOrderQty+
View1POQty 

				Can anyone assist ???? 

				Liam 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030728/d9391609/attachment-0001.html>