this recordset is not updateable

[astraxan]

Hi, I have an sql query but when i try to edit anything, i get the message "the recordset is not updateable". why is that?



i have 2 tables: family 1---->oo members

and this is the query.

SELECT DISTINCT family.id, family.surname, family.city, family.phone
FROM family INNER JOIN members ON family.id=members.id
WHERE (((family.phone) In (SELECT [phone] FROM [family] As Tmp GROUP BY [phone] HAVING Count (*)>1) And (family.phone)<>"-"));

any ideas?

[kimmer]

It's your Group By clause... these are always read-only.

[astraxan]

The problem is with distinct. when i put it off, the query becomes updateable... but how can i hide repeated records?

[kimmer]

Are you sure you can update a query that groups? And yes, Distinct makes it read only also. I don't know if changing it to distinctrow will help, as I don't understandyour database.

http://allenbrowne.com/ser-61.html
http://cc.bingj.com/cache.aspx?q=mic...b4787,933dc42d
http://cc.bingj.com/cache.aspx?q=mic...979bd,9c1f71bf
http://cc.bingj.com/cache.aspx?q=mic...e8043,c33e94bb

[astraxan]

for example, if the two tables are these,

family

id surname city phone
1 brown london 11111
2 green paris 22222
3 yellow athens 33333
4 red berlin 22222


members

id id_memb name
1 1 george
2 2 john
2 3 mary
3 4 jim
4 5 helen

then the query WITHOUT distinct gives:

id surname city phone
2 green paris 22222
2 green paris 22222
4 red berlin 22222

[astraxan]

what i want to do, is to find duplicate records, but each one to be shown only once.

[astraxan]

It worked with DISTINCTROW!! thank you!