We perform an update of one table's field depending on results of a joined
query. In fact, any record in the result of the join which relates to the target
table has its corresponding target record updated. I can do this easily in
Paradox QBE, in SQL (MS-Access 2.0), and can write the SQL for Paradox, but the
BDE won't action it. What can I do?

TIA for any help.

--

Regards

James Lyon
Aztec Business Solutions (Coventry)

Voice:  +44 (0)1203 702500      Email:  Ja...@aztec.co.uk
Fax:    +44 (0)1203 702501      (Or:    CompuServe 100423,2175)
Mobile: 0374 899652
Snail:  Enterprise House, Courtaulds Way, Coventry, UK. CV6 5NX

: We perform an update of one table's field depending on results of a
: joined query. In fact, any record in the result of the join which
: relates to the target table has its corresponding target record up-
: dated. I can do this easily in Paradox QBE, in SQL (MS-Access 2.0),
: and can write the SQL for Paradox, but the BDE won't action it. What
: can I do?

What was the SQL statement you were trying to use? What was the result?
That is, what did you mean by "BDE won't action it?" Error message?

--
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
_/ Steve Koterski               _/   The opinions expressed here are    _/
_/ koter...@borland.com         _/         exclusively my own           _/
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/