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.

Pervasive Blogs – Want to learn about the latest news, topics, and thoughts from Pervasive? Then you’ve come to the right place.  Our bloggers will give you insight and understanding about the latest news and topics in the Pervasive world.

What's New

  • Re: Converting month and day of a date field to formatted text

    Once you have extracted the month and day values, you can use the Format function to add a leading zero. 0 = Digit placeholder-displays a digit or a zero. If there is a digit in the expression being formatted in the position where the 0 appears in the format string, display it; otherwise, display a zero in that position. For more information about the...
    Posted to General (Forum) by kateruth on 03-18-2010
  • Converting month and day of a date field to formatted text

    I have to move the month and day from a database field to a 2 byte text field. If the value is less than 10 I need to right justify and add a leading zero. I have been able to extract the month and day successfully and write RIFL code to check the value. if 1 then return 01. if 2 return 02, etc. I'm wondering if there is a more elegant way to do...
    Posted to General (Forum) by bwgerard on 03-18-2010
  • CHAR vs. VARCHAR following upgrade to PSQL 10

    We are in the process of upgrading our V8.6 server to V10, installed on a new machine (Windows 2008 R2 64-bit). I converted the database files to 9.5 format using the rebuild utility, and have been testing our apps and have noticed a problem: - table 1 has a field defined as CHAR(8) - table 2 has a field defined as VARCHAR(8) Under 8.6 if the two fields...
    Posted to SDK (Forum) by sodrac on 03-18-2010
  • Re: Macros for DjImport

    Thanks Kate , It work gr8.
    Posted to General (Forum) by Bobby Carolin on 03-18-2010
  • Re: Query problem pulling data from Salesforce.com

    The first thing that the map does before running the BeforeTransformation event handler, is it tries to connect to the Source and Target. The variable "p_LastRunTime" is set in the BeforeTransformation so it is not set when the map tries to connect to SalesForce. I would recommended setting the variable in a scripting step in the process....
    Posted to General (Forum) by kateruth on 03-18-2010