| || |
SQL Server system tables and DBSelect()
I'm trying to use:
dbselect("SELECT name from syscolumns where id = '123';")
replacing 123 with the relevant ID each time via a loop.
Moving through the record set, even though I know (from using Query Analyzer in SQL Server) that there are about a dozen records that match the query, QARun won't show any of them when printing to the output the contents of dbgetfield(x).
I've asked Compuware and they indicated that it may be a problem with using system tables in select statements.
dbselect("SELECT id FROM sysobjects where name='x';")
works fine - and sysobjects is a system table as well.
Any ideas on what's going on?
[This message has been edited by Colin Deady (edited 05-16-2002).]