---
title: "[ADODC] Unknown error [ADO]"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/107357-adodc-unknown-error-ado"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Jesper T"
published: "2004-07-14T19:14:53.000Z"
updated: "2004-07-14T19:14:53.000Z"
replies: 0
views: 226
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/107357-adodc-unknown-error-ado"
---

# [ADODC] Unknown error [ADO]

## #1 — Jesper T, 2004-07-14T19:14Z

```
With a
    .RecordSource = "select proj_id, proj_name, proj_start, proj_end, proj_aut, proj_note, proj_active, case when now() BETWEEN COALESCE(proj_start, now()) AND COALESCE(proj_end, now()) then 'active' end from projects"
    .Refresh
End With
```

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/107357-adodc-unknown-error-ado