Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 9 of 9 total |
Can Not Delete Table |
Sun, Jan 27 2008 3:56 PM | Permanent Link |
Scott Woods | I have a table called Jobs that I can not delete from the ElevateDB Manager, even when the table is first created. I always get a 300 error.
I have added the script to create this table below. CREATE TABLE "Jobs" ( "ID" INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) DESCRIPTION 'Job ID', "CustID" INTEGER DESCRIPTION 'Cust ID', "DateRec" DATE DESCRIPTION 'Date Received', "TimeRec" TIME DESCRIPTION 'Time Received', "DateSched" DATE DESCRIPTION 'Scheduled Date', "TimeSched" TIME DESCRIPTION 'Scheduled Time', "Technician" VARCHAR(50) COLLATE "ANSI" DESCRIPTION 'Technician. Do not use links since technicians can be deleted over time.', "Color" VARCHAR(50) COLLATE "ANSI" DESCRIPTION 'Color code for dispatching.', "CallType" VARCHAR(50) COLLATE "ANSI" DESCRIPTION 'CallType', "Description" VARCHAR(255) COLLATE "ANSI" DESCRIPTION 'External Description', "Comments" CLOB COLLATE "ANSI" DESCRIPTION 'Internal Comments.', "NeedToSchedule" BOOLEAN DESCRIPTION 'Internal field for mailing lists.', "Duration" DECIMAL(20,0) DESCRIPTION 'Number of Hours the Call is scheduled or.' ) DESCRIPTION 'Jobs Table' VERSION 1 UNENCRYPTED INDEX PAGE SIZE 4096 BLOB BLOCK SIZE 512 MAX ROW BUFFER SIZE 32768 MAX INDEX BUFFER SIZE 65536 MAX BLOB BUFFER SIZE 32768; |
Sun, Jan 27 2008 4:00 PM | Permanent Link |
"Scott Woods" | One note - I can delete the table if it is alone in the DB, but not when its
part of other tables. Tim - I emailed you the script to build the entire DB. Thanks "Scott Woods" <swoods80@gmail.com> wrote in message news:CA9285D3-73DD-4BAE-9E3F-0B7CE0203E60@news.elevatesoft.com... >I have a table called Jobs that I can not delete from the ElevateDB >Manager, even when the table is first created. I always get a 300 error. > > I have added the script to create this table below. > > CREATE TABLE "Jobs" > ( > "ID" INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) > DESCRIPTION 'Job ID', > "CustID" INTEGER DESCRIPTION 'Cust ID', > "DateRec" DATE DESCRIPTION 'Date Received', > "TimeRec" TIME DESCRIPTION 'Time Received', > "DateSched" DATE DESCRIPTION 'Scheduled Date', > "TimeSched" TIME DESCRIPTION 'Scheduled Time', > "Technician" VARCHAR(50) COLLATE "ANSI" DESCRIPTION 'Technician. Do not > use links since technicians can be deleted over time.', > "Color" VARCHAR(50) COLLATE "ANSI" DESCRIPTION 'Color code for > dispatching.', > "CallType" VARCHAR(50) COLLATE "ANSI" DESCRIPTION 'CallType', > "Description" VARCHAR(255) COLLATE "ANSI" DESCRIPTION 'External > Description', > "Comments" CLOB COLLATE "ANSI" DESCRIPTION 'Internal Comments.', > "NeedToSchedule" BOOLEAN DESCRIPTION 'Internal field for mailing lists.', > "Duration" DECIMAL(20,0) DESCRIPTION 'Number of Hours the Call is > scheduled or.' > ) > DESCRIPTION 'Jobs Table' > VERSION 1 > UNENCRYPTED > INDEX PAGE SIZE 4096 > BLOB BLOCK SIZE 512 > MAX ROW BUFFER SIZE 32768 > MAX INDEX BUFFER SIZE 65536 > MAX BLOB BUFFER SIZE 32768; > |
Mon, Jan 28 2008 3:20 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Scott,
<< One note - I can delete the table if it is alone in the DB, but not when its part of other tables. Tim - I emailed you the script to build the entire DB. Thanks >> I can use your script to create the entire DB and delete the Jobs table just fine. What is the exact error message that you're receiving ? -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Jan 28 2008 5:23 PM | Permanent Link |
Scott Woods | Tim - when you created the Database from the script were you able to drop all the tables? I noticed that I can sometimes delete the jobs table but then
another table can not be dropped. |
Tue, Jan 29 2008 4:02 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Scott,
<< Tim - when you created the Database from the script were you able to drop all the tables? I noticed that I can sometimes delete the jobs table but then another table can not be dropped. >> Yep, no problem. Again, what was the error message that you got ? I know it was a lock error, but it really matters as to *what* couldn't be locked. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Jan 29 2008 10:29 PM | Permanent Link |
"Scott Woods" | Tim - the error is
ElevateDB Error #300 Cannot lock table <TableName> for exclusive access. "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:4218E918-CCDF-4D58-A9E4-D4566CC313FB@news.elevatesoft.com... > Scott, > > << Tim - when you created the Database from the script were you able to > drop all the tables? I noticed that I can sometimes delete the jobs table > but then another table can not be dropped. >> > > Yep, no problem. Again, what was the error message that you got ? I know > it was a lock error, but it really matters as to *what* couldn't be > locked. > > -- > Tim Young > Elevate Software > www.elevatesoft.com > |
Wed, Jan 30 2008 2:19 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Scott,
<< ElevateDB Error #300 Cannot lock table <TableName> for exclusive access. >> That's pretty standard - are you sure that the table isn't open somewhere else, like in the Delphi IDE ? -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Jan 31 2008 11:56 AM | Permanent Link |
Scott Woods | No - the only apps where the Manager and Server. Delphi was closed. I seem to have strange issues on my machine (from my past postings) so I wanted to see if
you had the issue or not. The only thing I can think of is I use the same name ServiceStar for the database, session, user, etc. Could this have an impact? |
Thu, Jan 31 2008 5:07 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Scott,
<< No - the only apps where the Manager and Server. Delphi was closed. I seem to have strange issues on my machine (from my past postings) so I wanted to see if you had the issue or not. The only thing I can think of is I use the same name ServiceStar for the database, session, user, etc. Could this have an impact? >> Only if you had an incorrect setting somewhere that was causing you to use a different configuration, database, etc. than you thought you were using. If you have a reproducible sample of this, please send it to me via email and I'll take a look. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, May 15, 2024 at 08:40 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |