Re: Pro*C, Update
From: Arto Viitanen <arto.viitanen_at_csc.fi>
Date: Tue, 01 Nov 2005 09:39:50 +0200
Message-ID: <43671bc6$0$22411$ba624cd0_at_newsread.funet.fi>
Date: Tue, 01 Nov 2005 09:39:50 +0200
Message-ID: <43671bc6$0$22411$ba624cd0_at_newsread.funet.fi>
Groju wrote:
> Hello.
>
> I have a problem and i hope i post in good group.
>
>
> EXEC SQL UPDATE CLIENT SET
> lcliargos ="test update",
> norue="2",
> cplnorue='',
> typrue='',
> rue="La Place",
> cpost="59570",
> comne="GUSSIGNIES",
> csegmarch ="P",
> csiret ="39136479100015"
> WHERE ccliargos=60000004 ;
>
>
SQL uses ' to quote strings. " is reserved to mark names that are not normally allowed, like in
SELECT d33 "Candy Store", t4 "Teller"
FROM sales
to mark better names for the attributes.
-- Arto Viitanen CSC, FinlandReceived on Tue Nov 01 2005 - 08:39:50 CET