Youre looking to do a trigger it sounds like... there are a million examples on the web on how to build an SQL trigger. Use your friend google to help you out there...
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
(Click the logo to view our site)
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ephraim Feldman
Sent: Tuesday, June 12, 2012 4:18 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Squirrel SQL Client
The issue is when the update is from a different table
On Tue, Jun 12, 2012 at 8:53 AM, Vic Drecchio
<vic.drecchio@...>wrote:
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
(Click the logo to view our site)
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ephraim Feldman
Sent: Tuesday, June 12, 2012 4:18 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Squirrel SQL Client
The issue is when the update is from a different table
On Tue, Jun 12, 2012 at 8:53 AM, Vic Drecchio
<vic.drecchio@...>wrote:
> **[Non-text portions of this message have been removed]
>
>
> It's the same syntax as SQL:
>
> UPDATE UD10 SET SHORTCHAR01 = 'VIC_IS_COOL' WHERE KEY1 = 'XYZ'
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of effgroups@...
> Sent: Monday, June 11, 2012 9:49 PM
> To: Vantage Yahoo Group
>
> Subject: Re: [Vantage] Squirrel SQL Client
>
> No offence taken. And thanks for your concern.
>
> But I do know how to update databases and also I only update UD tables
> and fields
>
> My question came in squirrel since in MSSQL its done differently than
> in the JDBC for progress.
>
> I need to update a UD table based on a field in another table but I
> can't do a join in a update so I did a SET with a select statement.
> But based on the value in the second table I need to decide if to
> update the field or not.
>
> Now I'm thinking that I can use the same select in the WHEN to
> condition the update. I will try tommorow.
>
> Thanks
> Ephraim Feldman
>
> -----Original Message-----
> From: Jose Gomez <jose@... <mailto:jose%40josecgomez.com> >
> Sender: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Date: Mon, 11 Jun 2012 21:36:36
> To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
> Reply-To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: Re: [Vantage] Squirrel SQL Client
>
> I would STRONGLY recommend that you do not update the DB from SQL
> specially if you don't know how to do it yourself. That is a
> horrendous idea.
> No offense.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@... <mailto:jose%40josecgomez.com>
> http://www.josecgomez.com <http://www.linkedin.com/in/josecgomez>
> <http://www.facebook.com/josegomez>
>
> <http://www.google.com/profiles/jose.gomez>
> <http://www.twitter.com/joc85>
>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
> On Mon, Jun 11, 2012 at 9:24 PM, Ephraim Feldman <effgroups@...
> <mailto:effgroups%40gmail.com> >wrote:
>
> > **
> >
> >
> > Hi All
> >
> > We are on Progress Db and i use Squirrel for my querries to see date
> > in
> the
> > DB (Much easier than creating BAQ for everything i want to see)
> >
> > My question is how do i create a conditional Update to a field when
> > i
> rty
> > updating my UD tables on some condition in another field.
> >
> > Can someone guide me with this
> >
> > Thanks
> >
> > Ephraim
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access.
> )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2178 / Virus Database: 2433/5063 - Release Date:
> 06/11/12
>
>
> [Non-text portions of this message have been removed]
>
>
>
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links