Delete (access)

Jag blir inte klok på de felmeddelande som access spottar ut.

"Syntax error (missing operator) in query expression 'wm_pm WHERE messId IN ( 18 ) AND folderId 2 AND ( toMemberId 2 OR fromMemberId 2 )'."

I felmeddelandet tar den bort alla likhetstecken. Skriver jag ut sql-frågan så finns alla likhetstecken där. Vad betyder egentligen ovanstående felmeddelande som verkar vara ett standardmeddelande till alla fel.

sql =" DELETE wm_pm " & _
" WHERE messId IN ( " & messId & " ) " & _ 
" AND folderId = " & fId & " " & _
" AND ( toMemberId = " & memberId & " OR fromMemberId = " & memberId & " ) "

Utskrift:

DELETE wm_pm 
WHERE messId IN ( 18 )  
AND folderId = 2
AND ( toMemberId = 2 OR fromMemberId = 2 )

"DELETE FROM wm_pm WHERE messID = " & messId & " AND folderId = " & fId & " AND (toMemberId = " & memberId & " OR fromMemberId = " & memberId & ")"

cyprys skrev:

"DELETE FROM wm_pm WHERE messID = " & messId & " AND folderId = " & fId & " AND (toMemberId = " & memberId & " OR fromMemberId = " & memberId & ")"

Nej, för variabeln messId är en kommaseparerad sträng som kommer från val från checkboxar. I detta fallet var bara en checkbox ikryssad. Jag har använt IN och access tidigare så det ska inte vara några beskymmer.

:)

sql =" DELETE FROM wm_pm " & _
" WHERE messId IN ( " & messId & " ) " & _ 
" AND folderId = " & fId & " " & _
" AND ( toMemberId = " & memberId & " OR fromMemberId = " & memberId & " ) "

Sebbe skrev:

:)

sql =" DELETE FROM wm_pm " & _
" WHERE messId IN ( " & messId & " ) " & _ 
" AND folderId = " & fId & " " & _
" AND ( toMemberId = " & memberId & " OR fromMemberId = " & memberId & " ) "

Jo, jag såg att jag missat "FROM" när jag återgick till datorn efter en kort pause med lite frisk luft. Tack ändå Sebbe! :)