Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    1

    Unanswered: alter table out of app

    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?

  2. #2
    Join Date
    May 2002
    Location
    Germany
    Posts
    7
    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

Posting Permissions

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