Problem while creating a stored procedure in Pervasive


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Problem while creating a stored procedure in Pervasive

Hybrid View

  1. #1
    Join Date
    Feb 2004
    Location
    Canada
    Posts
    6

    Problem while creating a stored procedure in Pervasive

    Hello,

    I'm facing a tricky problem and i don't know how to fix it ...
    I have installed PSQL 9.50 on my pc ... Under the Database called "DEMOData", i can create stored procedures without any problem ...

    We already installed PSQL 10.0 on our customer server.

    So, now I create a new Database on my machine. And i copied all .ddf and .mkd files on my local machine in order to have the recent and latest version of customer Database.

    Till now evrything works fine. I can open tables, change data structure, do a select querry ...

    But, my only problem is i can't create a very simple stored procedure like this one:

    CREATE PROCEDURE test2();
    Begin

    Select * from colors;

    End ;


    It returns the following error message:

    Save Failed:com.pervasive.psql.utilities.core.DBException:[LNA][Pervasive][ODBC Engine Interface][Data Record Manager] No such table or object.


    Can anybody tell me how to fix this problem ?


    Thank you for your help ...

    Paul

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    Quote Originally Posted by paulnamroud View Post
    No such table or object.
    My initial question would be are you sure there really is a table called "colors"?
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

Similar Threads

  1. problem with stored procedure
    By Guillermo in forum Database
    Replies: 2
    Last Post: 05-29-2001, 11:55 AM
  2. problem with stored procedure
    By Guillermo in forum Database
    Replies: 1
    Last Post: 05-24-2001, 03:40 PM
  3. temp table collision in a stored procedure
    By Keoki12 in forum Database
    Replies: 1
    Last Post: 05-23-2001, 06:17 PM
  4. Replies: 4
    Last Post: 04-22-2001, 11:35 PM
  5. Replies: 0
    Last Post: 04-08-2001, 10:41 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center