topic Re: SELECT command in Application Development and Automation Discussions

SELECT command

former_member207153 — Wed, 13 Jun 2007 03:50:23 GMT

Hi All,

currently i had problem with SELECT command :

SELECT name FROM sysobjects WHERE name = 'ABC' AND type = 'P'

sysobjects is not Table or internal data declaration,

how do i know what is this sysobjects about?

Please help

Re: SELECT command

Former Member — Wed, 13 Jun 2007 03:52:40 GMT

when it immediately comes after FROM in a select statement it should be a table or view......

use TADIR table to find objects

Re: SELECT command

former_member194669 — Wed, 13 Jun 2007 03:53:07 GMT

double click on sysobjects, system will take you to declaration part.

aRs

Re: SELECT command

Former Member — Wed, 13 Jun 2007 03:53:21 GMT

Goto SE11 and Check Whether this "sysobjects" In a View or its a Table. If this object is not in the view or table list you cant use your Select command. Also make sure that this sysobjects contains a field like "name".

Reward All Helpfull Answers.........

Re: SELECT command

Former Member — Wed, 13 Jun 2007 03:54:14 GMT

Hi Rudy,

Just Double click the SYSOBJECTS.

Thanks.

Re: SELECT command

Former Member — Wed, 13 Jun 2007 03:59:51 GMT

Hi Rudy,

When Execute your program it shows any error or not?

Thanks.

Message was edited by:

Viji

Re: SELECT command

Former Member — Wed, 13 Jun 2007 04:04:48 GMT

Hi,

Upto my Knowledge there is no Table or View with Name SYSOBJECTS.So u can't use it in a Select command.

U Pls Check it out whether it is correct or not.

Regards,

Padmam.

Re: SELECT command

Former Member — Wed, 13 Jun 2007 04:53:47 GMT

Hi Rudy,

Place on sysobjects and press F1, and c what help do u get from the system. According to my knowledge, its not an table and hence u cant use SELECT command on the same

Cheers,

PRash

Re: SELECT command

Former Member — Wed, 13 Jun 2007 05:03:49 GMT

i do agree wid Padmam eve i dint find any SYSOBJECTS tables.. but if you any table/view like thata check whether it is ACTIVE or not if not plz activate that.

Re: SELECT command

former_member207153 — Wed, 05 Nov 2008 00:05:28 GMT

case close