Stored procedure Size limit 1

[zemp]

I am creating stored procedures in Pervasice 2000i SP4 and I have one that returns all data froma table with lots of fields (49). I can enter the stored procedure as

Create Procedure...
Returns(...
As
Begin
Select * from table1;
end

When I click ok and then reopen the stored procedure only about three quarters of the returns clause is there and the rest is gone.

I am thinking that there is a size limit to the SQL in the stored procedure. If that is the case how would I create a stored procedure that return all fields. Thanks and Good Luck!

zemp

 

[Vancouverite]

There isn't a size limit -- there is a limit in how much PCC can display on the screen.

To see all of your SP, execute this query in PCC:

Select XP$Misc FROM x$Proc WHERE xp$Name = 'MyStoredProcName'

Make sure that you execute it in text mode (not into the grid). You will get all of your SP displayed.

 

[zemp]

Thank you for the information and the SQL to check my stored procedure. Turns out it is all there. Thanks and Good Luck!

zemp