Recent content by pthomas

  1. P

    SYSCOLUMNS and SYSCOLUMNS_FULL out of sync

    Curiouser and Curiouser Update: After further investigation, I've found that if I try: select tbl, col, width, array_extent from openquery(PROGRESS92, 'select "tbl", "col", "width", "array_extent" from "syscolumns_full" where tbl=''pr''') order by tbl, col Then I get 43 rows, one for each...
  2. P

    SYSCOLUMNS and SYSCOLUMNS_FULL out of sync

    Hi, I'm trying to use the SYSCOLUMNS_FULL table to identify whether a column is defined as an array. The query that I'm running is pretty simple : select tbl, col, width, array_extent from sysprogress.syscolumns_full The problem that I'm encountering is that although all of the...
Back
Top