I am very new to PSQL and am working on custom code written several
years in VB4 that is making calls to stored procedures. Does anyone
have any idea/suggestion of how I can find those stored procedures? I
know the name of the stored procedure from the call in the program, but
I am unable to find the actual SQL code.

You can find the stored procedures in the Pervasive Control Center
(PCC).

Launch the PCC, and in the tree view on the left-hand side, expand the
selection you'll find under "Engines" for your server. Under that,
you'll find the active databases listed. Expand the item for the
database in question. Under that, you'll find listed "Tables",
"Views", "Stored Procedures", etc.

Wayne Freeman
Analytica Business Systems
www.analyticabiz.com

dcoulter13 ha scritto:

Thanks, Wayne. I tried this. Clicked on stored procedures in the tree
view and get this error:
com.pervasive.psql.utilities.core.DBException: [LNA]{Pervasive][ODBC
Engine Interface]Error in assignment.

I am so new to all this, and this is the way it has been going since
day1, so I just assumed that this was the way this was meant to be set
up. Now after reading your post, I am again hopeful that this might be
something I can correct. I will research this error and see what I can
find. If you have ever experienced this, or have any suggestions that
I can try, please feel free to advise.

Thanks again for your time,
Dawn

Wayne wrote:

Sounds like you may have PSQLv9 there. Which exact version are you
running? Newer versions have System Stored Procedures that can extract
the SP information for you:
call psp_stored_procedures(,'procname',)
That might do it for you.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com



dcoulter13 wrote: