dynamicupdatecommand returns "Bad Combination of Field(s) in DELETE statement"

[wizardo]

hi,

i have a simple table named Actual with two fields:

CityActual_Desc

CityActual_No

i am using dynamicupdatecommand in a macro to delete all rows where CityActual_No is null

SET Result = ActiveDocument.DynamicUpdateCommand ("DELETE FROM Actual WHERE IsNull (CityActual_No)")
if Result = false then
MsgBox Result.ErrorMessage
end if

when i run this i get "Bad Combination of Field(s) in DELETE statement" error msg

anyone knows what im missing here?

Mansyno

-sample attached

[#2]

I understand this was many years ago but I had this issue and it has to do with the table that you are trying to modify having a synthetic key assigned to it.  If you remove the synthetic key by reorganizing your data model you should no longer get this error.