Development platform:  Delphi 7
DBISAM Database: 3.30

I am attempting to perform an INSERT command but I am receiving the
DBISAM error #11013.  I inherited this program from another developer,
and the previous developer is not using the DBISAM Session component.
Is there a setting in the database that will allow me to specify the
temporary directory without the component?

If there is no session explicitly placed into the project, then DBISAM
creates a default session at runtime. So, whether one realizes it or
not, there is always a session.

Regards,

Jason Lee

> the previous developer is not using the DBISAM Session component.

<< I am attempting to perform an INSERT command but I am receiving theDBISAM
error #11013.  I inherited this program from another developer,and the
previous developer is not using the DBISAM Session component.  Is there a
setting in the database that will allow me to specify the temporary
directory without the component? >>

Sure, just use this:

DBISAMTb.Session.PrivateDir:='c:\windows\temp';

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

Where do I place this command in the database?  Or, should I place
this in the code?  Thanks.

On Thu, 14 Dec 2006 16:15:01 -0500, "Tim Young [Elevate Software]"
<timyoung@elevatesoft.com> wrote:

>
><< I am attempting to perform an INSERT command but I am receiving theDBISAM
>error #11013.  I inherited this program from another developer,and the
>previous developer is not using the DBISAM Session component.  Is there a
>setting in the database that will allow me to specify the temporary
>directory without the component? >>
>
>Sure, just use this:
>
>DBISAMTb.Session.PrivateDir:='c:\windows\temp';

You can place it in your form/data module's OnCreate event. I usually do
it just prior to the session becoming active. You can also do it in the
session's OnStartup event.  I would recommend explicitly adding a
session component to your project, but that's just my personal
preference for simplicity and convenience.

Regards,
Jason Lee

> Where do I place this command in the database?  Or, should I place
> this in the code?  Thanks.

<< Where do I place this command in the database?  Or, should I place this
in the code?  Thanks. >>

Jason is correct, place it somewhere in your code prior to the session being
activated.  Be aware, however, that a session can be activated automatically
by opening any TDBISAMDatabase, TDBISAMTable, or TDBISAMQuery components
that are connected to the session via their SessionName property.

--
Tim Young
Elevate Software
www.elevatesoft.com

I am still getting the error message, even placing this SessionDir
string in the DataModuleCreate procedure.  Any other suggestions?

On Fri, 15 Dec 2006 14:15:11 -0500, "Tim Young [Elevate Software]"
<timyoung@elevatesoft.com> wrote:

><< Where do I place this command in the database?  Or, should I place this
>in the code?  Thanks. >>
>
>Jason is correct, place it somewhere in your code prior to the session being
>activated.  Be aware, however, that a session can be activated automatically
>by opening any TDBISAMDatabase, TDBISAMTable, or TDBISAMQuery components
>that are connected to the session via their SessionName property.

I think the wrong question has been answered, even though its the one you asked. Assuming that the table you are trying to INSERT into is part of the app rather than a temporary table the temporary directory is a red herring.


What you need to be looking at is wether you have access to the table you want to update and if so wether its opened exclusively somewhere else in the app.

The same really applies if its a temporary table do you have the necessary rights to alter it?


Roy Lambert

Yes, I have access to the table I am trying to update; no, no other
process has exclusive access.  This is not a temp table that I am
trying to update.

On Mon, 18 Dec 2006 14:06:18 +0000, Roy Lambert
<roy.lambert@skynet.co.uk> wrote:

>I think the wrong question has been answered, even though its the one you asked. Assuming that the table you are trying to INSERT into is part of the app rather than a temporary table the temporary directory is a red herring.
>
>
>What you need to be looking at is wether you have access to the table you want to update and if so wether its opened exclusively somewhere else in the app.
>
>The same really applies if its a temporary table do you have the necessary rights to alter it?
>
>
>Roy Lambert

<< Yes, I have access to the table I am trying to update; no, no other
process has exclusive access.  This is not a temp table that I am trying to
update.>>

Something else must have the table open exclusively in order for an INSERT
to fail with that error message.  That's the only way it can happen.  I
would double-check your application to make sure that there are no
TDBISAMTable or TDBISAMQuery components that have that table open
exclusively.

--
Tim Young
Elevate Software
www.elevatesoft.com