On Tuesday 08 April 2008 08:35:45 pm Gary_Krell wrote:
> Added:
> ## dbName = self.database
> ## cursor.execute("select NAME"
> ## " from %s.SYS.TABLES"
> ## " order by NAME" % (dbName))
> ## rs = cursor.getDataSet()
> ## tables = [x["NAME"] for x in rs]
I have a 2003 server where 'dean' is the database name.
select Name from dean.SYS.TABLES order by NAME
returns
Invalid object name 'dean.SYS.TABLES'
What am I missing? Also can you provide a link to the doc's you made
reference too.
## cursor.execute("select COLUMN_NAME, DATA_TYPE"
## " from %s.INFORMATION_SCHEMA.COLUMNS"
## " where table_catalog = '%s'"
## " and table_name = '%s'"
## " order by ORDINAL_POSITION" %
(dbName,dbName,tableName))
where
'dean' = dbName
and 'arcust' = tableName
returns
Server: Msg 207, Level 16, State 3, Line 1
Invalid column name 'dean'.
Server: Msg 207, Level 16, State 1, Line 1
Invalid column name 'arcust'.
I have tried this from the SQL-query and Dabo.
--
John Fabiani
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
