Cannot use Resource table in SQL Select

Yahoo Archive
1
Bad URL.



Here's the right page in the PDF for Progress Reserved Words:
http://bit.ly/140fBC9







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Vic Drecchio
Sent: Wednesday, July 31, 2013 4:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Cannot use Resource table in SQL Select





Ahh, makes sense. It was very smart of the developers to use reserved words
for table and field names. /sarcasm

Here's a complete list of Reserved Words in Progress if anyone is curious:
http://bit.ly/17UmN32

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
sosnowbored
Sent: Wednesday, July 31, 2013 4:20 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Cannot use Resource table in SQL Select

Unfortunately Resource is a reserved keyword in the Progress SQL server. To
access it you will need to escape it with double quotes like:

SELECT * FROM MFGSYS.PUB."Resource"

Also be aware that your permission scripts may have bombed when granting
ODBC users permission to that table. I could access it with sysprogress but
not my standard ODBC login until I wrapped the table name with double quotes
on my permission granting script.

Aragon

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"mmcwilliams22" <mmcwilliams22@...> wrote:
>
> Have a simple select statement where I can use about any other table but
as soon as I have SELECT Resource.ResourceID or any other Field from that
table I get an error. Is resourceID a property of something possibly and it
is trying to interpret it as such?
>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
Have a simple select statement where I can use about any other table but as soon as I have SELECT Resource.ResourceID or any other Field from that table I get an error. Is resourceID a property of something possibly and it is trying to interpret it as such?
3
What's the error? I've selected from that table many times...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
mmcwilliams22
Sent: Wednesday, July 31, 2013 1:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Cannot use Resource table in SQL Select





Have a simple select statement where I can use about any other table but as
soon as I have SELECT Resource.ResourceID or any other Field from that table
I get an error. Is resourceID a property of something possibly and it is
trying to interpret it as such?





[Non-text portions of this message have been removed]
4
Syntax error in SQL statement at or about "Resource.ResourceID From Mfgsys.Pub.Reso"(10713).

For testing I am just trying to get it to not error out using
sql = "SELECT Resource.ResourceID FROM Mfgsys.Pub.Resource"

I can plug in other tables and it does not error out.


--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> What's the error? I've selected from that table many times...
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> mmcwilliams22
> Sent: Wednesday, July 31, 2013 1:27 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Cannot use Resource table in SQL Select
>
>
>
>
>
> Have a simple select statement where I can use about any other table but as
> soon as I have SELECT Resource.ResourceID or any other Field from that table
> I get an error. Is resourceID a property of something possibly and it is
> trying to interpret it as such?
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
Try aliasing, sometimes SQL is a little B

SELECT A.ResourceID FROM Mfgsys.Pub.Resource A


*Jose C Gomez*
*Software Engineer*
*
*
*
*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 Wed, Jul 31, 2013 at 1:37 PM, mmcwilliams22 <mmcwilliams22@...>wrote:

> **
>
>
>
> Syntax error in SQL statement at or about "Resource.ResourceID From
> Mfgsys.Pub.Reso"(10713).
>
> For testing I am just trying to get it to not error out using
> sql = "SELECT Resource.ResourceID FROM Mfgsys.Pub.Resource"
>
> I can plug in other tables and it does not error out.
>
>
> --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
> >
> > What's the error? I've selected from that table many times...
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > mmcwilliams22
> > Sent: Wednesday, July 31, 2013 1:27 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Cannot use Resource table in SQL Select
> >
> >
> >
> >
> >
> > Have a simple select statement where I can use about any other table but
> as
> > soon as I have SELECT Resource.ResourceID or any other Field from that
> table
> > I get an error. Is resourceID a property of something possibly and it is
> > trying to interpret it as such?
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
6
Does not like that either. It moved the syntax error down towards the end though. It now is at or about "Resource A"(10713). I can alias it with other tables no problem also.

This is in a form customization mind you.

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Try aliasing, sometimes SQL is a little B
>
> SELECT A.ResourceID FROM Mfgsys.Pub.Resource A
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *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 Wed, Jul 31, 2013 at 1:37 PM, mmcwilliams22 <mmcwilliams22@...>wrote:
>
> > **
> >
> >
> >
> > Syntax error in SQL statement at or about "Resource.ResourceID From
> > Mfgsys.Pub.Reso"(10713).
> >
> > For testing I am just trying to get it to not error out using
> > sql = "SELECT Resource.ResourceID FROM Mfgsys.Pub.Resource"
> >
> > I can plug in other tables and it does not error out.
> >
> >
> > --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@> wrote:
> > >
> > > What's the error? I've selected from that table many times...
> > >
> > >
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of
> > > mmcwilliams22
> > > Sent: Wednesday, July 31, 2013 1:27 PM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Cannot use Resource table in SQL Select
> > >
> > >
> > >
> > >
> > >
> > > Have a simple select statement where I can use about any other table but
> > as
> > > soon as I have SELECT Resource.ResourceID or any other Field from that
> > table
> > > I get an error. Is resourceID a property of something possibly and it is
> > > trying to interpret it as such?
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
7
You are writing SQL in a customization? VERY VERY FROWN FACE, if you are
trying to populate a combobox or whatnot use the BOs or Retreivers..

Some others here (I am looking at you Vic) will tell you its Ok to run SQL
straight like that, but its very frowned upon by Epicor and truth be told
the Architecture is such (SOA) that you should be able to get any piece of
data without going to the DB directly

Now is your DB going to blow up? No probably not, but if something does
happen and you need support they can use that as a crutch to not support
you..

With that all said, I don't know what the problem is, looks odd.



*Jose C Gomez*
*Software Engineer*
*
*
*
*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 Wed, Jul 31, 2013 at 2:11 PM, mmcwilliams22 <mmcwilliams22@...>wrote:

> **
>
>
> Does not like that either. It moved the syntax error down towards the end
> though. It now is at or about "Resource A"(10713). I can alias it with
> other tables no problem also.
>
> This is in a form customization mind you.
>
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > Try aliasing, sometimes SQL is a little B
> >
> > SELECT A.ResourceID FROM Mfgsys.Pub.Resource A
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *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 Wed, Jul 31, 2013 at 1:37 PM, mmcwilliams22 <mmcwilliams22@...>wrote:
> >
> > > **
>
> > >
> > >
> > >
> > > Syntax error in SQL statement at or about "Resource.ResourceID From
> > > Mfgsys.Pub.Reso"(10713).
> > >
> > > For testing I am just trying to get it to not error out using
> > > sql = "SELECT Resource.ResourceID FROM Mfgsys.Pub.Resource"
> > >
> > > I can plug in other tables and it does not error out.
> > >
> > >
> > > --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@> wrote:
> > > >
> > > > What's the error? I've selected from that table many times...
> > > >
> > > >
> > > >
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > Behalf Of
> > > > mmcwilliams22
> > > > Sent: Wednesday, July 31, 2013 1:27 PM
> > > > To: vantage@yahoogroups.com
> > > > Subject: [Vantage] Cannot use Resource table in SQL Select
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Have a simple select statement where I can use about any other table
> but
> > > as
> > > > soon as I have SELECT Resource.ResourceID or any other Field from
> that
> > > table
> > > > I get an error. Is resourceID a property of something possibly and
> it is
> > > > trying to interpret it as such?
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > [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]
8
Yes I am using a UD table to create a grid of a custom dataview(ReadOnly). Im pulling different fields from JobHead, Customer,JobOper,JobOpDtl,JobProd and then displaying in the custom grid view. They can edit UD fields only in the grid, however, the Adapter is used to update the actual tables.

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> You are writing SQL in a customization? VERY VERY FROWN FACE, if you are
> trying to populate a combobox or whatnot use the BOs or Retreivers..
>
> Some others here (I am looking at you Vic) will tell you its Ok to run SQL
> straight like that, but its very frowned upon by Epicor and truth be told
> the Architecture is such (SOA) that you should be able to get any piece of
> data without going to the DB directly
>
> Now is your DB going to blow up? No probably not, but if something does
> happen and you need support they can use that as a crutch to not support
> you..
>
> With that all said, I don't know what the problem is, looks odd.
>
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *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 Wed, Jul 31, 2013 at 2:11 PM, mmcwilliams22 <mmcwilliams22@...>wrote:
>
> > **
> >
> >
> > Does not like that either. It moved the syntax error down towards the end
> > though. It now is at or about "Resource A"(10713). I can alias it with
> > other tables no problem also.
> >
> > This is in a form customization mind you.
> >
> >
> > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > >
> > > Try aliasing, sometimes SQL is a little B
> > >
> > > SELECT A.ResourceID FROM Mfgsys.Pub.Resource A
> > >
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *
> > > *
> > > *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 Wed, Jul 31, 2013 at 1:37 PM, mmcwilliams22 <mmcwilliams22@>wrote:
> > >
> > > > **
> >
> > > >
> > > >
> > > >
> > > > Syntax error in SQL statement at or about "Resource.ResourceID From
> > > > Mfgsys.Pub.Reso"(10713).
> > > >
> > > > For testing I am just trying to get it to not error out using
> > > > sql = "SELECT Resource.ResourceID FROM Mfgsys.Pub.Resource"
> > > >
> > > > I can plug in other tables and it does not error out.
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@> wrote:
> > > > >
> > > > > What's the error? I've selected from that table many times...
> > > > >
> > > > >
> > > > >
> > > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > > Behalf Of
> > > > > mmcwilliams22
> > > > > Sent: Wednesday, July 31, 2013 1:27 PM
> > > > > To: vantage@yahoogroups.com
> > > > > Subject: [Vantage] Cannot use Resource table in SQL Select
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Have a simple select statement where I can use about any other table
> > but
> > > > as
> > > > > soon as I have SELECT Resource.ResourceID or any other Field from
> > that
> > > > table
> > > > > I get an error. Is resourceID a property of something possibly and
> > it is
> > > > > trying to interpret it as such?
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > [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]
>
9
ok its strainge, have you tried running the same query in SQL Studio or SQL
Squierl'?


*Jose C Gomez*
*Software Engineer*
*
*
*
*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 Wed, Jul 31, 2013 at 2:31 PM, mmcwilliams22 <mmcwilliams22@...>wrote:

> **
>
>
> Yes I am using a UD table to create a grid of a custom dataview(ReadOnly).
> Im pulling different fields from JobHead, Customer,JobOper,JobOpDtl,JobProd
> and then displaying in the custom grid view. They can edit UD fields only
> in the grid, however, the Adapter is used to update the actual tables.
>
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > You are writing SQL in a customization? VERY VERY FROWN FACE, if you are
> > trying to populate a combobox or whatnot use the BOs or Retreivers..
> >
> > Some others here (I am looking at you Vic) will tell you its Ok to run
> SQL
> > straight like that, but its very frowned upon by Epicor and truth be told
> > the Architecture is such (SOA) that you should be able to get any piece
> of
> > data without going to the DB directly
> >
> > Now is your DB going to blow up? No probably not, but if something does
> > happen and you need support they can use that as a crutch to not support
> > you..
> >
> > With that all said, I don't know what the problem is, looks odd.
> >
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *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 Wed, Jul 31, 2013 at 2:11 PM, mmcwilliams22 <mmcwilliams22@...>wrote:
> >
> > > **
> > >
> > >
>
> > > Does not like that either. It moved the syntax error down towards the
> end
> > > though. It now is at or about "Resource A"(10713). I can alias it with
> > > other tables no problem also.
> > >
> > > This is in a form customization mind you.
> > >
> > >
> > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > >
> > > > Try aliasing, sometimes SQL is a little B
> > > >
> > > > SELECT A.ResourceID FROM Mfgsys.Pub.Resource A
> > > >
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > > *
> > > > *
> > > > *
> > > > *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 Wed, Jul 31, 2013 at 1:37 PM, mmcwilliams22 <mmcwilliams22@
> >wrote:
>
> > > >
> > > > > **
> > >
> > > > >
> > > > >
> > > > >
> > > > > Syntax error in SQL statement at or about "Resource.ResourceID From
> > > > > Mfgsys.Pub.Reso"(10713).
> > > > >
> > > > > For testing I am just trying to get it to not error out using
> > > > > sql = "SELECT Resource.ResourceID FROM Mfgsys.Pub.Resource"
> > > > >
> > > > > I can plug in other tables and it does not error out.
> > > > >
> > > > >
> > > > > --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@>
> wrote:
> > > > > >
> > > > > > What's the error? I've selected from that table many times...
> > > > > >
> > > > > >
> > > > > >
> > > > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> On
> > > > > Behalf Of
> > > > > > mmcwilliams22
> > > > > > Sent: Wednesday, July 31, 2013 1:27 PM
> > > > > > To: vantage@yahoogroups.com
> > > > > > Subject: [Vantage] Cannot use Resource table in SQL Select
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > Have a simple select statement where I can use about any other
> table
> > > but
> > > > > as
> > > > > > soon as I have SELECT Resource.ResourceID or any other Field from
> > > that
> > > > > table
> > > > > > I get an error. Is resourceID a property of something possibly
> and
> > > it is
> > > > > > trying to interpret it as such?
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > [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]
> >
>
>
>


[Non-text portions of this message have been removed]
10
Hahaha... I'm not on E9 yet, so I don't even have this ability, Mr. Jose.
:-)

I didn't realize you were trying to run it within a customization...
therefore, yes, perhaps "resource" is not a nice column name within
customization.

My final suggestion would be to enclose the SQL statement in brackets:

SELECT [ResourceID] FROM [Mfgsys].[Pub].[Resource]



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jose Gomez
Sent: Wednesday, July 31, 2013 2:23 PM
To: Vantage
Subject: Re: [Vantage] Re: Cannot use Resource table in SQL Select

You are writing SQL in a customization? VERY VERY FROWN FACE, if you are
trying to populate a combobox or whatnot use the BOs or Retreivers..

Some others here (I am looking at you Vic) will tell you its Ok to run SQL
straight like that, but its very frowned upon by Epicor and truth be told
the Architecture is such (SOA) that you should be able to get any piece of
data without going to the DB directly

Now is your DB going to blow up? No probably not, but if something does
happen and you need support they can use that as a crutch to not support
you..

With that all said, I don't know what the problem is, looks odd.



*Jose C Gomez*
*Software Engineer*
*
*
*
*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 Wed, Jul 31, 2013 at 2:11 PM, mmcwilliams22
<mmcwilliams22@...>wrote:

> **
>
>
> Does not like that either. It moved the syntax error down towards the
> end though. It now is at or about "Resource A"(10713). I can alias it
> with other tables no problem also.
>
> This is in a form customization mind you.
>
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > Try aliasing, sometimes SQL is a little B
> >
> > SELECT A.ResourceID FROM Mfgsys.Pub.Resource A
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *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 Wed, Jul 31, 2013 at 1:37 PM, mmcwilliams22 <mmcwilliams22@...>wrote:
> >
> > > **
>
> > >
> > >
> > >
> > > Syntax error in SQL statement at or about "Resource.ResourceID
> > > From Mfgsys.Pub.Reso"(10713).
> > >
> > > For testing I am just trying to get it to not error out using sql
> > > = "SELECT Resource.ResourceID FROM Mfgsys.Pub.Resource"
> > >
> > > I can plug in other tables and it does not error out.
> > >
> > >
> > > --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@> wrote:
> > > >
> > > > What's the error? I've selected from that table many times...
> > > >
> > > >
> > > >
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> > > > On
> > > Behalf Of
> > > > mmcwilliams22
> > > > Sent: Wednesday, July 31, 2013 1:27 PM
> > > > To: vantage@yahoogroups.com
> > > > Subject: [Vantage] Cannot use Resource table in SQL Select
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Have a simple select statement where I can use about any other
> > > > table
> but
> > > as
> > > > soon as I have SELECT Resource.ResourceID or any other Field
> > > > from
> that
> > > table
> > > > I get an error. Is resourceID a property of something possibly
> > > > and
> it is
> > > > trying to interpret it as such?
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > [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]



------------------------------------

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
11
Unfortunately Resource is a reserved keyword in the Progress SQL server. To access it you will need to escape it with double quotes like:

SELECT * FROM MFGSYS.PUB."Resource"

Also be aware that your permission scripts may have bombed when granting ODBC users permission to that table. I could access it with sysprogress but not my standard ODBC login until I wrapped the table name with double quotes on my permission granting script.

Aragon

--- In vantage@yahoogroups.com, "mmcwilliams22" <mmcwilliams22@...> wrote:
>
> Have a simple select statement where I can use about any other table but as soon as I have SELECT Resource.ResourceID or any other Field from that table I get an error. Is resourceID a property of something possibly and it is trying to interpret it as such?
>
12
Ahh, makes sense. It was very smart of the developers to use reserved words
for table and field names. /sarcasm



Here's a complete list of Reserved Words in Progress if anyone is curious:
http://bit.ly/17UmN32







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
sosnowbored
Sent: Wednesday, July 31, 2013 4:20 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Cannot use Resource table in SQL Select





Unfortunately Resource is a reserved keyword in the Progress SQL server. To
access it you will need to escape it with double quotes like:

SELECT * FROM MFGSYS.PUB."Resource"

Also be aware that your permission scripts may have bombed when granting
ODBC users permission to that table. I could access it with sysprogress but
not my standard ODBC login until I wrapped the table name with double quotes
on my permission granting script.

Aragon

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"mmcwilliams22" <mmcwilliams22@...> wrote:
>
> Have a simple select statement where I can use about any other table but
as soon as I have SELECT Resource.ResourceID or any other Field from that
table I get an error. Is resourceID a property of something possibly and it
is trying to interpret it as such?
>





[Non-text portions of this message have been removed]