LIST on SYSCOLUMNS (OpenInsight 32-Bit)
At 20 APR 2007 09:31:24AM Stefano Cavaglieri wrote:
From TCL (as well as from a popup, or whatever) entering "LIST SYSCOLUMNS WITH TABLE_NAME EQ 'any existing table'" always returns "Zero Rows Processed". If you use another column (as for instance "LIST SYSCOLUMNS WITH COLUMN_NAME EQ 'any existing column'"), it works properly. Am I missing something, or is it a bug ?
Best,
Stefano
At 23 APR 2007 09:50AM Gerald Lovel wrote:
SYSCOLUMNS is a pseudo, or symbolically created, file system. The OI implementation has known inconsistencies as compared to the AREV version. For example, listing SYSCOLUMNS sorted by filename in AREV lists all system columns. In OI, the equivalent statement lists columns for only the FIRST table. This seems to be related to your issue.