Re: dbschema and dbaccess different.

davin_harvey@dsti.co.uk wrote: > > Message is sent with MIME. Attachments are base64 encoded > > --TFS-with-MIME-and-DIME > Content-Type: text/plain; charset=ISO-8859-1 > Content-transfer-encoding: quoted-printable > > Yes, I run update statistics every night. Another thing to throw > in to the pot is that running a select on syscolumns ordering by colno > brings the columns out in dbschema order, but leaving the order by off > brings them out in the dbaccess order. A bug in dbaccess perhaps? or > maybe corrupt indexes. Oncheck doesn't think the indexes are bad > though. There should be an index on syscolumns named 'column' like this: create index column on syscolumns( tabid, colno ); Dbschema is selecting with an ORDER BY clause and DBACCESS apparently does not and either this index is missing or it is damaged. Art S. Kagel