SELECT command

[former_member207153]

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

[Former Member]

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

use TADIR table to find objects

[former_member194669]

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

aRs

[Former Member]

Hi

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.........

[Former Member]

Hi Rudy,

Just Double click the SYSOBJECTS.

Thanks.

[Former Member]

Hi Rudy,

When Execute your program it shows any error or not?

Thanks.

Message was edited by:

Viji

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[former_member207153]

case close