alter table out of app [Archive]

View Full Version : alter table out of app

powersw

01-19-03, 14:29

I'm using Powerbuilder 6.5 and Pervasive SQL 2000i WG SP4.
I want to alter a table (e. g. add a column) programmatically in my app.
when I issue the execute statement, I get the error -85 (-4914) "The file is locked".
In the control-center (of course) it works.
Second question: Is there a way to run a sql-statement via control-center from the commandline with a .sql-file?

usander

01-20-03, 02:52

Hi,

this usually means that you have opened the table with an SQL statetment before trying to alter it. If you are sure that you did not do anything like SELECT, please check of some internal Powerbuilder routines give you some unwanted help. You can also use the Pervasive Monitor utility to get an idea what prevents you from altering the table.

HIH

Uwe