Problem with Query

Sorry I didn't meant to be cryptic. It was bolded, I forget this list is plain text. Glad it helped.

Ken

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tim Dines
Sent: Thursday, December 01, 2011 2:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Problem with Query



Adding MFGSYS fixed the issue. Thanks a bunch for the quick help on this issue.

Tim

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Karen Schoenung <kschoenung@...<mailto:kschoenung@...>> wrote:
>
> FROM MFGSYS.PUB.PartTran PartTran_0
>
> I think the difference is you are missing MFGSYS
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Tim Dines
> Sent: Thursday, December 01, 2011 3:23 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Problem with Query
>
>
>
> So this is a formatting issue? Can I use a format string rather than an exact date to make this work?
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>, Ken Williams <kwilliams@<mailto:kwilliams@>> wrote:
> >
> > I had this same problem, ONLY with the PartTran table. Fortunately I documented it :).
> >
> > Note the difference between these two:
> >
> > Broken:
> > SELECT PartTran_0.TranNum
> > FROM PUB.PartTran PartTran_0
> > WHERE (PartTran_0.TranDate={d '2010-03-30'})
> >
> > Working:
> > SELECT PartTran_0.TranNum
> > FROM MFGSYS.PUB.PartTran PartTran_0
> > WHERE (PartTran_0.TranDate={d '2010-03-30'})
> >
> > Ken
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Tim Dines
> > Sent: Thursday, December 01, 2011 2:07 PM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Problem with Query
> >
> >
> >
> > I am trying to do what I think should be an easy query, but having no luck. Version is 8.03.408b on Progress 10.1b
> >
> > SELECT PartTran_0.PartNum, PartTran_0.TranDate, PartTran_0.TranQty
> > FROM PUB.PartTran PartTran_0
> > WHERE (PartTran_0.TranType='MFG-STK')
> > ORDER BY PartTran_0.TranDate, PartTran_0.PartNum
> >
> > When I attempt to save or run this query the error message says,'Syntax error in SQL Statement at or about "Systime, PartTran_0.Sysdate,PartTran_0." (10713)
> >
> > Does anyone know how to get around this issue? This query doesn't even use Systime. Thanks for your help.
> >
> > Tim Dines
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]
I am trying to do what I think should be an easy query, but having no luck. Version is 8.03.408b on Progress 10.1b

SELECT PartTran_0.PartNum, PartTran_0.TranDate, PartTran_0.TranQty
FROM PUB.PartTran PartTran_0
WHERE (PartTran_0.TranType='MFG-STK')
ORDER BY PartTran_0.TranDate, PartTran_0.PartNum

When I attempt to save or run this query the error message says,'Syntax error in SQL Statement at or about "Systime, PartTran_0.Sysdate,PartTran_0." (10713)

Does anyone know how to get around this issue? This query doesn't even use Systime. Thanks for your help.

Tim Dines
Where are you running this query from ODBC?


*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
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 Thu, Dec 1, 2011 at 4:06 PM, Tim Dines <tdines@...> wrote:

> **
>
>
> I am trying to do what I think should be an easy query, but having no
> luck. Version is 8.03.408b on Progress 10.1b
>
> SELECT PartTran_0.PartNum, PartTran_0.TranDate, PartTran_0.TranQty
> FROM PUB.PartTran PartTran_0
> WHERE (PartTran_0.TranType='MFG-STK')
> ORDER BY PartTran_0.TranDate, PartTran_0.PartNum
>
> When I attempt to save or run this query the error message says,'Syntax
> error in SQL Statement at or about "Systime,
> PartTran_0.Sysdate,PartTran_0." (10713)
>
> Does anyone know how to get around this issue? This query doesn't even use
> Systime. Thanks for your help.
>
> Tim Dines
>
>
>


[Non-text portions of this message have been removed]
I just ran that exact query on my side ODBC and it worked fine...
I also removed the Alias,...
SELECT PartTran.PartNum, PartTran.TranDate, PartTran.TranQty
FROM PUB.PartTran
WHERE (PartTran.TranType='MFG-STK')
ORDER BY PartTran.TranDate, PartTran.PartNum


*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
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 Thu, Dec 1, 2011 at 4:10 PM, Jose Gomez <jose@...> wrote:

> Where are you running this query from ODBC?
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> 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 Thu, Dec 1, 2011 at 4:06 PM, Tim Dines <tdines@...> wrote:
>
>> **
>>
>>
>> I am trying to do what I think should be an easy query, but having no
>> luck. Version is 8.03.408b on Progress 10.1b
>>
>> SELECT PartTran_0.PartNum, PartTran_0.TranDate, PartTran_0.TranQty
>> FROM PUB.PartTran PartTran_0
>> WHERE (PartTran_0.TranType='MFG-STK')
>> ORDER BY PartTran_0.TranDate, PartTran_0.PartNum
>>
>> When I attempt to save or run this query the error message says,'Syntax
>> error in SQL Statement at or about "Systime,
>> PartTran_0.Sysdate,PartTran_0." (10713)
>>
>> Does anyone know how to get around this issue? This query doesn't even
>> use Systime. Thanks for your help.
>>
>> Tim Dines
>>
>>
>>
>
>


[Non-text portions of this message have been removed]
Yes. It is an ODBC query from Excel. I do quite a lot of these without issue.

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> I just ran that exact query on my side ODBC and it worked fine...
> I also removed the Alias,...
> SELECT PartTran.PartNum, PartTran.TranDate, PartTran.TranQty
> FROM PUB.PartTran
> WHERE (PartTran.TranType='MFG-STK')
> ORDER BY PartTran.TranDate, PartTran.PartNum
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> 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 Thu, Dec 1, 2011 at 4:10 PM, Jose Gomez <jose@...> wrote:
>
> > Where are you running this query from ODBC?
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *checkout my new blog <http://www.usdoingstuff.com> *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > 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 Thu, Dec 1, 2011 at 4:06 PM, Tim Dines <tdines@...> wrote:
> >
> >> **
> >>
> >>
> >> I am trying to do what I think should be an easy query, but having no
> >> luck. Version is 8.03.408b on Progress 10.1b
> >>
> >> SELECT PartTran_0.PartNum, PartTran_0.TranDate, PartTran_0.TranQty
> >> FROM PUB.PartTran PartTran_0
> >> WHERE (PartTran_0.TranType='MFG-STK')
> >> ORDER BY PartTran_0.TranDate, PartTran_0.PartNum
> >>
> >> When I attempt to save or run this query the error message says,'Syntax
> >> error in SQL Statement at or about "Systime,
> >> PartTran_0.Sysdate,PartTran_0." (10713)
> >>
> >> Does anyone know how to get around this issue? This query doesn't even
> >> use Systime. Thanks for your help.
> >>
> >> Tim Dines
> >>
> >>
> >>
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
I had this same problem, ONLY with the PartTran table. Fortunately I documented it :).

Note the difference between these two:

Broken:
SELECT PartTran_0.TranNum
FROM PUB.PartTran PartTran_0
WHERE (PartTran_0.TranDate={d '2010-03-30'})

Working:
SELECT PartTran_0.TranNum
FROM MFGSYS.PUB.PartTran PartTran_0
WHERE (PartTran_0.TranDate={d '2010-03-30'})

Ken

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tim Dines
Sent: Thursday, December 01, 2011 2:07 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Problem with Query



I am trying to do what I think should be an easy query, but having no luck. Version is 8.03.408b on Progress 10.1b

SELECT PartTran_0.PartNum, PartTran_0.TranDate, PartTran_0.TranQty
FROM PUB.PartTran PartTran_0
WHERE (PartTran_0.TranType='MFG-STK')
ORDER BY PartTran_0.TranDate, PartTran_0.PartNum

When I attempt to save or run this query the error message says,'Syntax error in SQL Statement at or about "Systime, PartTran_0.Sysdate,PartTran_0." (10713)

Does anyone know how to get around this issue? This query doesn't even use Systime. Thanks for your help.

Tim Dines



[Non-text portions of this message have been removed]
So this is a formatting issue? Can I use a format string rather than an exact date to make this work?

--- In vantage@yahoogroups.com, Ken Williams <kwilliams@...> wrote:
>
> I had this same problem, ONLY with the PartTran table. Fortunately I documented it :).
>
> Note the difference between these two:
>
> Broken:
> SELECT PartTran_0.TranNum
> FROM PUB.PartTran PartTran_0
> WHERE (PartTran_0.TranDate={d '2010-03-30'})
>
> Working:
> SELECT PartTran_0.TranNum
> FROM MFGSYS.PUB.PartTran PartTran_0
> WHERE (PartTran_0.TranDate={d '2010-03-30'})
>
> Ken
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tim Dines
> Sent: Thursday, December 01, 2011 2:07 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Problem with Query
>
>
>
> I am trying to do what I think should be an easy query, but having no luck. Version is 8.03.408b on Progress 10.1b
>
> SELECT PartTran_0.PartNum, PartTran_0.TranDate, PartTran_0.TranQty
> FROM PUB.PartTran PartTran_0
> WHERE (PartTran_0.TranType='MFG-STK')
> ORDER BY PartTran_0.TranDate, PartTran_0.PartNum
>
> When I attempt to save or run this query the error message says,'Syntax error in SQL Statement at or about "Systime, PartTran_0.Sysdate,PartTran_0." (10713)
>
> Does anyone know how to get around this issue? This query doesn't even use Systime. Thanks for your help.
>
> Tim Dines
>
>
>
> [Non-text portions of this message have been removed]
>
FROM MFGSYS.PUB.PartTran PartTran_0

I think the difference is you are missing MFGSYS

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tim Dines
Sent: Thursday, December 01, 2011 3:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Problem with Query



So this is a formatting issue? Can I use a format string rather than an exact date to make this work?

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Ken Williams <kwilliams@...<mailto:kwilliams@...>> wrote:
>
> I had this same problem, ONLY with the PartTran table. Fortunately I documented it :).
>
> Note the difference between these two:
>
> Broken:
> SELECT PartTran_0.TranNum
> FROM PUB.PartTran PartTran_0
> WHERE (PartTran_0.TranDate={d '2010-03-30'})
>
> Working:
> SELECT PartTran_0.TranNum
> FROM MFGSYS.PUB.PartTran PartTran_0
> WHERE (PartTran_0.TranDate={d '2010-03-30'})
>
> Ken
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Tim Dines
> Sent: Thursday, December 01, 2011 2:07 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Problem with Query
>
>
>
> I am trying to do what I think should be an easy query, but having no luck. Version is 8.03.408b on Progress 10.1b
>
> SELECT PartTran_0.PartNum, PartTran_0.TranDate, PartTran_0.TranQty
> FROM PUB.PartTran PartTran_0
> WHERE (PartTran_0.TranType='MFG-STK')
> ORDER BY PartTran_0.TranDate, PartTran_0.PartNum
>
> When I attempt to save or run this query the error message says,'Syntax error in SQL Statement at or about "Systime, PartTran_0.Sysdate,PartTran_0." (10713)
>
> Does anyone know how to get around this issue? This query doesn't even use Systime. Thanks for your help.
>
> Tim Dines
>
>
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]
Adding MFGSYS fixed the issue. Thanks a bunch for the quick help on this issue.

Tim

--- In vantage@yahoogroups.com, Karen Schoenung <kschoenung@...> wrote:
>
> FROM MFGSYS.PUB.PartTran PartTran_0
>
> I think the difference is you are missing MFGSYS
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tim Dines
> Sent: Thursday, December 01, 2011 3:23 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Problem with Query
>
>
>
> So this is a formatting issue? Can I use a format string rather than an exact date to make this work?
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Ken Williams <kwilliams@<mailto:kwilliams@>> wrote:
> >
> > I had this same problem, ONLY with the PartTran table. Fortunately I documented it :).
> >
> > Note the difference between these two:
> >
> > Broken:
> > SELECT PartTran_0.TranNum
> > FROM PUB.PartTran PartTran_0
> > WHERE (PartTran_0.TranDate={d '2010-03-30'})
> >
> > Working:
> > SELECT PartTran_0.TranNum
> > FROM MFGSYS.PUB.PartTran PartTran_0
> > WHERE (PartTran_0.TranDate={d '2010-03-30'})
> >
> > Ken
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Tim Dines
> > Sent: Thursday, December 01, 2011 2:07 PM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Problem with Query
> >
> >
> >
> > I am trying to do what I think should be an easy query, but having no luck. Version is 8.03.408b on Progress 10.1b
> >
> > SELECT PartTran_0.PartNum, PartTran_0.TranDate, PartTran_0.TranQty
> > FROM PUB.PartTran PartTran_0
> > WHERE (PartTran_0.TranType='MFG-STK')
> > ORDER BY PartTran_0.TranDate, PartTran_0.PartNum
> >
> > When I attempt to save or run this query the error message says,'Syntax error in SQL Statement at or about "Systime, PartTran_0.Sysdate,PartTran_0." (10713)
> >
> > Does anyone know how to get around this issue? This query doesn't even use Systime. Thanks for your help.
> >
> > Tim Dines
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> [Non-text portions of this message have been removed]
>