Re: SQL Display differences with 9.21

Hi. tabname size changed to 128 and it does not fit on one line, so probabily you have to substr it. HTH Bogdan Doug McAllister wrote: > Hi all.. > > I have gotten some differences with the way SQL works between 7.3x and > 9.21 and I wondered if any of you had seen this? > > I execute the following query: > > select > tabname,nrows > from > systables > where > tabname not like 'sys%' > and tabname not like ' GL%' > and tabname not like ' VERSION' > and tabtype not like "V" > order by tabname > ; > > And get the following output from 9.21: > > tabname account_cash > nrows 0 > > tabname account_group > nrows 0 > > tabname alphas > nrows 0 > > tabname amort_yield > nrows 0 > > But when I run the exact same query in 7.31 I get: > > tabname nrows > > account_cash 0 > account_group 0 > alphas 0 > amort_yield 0 > asal_rest 0 > asof_apr_lt 22326 > asof_apr_lt_cl 12726 > asof_apr_st 26228 > asof_apr_st_cl 16189 > asof_aug_lt 1186 > asof_aug_lt_cl 911 > asof_aug_st 643 > asof_aug_st_cl 498 > asof_feb_lt 16775 > > As you can see, the resulting rows are identical but I now get a header > row for each detail row in 9.21. This really screws up some scripts that > I run. > > Anyone else seen this behavior?