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