var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Problem while creating a stored procedure
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();
Select * from colors;
It returns the following error message:
Save Failed:com.pervasive.psql.utilities.core.DBExcepti on:[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 ...
Sounds like one of the system tables (PROC.DDF) is missing. Make sure you got all of the DDFs. Also, make sure the DDFs aren't flagged read-only.
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
I do not answer questions by email. Please post on the forum.
I also facing same problem but fixed it already. Thanks.
Tags for this Thread