Using COMPUTE statements

jConnect does not support computed rows. In fact, results are automatically cancelled when a query contains a computed row. For example, the following statement is rejected:

SELECT name FROM sysobjects 
WHERE type="S" COMPUTE COUNT(name)

To avoid this problem, substitute the following code:

SELECT name from sysobjects WHERE type="S"
SELECT COUNT(name) from sysobjects WHERE type="S"