Re: Updating a table

[Arjan Hoornstra <ahoor@YAHOO.COM>]

One more thing, since col1SQL is a char, have you set quotes in the
$building? Something similar to:

let $building = '"' || $building || '"'

and then

update [$_temptable] set col3 = #count where col1SQL = [$building]


--- Arjan Hoornstra <ahoor@YAHOO.COM> wrote:
> Have you tried it without [] like
>
> update [$_temptable] set col3 = #count where col1SQL = $building
>
> or
>
> update [$_temptable] set col3 = #count where col1SQL = $_building
>
> if it's a global variable...
>
> also you could try
>
> move 'where col1SQL = ' || $building to $where
>
> update [$_temptable]
> set col3 = #count
> [$where]
>
> Arjan
>
>
>
>
> --- Philippe Godin <philippe.godin@VIDEOTRON.CA> wrote:
> > My problem doesn't seem to come from the statement but from the
> > syntax since
> > update [$_temptable] set col3 = 52 where col1SQL = 'BAT02' works
> > and  both update [$_temptable] set col3 = 52 where col1SQL =
> > [$building]
> > or update [$_temptable] set col3 = #count where col1SQL =
> [$building]
> > doesn't...
> > I've checked and both variables contains data before entering the
> > update
> > clause.
> >
> > -----Message d'origine-----
> > De : Discussion of SQR, Brio Technology's database reporting
> language
> > [mailto:SQR-USERS@list.iex.net]De la part de Lu, Clint
> > Envoyé : 13 juin, 2001 12:19
> > À : SQR-USERS@list.iex.net
> > Objet : Re: Updating a table
> >
> >
> > A couple of things I can think of. First, do you use insert and
> > update
> > statements as the same program? if you do, then make sure to commit
> > after
> > you finish with insert before you do the update. Second, to check
> the
> > $building and #count variables to make sure that they have the
> values
> > that
> > you expect to update. On the other hand, comment out the update
> > statement to
> > see if the insert statement is working and then continue working
> with
> > update
> > statement. Hope this helps.
> >
> >
> >
> > Clint Lu
> > Sr. Programmer/Analyst
> > Caremark Rx, Inc.
> > Phone: (847) 559-4717
> > Fax    : (847) 559-4840
> >
> >
> > -----Original Message-----
> > From: Philippe Godin [mailto:philippe.godin@VIDEOTRON.CA]
> > Sent: Wednesday, June 13, 2001 10:15 AM
> > To: SQR-USERS@list.iex.net
> > Subject: Updating a table
> >
> >
> > Good day,
> >
> >     Does any of you out there have ever tried to update an SQL
> SERVER
> > 7.0
> > temporary table using variables?
> >     This is my problem, I'm trying to update a table that I've
> > created
> > likewise:
> >
> > CREATE TABLE [$temptable] (col1SQL varchar(30),col2 int,col3
> > float,col4
> > float,col5 float,col6 float,col7 float,col8 float,col9 float,col10
> > float,col11 float,col12 float,col13 float);
> >
> > $temptable is a timestamp.
> >
> > I succeed in doing inserts such as:
> >
> > insert into [$_temptable] values
> > ($building,#count,'','','','','','','','','','','')
> >
> > But can't get this to work:
> >
> > update [$_temptable] set col3 = #count where col1SQL = [$building]
> >
> > Sqr isn't giving any errors on this but put 0 everywhere in the
> table
> > instead of putting 52...
> >
> > I've tried different ways of using the varaibles such as putting
> them
> > within
> > [] etc. but can't get this to work
> >
> > It seems that the more strange it looks the best it's work.
> >
> > TIA
> > Philippe Godin
>
>
> __________________________________________________
> Do You Yahoo!?
> Spot the hottest trends in music, movies, and more.
> http://buzz.yahoo.com/


__________________________________________________
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/