SQL Statement Question

Message from Eidson Matthew W Contr AFFTC/ITASC via eLinkGuru's,Any idea on why this statement runs fine in SQL*Plus but errors out in aAuto LiveReport?select awddate, initiated, awddate - initiated as "Duration" from wfview;Thanks,Matt EidsonAFFTC/ITASCLivelink Integrator/Developer - Network Systems AnalystTybrin CorporationOffice: 661-275-3704Mobile: 661-810-6091Nextel DC: 122*11*6004

Find more posts tagged with

Comments

eLink User

Message from Bhupinder Singh via eLinkIf you are using "Duration" as a column alias, try:select awddate, initiated "Duration", awddate from wfview;- Bhupinder-------------------------------------------------------------------------Bhupinder Singh, B.Math., B.Ed. Customer SupportOpen Text Corporation Waterloo, Ontario, CanadaCustomer support e-mail: support@opentext.comCustomer Support Telephone: 800-540-7292------------------------------------------------------------------------------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Monday, March 31, 2003 8:29 PMTo: eLink RecipientSubject: SQL Statement QuestionSQL Statement QuestionPosted by eLink on 03/31/2003 08:29 PMMessage from Eidson Matthew W Contr AFFTC/ITASC via eLinkGuru's,Any idea on why this statement runs fine in SQL*Plus but errors out in aAuto LiveReport?select awddate, initiated, awddate - initiated as "Duration" from wfview;Thanks,Matt EidsonAFFTC/ITASCLivelink Integrator/Developer - Network Systems AnalystTybrin CorporationOffice: 661-275-3704Mobile: 661-810-6091Nextel DC: 122*11*6004[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

eLink User

Message from Sean M. Alderman via eLinkI think he was trying to do a subtraction with the values from awddateand initiated and call the result "Duration"On Tue, 2003-04-01 at 10:51, eLink Discussion: Livelink LiveReportsDiscussion wrote:> RE SQL Statement Question> Posted by eLink on 04/01/2003 10:51 AM> > Message from Bhupinder Singh via eLink> > > If you are using "Duration" as a column alias, try:> > select awddate, initiated "Duration", awddate from wfview;> > - Bhupinder> > -------------------------------------------------------------------------> Bhupinder Singh, B.Math., B.Ed. Customer Support> Open Text Corporation Waterloo, Ontario, Canada> Customer support e-mail: support@opentext.com> Customer Support Telephone: 800-540-7292> -------------------------------------------------------------------------> > -----Original Message-----> From: eLink Discussion: Livelink LiveReports Discussion> [mailto:livereportsdiscussion@elinkkc.opentext.com]> Sent: Monday, March 31, 2003 8:29 PM> To: eLink Recipient> Subject: SQL Statement Question> > > SQL Statement Question> Posted by eLink on 03/31/2003 08:29 PM> > Message from Eidson Matthew W Contr AFFTC/ITASC> via eLink> > Guru's,> > Any idea on why this statement runs fine in SQL*Plus but errors out in a> Auto LiveReport?> > select awddate, initiated, awddate - initiated as "Duration" from wfview;> > Thanks,> > Matt Eidson> AFFTC/ITASC> Livelink Integrator/Developer - Network Systems Analyst> Tybrin Corporation> Office: 661-275-3704> Mobile: 661-810-6091> Nextel DC: 122*11*6004> > [To reply to this thread, use your normal e-mail reply function.]> > ============================================================> > Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&> objAction=view> > Livelink Server:> https://knowledge.opentext.com/knowledge/livelink.exe> > [To reply to this thread, use your normal e-mail reply function.]> > ============================================================> > Topic: SQL Statement Question> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=3008481&objAction=view> > Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=view> > Livelink Server:> https://knowledge.opentext.com/knowledge/livelink.exe--Sean M. AldermanITRACK Systems AnalystPACE/NCI - NASA Glenn Research Center(216) 433-2795If Machiavelli were a programmer, he'd have worked for AT&T.

eLink User

Message from Eidson Matthew W Contr AFFTC/ITASC <<A HREF="mailto:Matthew.Eidson@edwards.af.mil">Matthew.Eidson@edwards.af.mil> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Sean,

Yes, that was my intent.

Thanks,

Matt Eidson
AFFTC/ITASC
Livelink Integrator/Developer - Network Systems Analyst
Tybrin Corporation
Office: 661-275-3704
Mobile: 661-810-6091
Nextel DC: 122*11*6004

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, April 01, 2003 8:11 AM
To: eLink Recipient
Subject: Re RE SQL Statement Question

Re RE SQL Statement Question		Posted by eLink on 04/01/2003 11:10 AM
In reply to: RE SQL Statement Question		Posted by eLink on 04/01/2003 10:51 AM

Message from Sean M. Alderman <sean.m.alderman@grc.nasa.gov> via eLink

I think he was trying to do a subtraction with the values from awddate
and initiated and call the result "Duration"

On Tue, 2003-04-01 at 10:51, eLink Discussion: Livelink LiveReports
Discussion wrote:
> RE SQL Statement Question
> Posted by eLink on 04/01/2003 10:51 AM
>
> Message from Bhupinder Singh <bsingh@opentext.com> via eLink
>
>
> If you are using "Duration" as a column alias, try:
>
> select awddate, initiated "Duration", awddate from wfview;
>
> - Bhupinder
>
> -------------------------------------------------------------------------
> Bhupinder Singh, B.Math., B.Ed. Customer Support
> Open Text Corporation Waterloo, Ontario, Canada
> Customer support e-mail: support@opentext.com
> Customer Support Telephone: 800-540-7292
> -------------------------------------------------------------------------
>
> -----Original Message-----
> From: eLink Discussion: Livelink LiveReports Discussion
> [mailto:livereportsdiscussion@elinkkc.opentext.com]
> Sent: Monday, March 31, 2003 8:29 PM
> To: eLink Recipient
> Subject: SQL Statement Question
>
>
> SQL Statement Question
> Posted by eLink on 03/31/2003 08:29 PM
>
> Message from Eidson Matthew W Contr AFFTC/ITASC
> <Matthew.Eidson@edwards.af.mil> via eLink
>
> Guru's,
>
> Any idea on why this statement runs fine in SQL*Plus but errors out in a
> Auto LiveReport?
>
> select awddate, initiated, awddate - initiated as "Duration" from wfview;
>
> Thanks,
>
> Matt Eidson
> AFFTC/ITASC
> Livelink Integrator/Developer - Network Systems Analyst
> Tybrin Corporation
> Office: 661-275-3704
> Mobile: 661-810-6091
> Nextel DC: 122*11*6004
>
> [To reply to this thread, use your normal e-mail reply function.]
>
> ============================================================
>
> Discussion: Livelink LiveReports Discussion
> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&
> objAction=view
>
> Livelink Server:
> https://knowledge.opentext.com/knowledge/livelink.exe
>
> [To reply to this thread, use your normal e-mail reply function.]
>
> ============================================================
>
> Topic: SQL Statement Question
> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=3008481&objAction=view
>
> Discussion: Livelink LiveReports Discussion
> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=view
>
> Livelink Server:
> https://knowledge.opentext.com/knowledge/livelink.exe
--
Sean M. Alderman
ITRACK Systems Analyst
PACE/NCI - NASA Glenn Research Center
(216) 433-2795

If Machiavelli were a programmer, he'd have worked for AT&T.

eLink User

All,

I got the statement to run. I accidentally left the ";" on the end of the SQL statement in the report.

Thanks,

Matt Eidson
AFFTC/ITASC
Livelink Integrator/Developer - Network Systems Analyst
Tybrin Corporation
Office: 661-275-3704
Mobile: 661-810-6091
Nextel DC: 122*11*6004

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, April 01, 2003 8:47 AM
To: eLink Recipient
Subject: RE Re RE SQL Statement Question

RE Re RE SQL Statement Question		Posted by eLink on 04/01/2003 11:47 AM
In reply to: Re RE SQL Statement Question		Posted by eLink on 04/01/2003 11:10 AM

Message from Eidson Matthew W Contr AFFTC/ITASC <Matthew.Eidson@edwards.af.mil> via eLink

Sean, Yes, that was my intent. Thanks, Matt Eidson
AFFTC/ITASC
Livelink Integrator/Developer - Network Systems Analyst
Tybrin Corporation
Office: 661-275-3704
Mobile: 661-810-6091
Nextel DC: 122*11*6004 -----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, April 01, 2003 8:11 AM
To: eLink Recipient
Subject: Re RE SQL Statement Question

Re RE SQL Statement Question		Posted by eLink on 04/01/2003 11:10 AM
In reply to: RE SQL Statement Question		Posted by eLink on 04/01/2003 10:51 AM