Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 9 of 9 total |
dbisam 3.3 / kbmmw : alter table |
Mon, Nov 13 2006 4:29 AM | Permanent Link |
"Harry de Boer" | LS
We're using kbmMW (2.6+) middleware components together with dbIsam 3.3. I am writing a query tool that also allows dml statements. DROP TABLE and CREATE TABLE do work, but ALTER TABLE raises an error: Dbisam error # 11013 Access denied to table "path + table". The table is not in use by anyone, nor is the directory read only! Anyone any idea? Regards, Harry |
Mon, Nov 13 2006 3:08 PM | Permanent Link |
"Peter Mora" | For what its worth, I am using Dbisam 4.22 and kbmMW 2.5,
and I am able to use the following statement: ALTER TABLE IF EXISTS My_Table ADD IF NOT EXISTS my_field BOOLEAN AT 11; I use a TkbmMWClientQuery and call the "Execute" method (not the "Open" method). -Peter "Harry de Boer" <harry@staaf.nl> wrote in message news:4D409BD0-C1FC-4F3A-8B5A-D882E2296D41@news.elevatesoft.com... > LS > > We're using kbmMW (2.6+) middleware components together with dbIsam > 3.3. I > am writing a query tool that also allows dml statements. DROP TABLE > and > CREATE TABLE do work, but ALTER TABLE raises an error: Dbisam error > # 11013 > Access denied to table "path + table". The table is not in use by > anyone, > nor is the directory read only! Anyone any idea? > > Regards, Harry > > |
Mon, Nov 13 2006 5:17 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Harry,
<< We're using kbmMW (2.6+) middleware components together with dbIsam 3.3. I am writing a query tool that also allows dml statements. DROP TABLE and CREATE TABLE do work, but ALTER TABLE raises an error: Dbisam error # 11013 Access denied to table "path + table". The table is not in use by anyone,nor is the directory read only! Anyone any idea? >> The table must be open by someone or something - an access denied error comes directly from the OS. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Nov 14 2006 3:45 AM | Permanent Link |
"Harry de Boer" | Tim,
I thought of that at first too, but that's not true. Even when I do this on one pc, restart the pc and execute the statement, the error occurs. With dbSys it's ok, but via kbmMW it's not. The DROP and CREATE work well though. Regard, Harry "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schreef in bericht news:79C76483-D8F8-4E32-BC74-583818F0AF6B@news.elevatesoft.com... > Harry, > > << We're using kbmMW (2.6+) middleware components together with dbIsam 3.3. > I am writing a query tool that also allows dml statements. DROP TABLE and > CREATE TABLE do work, but ALTER TABLE raises an error: Dbisam error # 11013 > Access denied to table "path + table". The table is not in use by anyone,nor > is the directory read only! Anyone any idea? >> > > The table must be open by someone or something - an access denied error > comes directly from the OS. > > -- > Tim Young > Elevate Software > www.elevatesoft.com > > |
Tue, Nov 14 2006 3:47 AM | Permanent Link |
"Harry de Boer" | Peter,
I use the execute method too. I will report to Kim that the configuration you have does work, thanks. Regards, Harry "Peter Mora" <PeterXXMoratekXXXCom> schreef in bericht news:66D32B3E-BA99-470C-8D7D-31BF2DDDC2AB@news.elevatesoft.com... > For what its worth, I am using Dbisam 4.22 and kbmMW 2.5, > and I am able to use the following statement: > > ALTER TABLE IF EXISTS My_Table > ADD IF NOT EXISTS my_field BOOLEAN AT 11; > > I use a TkbmMWClientQuery and call the "Execute" > method (not the "Open" method). > > -Peter > > > "Harry de Boer" <harry@staaf.nl> wrote in message > news:4D409BD0-C1FC-4F3A-8B5A-D882E2296D41@news.elevatesoft.com... > > LS > > > > We're using kbmMW (2.6+) middleware components together with dbIsam > > 3.3. I > > am writing a query tool that also allows dml statements. DROP TABLE > > and > > CREATE TABLE do work, but ALTER TABLE raises an error: Dbisam error > > # 11013 > > Access denied to table "path + table". The table is not in use by > > anyone, > > nor is the directory read only! Anyone any idea? > > > > Regards, Harry > > > > > > |
Tue, Nov 14 2006 8:47 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Harry,
<< I thought of that at first too, but that's not true. Even when I do this on one pc, restart the pc and execute the statement, the error occurs. With dbSys it's ok, but via kbmMW it's not. The DROP and CREATE work well though. >> Is kbmMW caching any data modules or anything that would keep a table open longer than expected ? -- Tim Young Elevate Software www.elevatesoft.com |
Sat, Nov 3 2012 3:02 PM | Permanent Link |
lisun | I need help with this error, when I alter the table, If I change the name of the existed field, it works well. but when I add a new field, the error 11013 show. please help me to fix this error...., because I have to add a new field on my table.
|
Sat, Nov 3 2012 3:03 PM | Permanent Link |
lisun | lisun wrote:
I need help with this error, when I alter the table, If I change the name of the existed field, it works well. but when I add a new field, the error 11013 show. please help me to fix this error...., because I have to add a new field on my table. |
Mon, Nov 5 2012 3:12 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Lisun,
<< I need help with this error, when I alter the table, If I change the name of the existed field, it works well. but when I add a new field, the error 11013 show. please help me to fix this error...., because I have to add a new field on my table. >> Per email: Please see here: http://www.elevatesoft.com/supportfaq?action=view&category=dbisam&question=alter_table_access_denied Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Thursday, March 28, 2024 at 06:05 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |