SQL Display differences with 9.21
Posted in 2000
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?