Delete query using a sqloledb connection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Whenever I try to execte a delete query using a sqloledb connection I get the
following message:
“The column prefix ‘WEBAPPS.DBO.MDUCMPLX_RANGES_VID' does not match with a
table name or alias name used in the queryâ€
Do I need to change the qyntax?
below is the query

DELETE FROM WEBAPPS.DBO.MDUCMPLX_RANGES_VID
WHERE WEBAPPS.DBO.MDUCMPLX_VID.VID = 27
 
Back
Top