Error 3073, Operation must use an updatable query

Error 3073, Operation must use an updatable query

Post by Chris Wagne » Fri, 28 Mar 1997 04:00:00



I have a problem that is driving me nuts.  I have been porting a VB3 app to
VB5 (Enterprise edition) and the following
query will pull an error when executed on the open database.  Running the
exact query in access (2.0) on the same database
works fine.  Is there something that I am missing?  Please help.

This is the query in question:

UPDATE DISTINCTROW ((((ACCT_PRF_READ LEFT JOIN ACCT_PRF ON
ACCT_PRF_READ.ACCT_ICN = ACCT_PRF.ACCT_ICN) LEFT JOIN COMMON ON
ACCT_PRF.AP_FREQ = COMMON.ICN) LEFT JOIN ACCT_PRF_DIM ON ACCT_PRF.ACCT_ICN
= ACCT_PRF_DIM.ACCT_ICN) LEFT JOIN COMMON AS COMMON_1 ON
ACCT_PRF.AP_STR_TYPE = COMMON_1.ICN) LEFT JOIN COMMON AS COMMON_2 ON
ACCT_PRF_DIM.ACV_CODE = COMMON_2.CODE SET ACCT_PRF_READ.FREQUENCY =
[COMMON].[CONFIRM], ACCT_PRF_READ.TYPE = [COMMON_1].[CONFIRM],
ACCT_PRF_READ.VOLUME = [COMMON_2].[CONFIRM], ACCT_PRF_READ.SEQUENCE =
[COMMON].[SEQUENCE];

Chris Wagner
Fastech, Inc.

 
 
 

1. Operation must use an updatable query 3073 - ODBC Error

I am using VB6 to and SQL Server 7.0    .. I can read from the DB fine but
when I try to do a delete statement it gives me the error :  Operation must
use and updatable query error # 3073  ...

the thing is that it works fine from the query analyzer .. when I cut and
paste the code to vb .. it dosen't ..

I also can't use the insert statement from VB either ... it gives me a 3158
error 'Insert on linked table ??? failed' .. but the table isn't a linked
table .. and also works fine from the query analyzer ...

any suggestions ??

2. SQL Server XML View Mapper

3. Operation must use an updatable query. (Error 3073)

4. error 7138

5. Run time error 3073 -Operation must use an updatable query

6. North Carolina-Oracle Systems Analyst/Programmer

7. ** Unify/ACCELL in Denver **

8. Error 3073 - Operation must use an updatable query

9. Error 3073 : Updatable Query required

10. "Error 3073: Operation must use an updatable Query" message for Update/Delete with CDaoDatabase / CDaoRecordSet

11. Run-time error '3073' Operation must use an updatable query.