?

Log in

No account? Create an account
Solution to tricky problem requires automation - A Suburbs Boy Living a Country Life [My Flickr Photos]
December 24th, 2007
12:41 pm

[Link]

Previous Entry Share Next Entry
Solution to tricky problem requires automation

(6 comments | Leave a comment)

Comments
 
From:(Anonymous)
Date:December 24th, 2007 05:48 pm (UTC)
(Link)
[User Picture]
From:happypete
Date:December 24th, 2007 05:57 pm (UTC)

Another problem

(Link)
I actually can't do the query with this, because I really need some sort of sequence or unique ID for the update query side of things. "First, last" is not a valid primary key [is not unique, and is null for some business entries without a name field].

However, this example might give you ideas.

The only likely unique id I can find is an OLE Object "EntryID." Apparently, though, you can't include OLE Objects in UNION queries.
Powered by LiveJournal.com