It didn't help to write '#' to separate the statements, but it gave me a clue. Thing was that I had changed the separator from '#' to ';'. When I changed it back it worked.
Thanks
Hi, this is an exact copy from the help files of Pervasive.SQL.V8:
CREATE PROCEDURE Checkmax(in :classid integer);
Begin
DECLARE :numenrolled integer;
DECLARE :maxenrolled integer;
SELECT COUNT(*) INTO :numenrolled FROM Enrolls WHERE class_ID = :classid;
SELECT Max_size INTO...
Hi all,
my company must decide whether to use Pervasive or MS SQL Server for a number of development projects that are about to start (client/server).
We have both of them but only one application runs on Pervasive (V8) for now. My preference is MSSQL since I know much about it.
The projects...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.