Board index » kylix » Re: Update

2004-12-07 06:10:20 AM
kylix0
Andreas Hausladen wrote:
currently available in Australia, I unfortunately don't get any time to
use them! Perhaps one day I keep telling myself!
--
** Currently looking for a couple of testers.
** More information in my blog!
+++++++++++++++++++++++++++++++++
Sneak Peek: JED, QC - IDE Edition at
www.alphalink.com.au/~jed/QC/
Blog: jedqc.blogspot.com/
 

IB 6.5
Can someone please correct below sql ?
UPDATE TABLE1 SET CURR=1.25
WHERE ( TABLE1.CUSTNO=TABLE2.CUSTNO AND
TABLE2.CURR='Euro' )
Thank You.
 

Henry Olive wrote:
UPDATE TABLE1 SET CURR=1.25
WHERE EXISTS (
SELECT 1 FROM TABLE2
WHERE TABLE1.CUSTNO=TABLE2.CUSTNO
AND TABLE2.CURR='Euro'
)
--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: www.logicfundamentals.com/RADBooks.html
It used to be that other people's achievements were considered an
inspiration, not a grievance.
 

{smallsort}

hi, is it easy to update to v10 and do some test and switch back to v9.0?
v9.0 it still my request developemnt version. thanks.
 

This is a multi-part message in MIME format.
no text
 

This is a multi-part message in MIME format.
Eric Grange wrote:

IB 6.02
I need something like below
UPDATE CK SET ID = GEN_ID(CK_ID, 1),
(IF TYP='D' THEN TYP='S' ELSE
IF TYP='R' THEN TYP='W' ELSE IF TYP='T'
THEN TYP='P'))
How can i do it ?
Thank you.
 

Henry wrote:
In IB 7.5 you can use CASE.
--
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
Delphi/InterBase Weblog : blogs.teamb.com/craigstuntz
IB 6 versions prior to 6.0.1.6 are pre-release and may corrupt
your DBs! Open Edition users, get 6.0.1.6 from mers.com
 

D7, IB 6.02
What is wrong with below SQL ?
UPDATE ODETAILS SET ODETAILS.COST=PARTS.COST
WHERE ODETAILS.PARTNO=PARTS.PARTNO
 

Stan wrote:
I suspect what you really want is:
UPDATE
ODETAILS
SET
ODETAILS.COST = (SELECT PARTS.COST
FROM PARTS
WHERE PARTS.PARTNO = ODETAILS.PARTNO);
--
Craig Stuntz [TeamB] ?Vertex Systems Corp. ?Columbus, OH
Delphi/InterBase Weblog : blogs.teamb.com/craigstuntz
All the great TeamB service you've come to expect plus (New!)
Irish Tin Whistle tips: learningtowhistle.blogspot.com
 

Stan wrote:
hth
--
Rob Schieck
TeamB
 

Stan wrote:
valid update statement because values from other tables need to be
*selected*.
UPDATE ODETAILS SET
ODETAILS.COST= (
SELECT PARTS.COST FROM PARTS
WHERE ODETAILS.PARTNO=PARTS.PARTNO
)
Note that this is a correlated subquery, it executes once for every ODETAILS
row to be updated. If you find this statement slow, it can be made much more
efficient in a stored procedure where you could do the following:
FOR
SELECT ODETAILS.PARTNO, ODETAILS.COST
FROM ODETAILS
INNER JOIN PARTS
ON ODETAILS.PARTNO=PARTS.PARTNO
INTO :PARTNO, :COST
DO BEGIN
UPDATE ODETAILS SET
ODETAILS.COST = :COST
WHERE ODETAILS.PARTNO=:PARTNO
END;
--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: www.logicfundamentals.com/RADBooks.html
"The legitimate powers of government extend to such acts only as are
injurious to others. But it does me no injury for my neighbor to say
there are twenty gods, or no God. It neither picks my pocket nor breaks
my leg." ?Thomas Jefferson
 

Eric Grange wrote:
after starting with runtime error 217. YMMV.
--
 

Eric
 

D7, IB 6,02
Part Name= AAAA XABC
How can i change just XABC to XXXX
That is, Part name should be 'AAAA XXXX'
Thank you.