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;

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;
>

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

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.

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

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
>

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

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?

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