Subject | Newbie : Update with select statement |
---|---|
Author | Jenny Sigvardsdotter |
Post date | 2002-08-27T10:02:41Z |
Hi!
First I would like to say thanks to the replies I got
to my other questions. You helped me a lot.
I have a statment with an update. If I would write it
in T-sql I could use
UPDATE aktkonto
set batchid=:new_batchid,
from akt
where akt.aktid = aktkonto.aktid
and aktkonto.batchcode = 1
and akt.EBV = 1
But this is not acceptable in IB.
I use Interbase 5.6 How can I get the same
functionality?
Thanks
//Jenny
__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
First I would like to say thanks to the replies I got
to my other questions. You helped me a lot.
I have a statment with an update. If I would write it
in T-sql I could use
UPDATE aktkonto
set batchid=:new_batchid,
from akt
where akt.aktid = aktkonto.aktid
and aktkonto.batchcode = 1
and akt.EBV = 1
But this is not acceptable in IB.
I use Interbase 5.6 How can I get the same
functionality?
Thanks
//Jenny
__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com