[Help]Select Distinct problem from VB

I've run into a major problem. The following statement works fine from SQL Plus (Oracle) but when ran from VB it hangs the application. The statement works fine when there is only one matching record. However, if there are more than one matching record (the reason for having the Distinct statement) then the app hangs from VB (5.0, SP3).

Here's the SQL statement:
UPDATE MYTABLE SET MYFIELD =
    (SELECT DISTINCT OTHFIELD FROM TABLE2     WHERE FIELD3 = 'myval')
WHERE MYFIELD2 = 'myotherval'

Any ideas?

--


==========================================================================

The Timinator - ttrimble_at_nojunk.fda.net (personal)  ICQ#: 1685060
http://www.timinator.com
"My Reality Check Bounced!"
(Remove the "nojunk" if you want to send me mail)


==========================================================================