Paradox Community

Items in pnews.paradox-dos

Subject:Re: Crosstab
Date:Wed, 18 Dec 2019 16:39:34 +1000
From:Bernie van't Hof <onrequest@somewhere>
Newsgroups:pnews.paradox-dos
Well I'm not much better!

Just about sorted crosstab (at least conceptually) and made an awkward 
discovery in the process.

CREATE TABLE `Answer` AS SELECT ... seems innocuous enough.

But I hadn't noticed before that it brings NULL/NOTNULL settings from 
SELECT columns into the new table. The benefits are obvious, but is 
different to pdox which generates the Answer table unkeyed. Ho Hum :(

- Bernie

 > Glad to see some activity on this forum, Bernie. But, I've no SQL
 > expertise,


Copyright © 2004 thedbcommunity.com