PREPARE ResultStmt FROM
'CREATE TABLE emCounts AS
SELECT _BoxNo ,
(SELECT COUNT(_fkMailBoxes) from "NLH-Live".EMails WHERE _fkMailBoxes = MailBoxes._Boxno
AND
(EMails._Private = FALSE OR EMails._fkUsers = ?)) AS _OnFile ,
(SELECT COUNT(_fkMailBoxes) from "NLH-Live".emReadStatus WHERE _fkUsers = ? AND _fkMailboxes = MailBoxes._Boxno) AS _Read,
0 AS _UnRead
FROM "NLH-Live".MailBoxes
WITH DATA';

ElevateDB Error #700 An error was found in the statement at line 18 and column 1 (Invalid expression ? found, dynamic parameter references not allowed)

I know I can work round it but why?

Roy Lambert

Roy,

<< I know I can work round it but why? >>

CREATE TABLE AS does not allow parameters currently.  It's on the list of
2.0 enhancements to address.

--
Tim Young
Elevate Software
www.elevatesoft.com