Problem with opening table definition in SQL Studio and table DOMAIN.COLUMNS

"Andrzej Ka?mierkiewicz" <[email protected]> Thu, 28 Aug 2003 18:27:09 +0200
Newsgroups gmane.comp.db.sapdb.general
Organization Remedium
Message-ID <[email protected]>
Hello

First Problem:

I have problem with opening table definition in SQL Studio ver 7.4.3.17.
I get following errors
1. "an error occured while loading the table definition"
2. " Module: ColumnDefinitionControl
      Function: updateColumnDefinition
      Error No: 30009
      Error: Invalid Row Value"

I use database server SAPDB ver. 7.4.3.27 and higher.

When I used database server SAPDB ver 7.4.3.28, I didn't have problem with
SQL Studio.

Second Problem:

I need to know complete information about COLUMNS in selected TABLE
I try obtaining this by execute following SQL

SELECT * FROM DOMAIN.COLUMNS WHERE TABLENAME='tatablename' AND
OWNER='ownername'

The SQL command is executed correctly but result set is empty.
I tried execute following SQL:

SELECT * FROM DOMAIN.COLUMNS

result set was empty,too.
How can I obtain information about COLUMNS in TABLE ?

Are there any solutions of this problems?

--
Andrzej Kazmierkiewicz
Remedium