Pervasive Community Site
Community Forum (formally DEVTALK) – Join the ever- growing Pervasive community in a lively, interactive e-nvironment where users can come together and discuss their choice of topics on Pervasive-based products. Participants include Developers, Resellers, System Integrators, and End User and Pervasive team members.
Component Zone – Download the latest utilities and tools posted by third-party vendors. The Zone is your quick stop for getting the latest tools our partners have to offer.
You have to build a SQL statement in a string, and then use Execute run it. More like this: CREATE PROCEDURE GetUserList(IN :sWhereA VARCHAR(2048), IN :sOrderByA VARCHAR(2048)) RETURNS( UserID INTEGER, UserStatus VARCHAR(50), ... ExpiresOn DATE, AgreementDate DATE, CreationDate DATETIME ) AS BEGIN DECLARE :stmt LONGVARCHAR; SET :stmt = "SELECT...
I'm trying to create a Stored Procedure that uses an input parameter for the Where Clause. From what I can tell this functionality is not supported but I'd like to see if somebody can confirm that or tell me how I can accomplish this. The stored procedure is returning a record list of users and I need to be able to build the where clause from...
Thanks, Linda84. I removed and reinstalled from scratch and it fixed my problem. (Now I'm wrestling with another problem that I can't get an error message for, from the language I'm using. Until I can do that I can't ask for PSQL-level help on it.)
You could also try deleting the workspace-pcc folder, and then restarting with PCC -CLEAN, which will recreate it. C:\ProgramData\Actian\PSQL\rcp\workspace-pcc (or the equivalent path on your XP machine... might be under C:\Documents and Settings?)
Thanks BtrieveBill, I'll give that a try (now that I'm reassured about the license key).