Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2009
    Posts
    6

    Answered: Pervasive parameters

    If there is a simple query like:

    select *
    from class
    where section = ?

    Shouldn't PCC run the query and prompt for the parameter? On my system, it doesn't; instead, I get the error "SQLBindParameter has not been called for parameter #1".

    What am I missing?

    TIA,

    al

  2. Best Answer
    Posted by mirtheil

    "No, the Pervasive Control Center isn't designed to prompt for parameters. The PCC is designed as a simple query tool that emulates Microsoft SQL Server Management Studio.

    You'll need to specify the value you want to use."


  3. #2
    Join Date
    Jan 2016
    Posts
    14
    What version of PSQL are you using?

  4. #3
    Join Date
    Dec 2001
    Posts
    1,117
    Provided Answers: 6
    No, the Pervasive Control Center isn't designed to prompt for parameters. The PCC is designed as a simple query tool that emulates Microsoft SQL Server Management Studio.

    You'll need to specify the value you want to use.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  5. #4
    Join Date
    Apr 2009
    Posts
    6
    OK thanx.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •