A few questions.

[derfie]

I'm not a database person but, I have the following written in pervasive

CREATE PROCEDURE PROCOUT (OUT :outval INTEGER)  
AS BEGIN 
SELECT Student_ID INTO :outval FROM Enrolls WHERE Grade=1.0;
END

and I wanted to see what it does so, I did this

CREATE PROCEDURE pdate(); 
BEGIN 
   DECLARE :a integer; 
   CALL PROCOUT(:a); 
   PRINT :a; 
END

problem is the progress bar comes up and it never ends! Any idea why this might be?

Thanks,
Fred

 

[mirtheil]

If you are running PSQL in a client/server situation, the PRINT will display the value on the server not the client.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[derfie]

cool, Thanks. I'm pretty new to pervasive. I appreciate your help!

-Fred