I have this update SQL query(See below). Tho it keep saying "Operation must use an updateable query". Any ideas on wats wrong with the code? Thanks


UPDATE TEST_DOC SET TEST_DOC.DataSet = (Select IFF_Descriptions.DataSet FROM IFF_Descriptions WHERE IFF_Descriptions.Field1 = "MPI_CORE_IFF")
WHERE TableName="MPI_CORE_IFF";

Where is this data coming from?

"WHERE TableName="MPI_CORE_IFF"

Also, the query would see this as:

"WHERE TableName=" since the last part is not in proper quotes. You would need:

"WHERE TableName='MPI_CORE_IFF';"

Here is the whole thing:

"UPDATE TEST_DOC SET TEST_DOC.DataSet = " & _
 "(Select IFF_Descriptions.DataSet FROM IFF_Descriptions " & _
 "WHERE IFF_Descriptions.Field1 = 'MPI_CORE_IFF') " & _
 "WHERE TableName='MPI_CORE_IFF'"

Did any of that help?




mmcdonal

Look it up at: http://wrox.books24x7.com