---
title: "Delete (access)"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/76698-delete-access"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "K@llen"
published: "2003-05-12T14:59:57.000Z"
updated: "2003-05-12T16:20:56.000Z"
replies: 4
views: 191
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/76698-delete-access"
---

# Delete (access)

## #1 — K@llen, 2003-05-12T14:59Z

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 )
```

Permalänk: https://www.webforum.nu/p/76698

## #2 — cyprys, 2003-05-12T15:03Z

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

Permalänk: https://www.webforum.nu/p/1043875

## #3 — K@llen, 2003-05-12T15:06Z

> **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.

Permalänk: https://www.webforum.nu/p/1043877

## #4 — Sebbe, 2003-05-12T15:49Z

:)

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

Permalänk: https://www.webforum.nu/p/1043902

## #5 — K@llen, 2003-05-12T16:20Z

> **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! :)

Permalänk: https://www.webforum.nu/p/1043928

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/76698-delete-access