|
Creating empty queries
You may need Derby to
create "empty" queries in existing applications for filling in bits of functionality
that Derby does not supply.
Empty queries of the right size and shape can be formed off a single values
table and a "WHERE FALSE" condition:
SELECT *
FROM (VALUES ('',1,"TRUE")) AS ProcedureInfo(ProcedureName,NumParameters,
ProcedureValid)
WHERE 1=0
|