Hi,

I'm trying to create a virtual procedure in a view model.

I've first developed the procedure script but when I paste it I get the same error over and over again.

I've then reduced it to the following content (which is the start of the script).

BEGIN
create temporary table tmp_cohort(
patientid integer not null,
prod boolean not null,
PRIMARY KEY(patientid)
);
END

The designer does not seem to accept the sql and it fails with the message "ERROR: Error in parsing of sql - null"

There a no messages in the eclipse log file.