[AccessD] Updatable UNION?

Feared that might be the case. Ah well, always worth asking the list cos if
there's a way someone here will know it. Thanks for the response Gustav.
--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
To: accessd at databaseadvisors.com <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Updatable UNION?
Date: 18/11/04 10:59

>
> Hi Andy
>
> No, unions are read-only. If you can't go the update-behind-requery
> route, I guess you are left with the temp table.
>
> /gustav
>
> >>> andy at minstersystems.co.uk 18-11-2004 10:09:56 >>>
>
> Morning all
> I've a continuous screen which needs to list two types of order in
> date
> sequence. These are held on separate tables. No problem, a UNION query
> does
> the job fine. However the user has to tick an order to say it's
> despatched,
> and then the screen needs to show that information, but the recordset
> is not
> updatable. Presumably this applies to all UNION queries does it? Does
> anyone
> have a way round this or do I have to go to extracting to a temp table
> and
> all that jazz?
>
> By the way it's not practical to upodate the underlying tables and
> requery
> to display the depatch info because there's a lot of data on screen
> and
> requerying takes too long.
>
> --
> Andy Lacey
> http://www.minstersystems.co.uk
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
>

________________________________________________
Message sent using UebiMiau 2.7.2