Problem with DAO Field UPDATE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Cosmas - 17 Nov 2006 23:43 GMT

I have created a recordset using a SELECT statement that looks like this,
using DBOPENDYNASET

Set prstTest = CurrentDb.OpenRecordset("SELECT 0 AS IsSelected, * FROM
QRY_CUSTOMERS")

Later in my code, I would like to change to change/UPDATE the ISSELECTED
column from a 0 to 1. I used the .EDIT and set the value to 1, plus I added
the .UPDATE after I am done. Unfortunately, the row/column did not not get
updated. Help.

John
P.S. - The ISSELECTED is not part of the original table to QUERY; it is
added into the SELECT statement when opening the recordset

Reply to this Message

Allen Browne - 18 Nov 2006 10:49 GMT

John, this approach is not going to work.

You assigned a literal value to the field, but there is nowhere this value
is stored as Access pages the records in and out of memory.

You can verify that the field is not updatable like this:
Debug.Print prstTest.Fields("IsSelected").DataUpdatable

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have created a recordset using a SELECT statement that looks like this,
>using DBOPENDYNASET
[quoted text clipped - 10 lines]
> P.S. - The ISSELECTED is not part of the original table to QUERY; it is
> added into the SELECT statement when opening the recordset

Reply to this Message