UNION QUERY

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim B - 25 Aug 2006 00:44 GMT

Hello All,

A UNION SQL query is not updateable - fair enough. Is there any way of
loading a UNION query into a client side ADO recordset and detatching the
recordset from the database, thus allowing it to be updated (the recordset).
NB There is a column with a unique value.

I've tried cloning the recordset and closing the original. Obviously I'm
using the adOpenDynamic, adLockOptimistic parameters to open the recordset,
which I presume is right.

Any assistance would be greatly appreciated.

TIA

Tim

Reply to this Message

Dmitriy Antonov - 25 Aug 2006 02:49 GMT

> Hello All,
>
[quoted text clipped - 12 lines]
>
> Tim

Do you mean updateable recordset but not underlying table(s)? If yes then
you can read discussion, which happened in this NG on Aug.2 this year with a
subject "Copy Recordset". There are, at least, two methods there, which
allow you to make a True, independent and totally disconnected, updateable
copy of recordset.

Dmitriy.

Reply to this Message

Tim B - 25 Aug 2006 08:12 GMT

Thanks, It was very late last night and I didn't do any searches which I
should have. sorry. The thread looks good and I'll give it a go.

Cheers

Tim

>> Hello All,
>>
[quoted text clipped - 20 lines]
>
> Dmitriy.

Reply to this Message

VB Forum / Database Access / August 2006

UNION QUERY