Tim

Trying to get to be able to select into a memory table I thought

'CREATE DATABASE "RAM" IN MEMORY'

The program crashed (naturally) and trying to run it next time I get

Error #400 the database RAM already exists

Roy Lambert

Roy,

<< Trying to get to be able to select into a memory table I thought

'CREATE DATABASE "RAM" IN MEMORY'

The program crashed (naturally) and trying to run it next time I get >>

It works fine here (without the single quotes).  Did you actually execute
the SQL with the single quotes around it ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Nah - just cut and paste from the IDE

Roy Lambert

Tim Young [Elevate Software] wrote:
> Roy,
>
> << Trying to get to be able to select into a memory table I thought
>
>  'CREATE DATABASE "RAM" IN MEMORY'
>
>  The program crashed (naturally) and trying to run it next time I get >>
>
> It works fine here (without the single quotes).  Did you actually execute
> the SQL with the single quotes around it ?
>

http://www.codinghorror.com/blog/archives/000818.html

Had to chuckle because your reply reminded me of this blog entry. Shiny
new stickers to go on the (virtual) EDB boxes.

Jim

Roy,

<< Nah - just cut and paste from the IDE >>

Is it reproducible in the context of your code ?  If so, can you send me the
code ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Jim,

<< http://www.codinghorror.com/blog/archives/000818.html

Had to chuckle because your reply reminded me of this blog entry. Shiny new
stickers to go on the (virtual) EDB boxes. >>



Sometimes there's no other way to respond, unfortunately, especially with
something as simple as a CREATE DATABASE statement combined with the fact
that I don't have any incidents logged for such a problem.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Using D2006 use Alt-r-e to break it and then run again


object Form1: TForm1
 Left = 248
 Top = 81
 Caption = 'Form1'
 ClientHeight = 536
 ClientWidth = 971
 Color = clBtnFace
 Font.Charset = DEFAULT_CHARSET
 Font.Color = clWindowText
 Font.Height = -12
 Font.Name = 'Arial'
 Font.Style = []
 OldCreateOrder = False
 OnCreate = FormCreate
 PixelsPerInch = 96
 TextHeight = 15
 object EDBQuery1: TEDBQuery
   DatabaseName = 'Configuration'
   SessionName = 'Default'
   SQL.Strings = (
     'CREATE DATABASE "RAM" IN MEMORY')
   Params = <>
   Left = 32
   Top = 16
 end
end



unit Unit1;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, DB, edbcomps;
type
TForm1 = class(TForm)
 EDBQuery1: TEDBQuery;
 procedure FormCreate(Sender: TObject);
private
   { Private declarations }
public
   { Public declarations }
end;
var
Form1: TForm1;
implementation
{$R *.dfm}
procedure TForm1.FormCreate(Sender: TObject);
begin
Session.LoginPassword := 'EDBDefault';
Session.LoginUser := 'Administrator';
Engine.Active := True;
edbquery1.ExecSQL;
end;
end.



Roy Lambert

Roy,

<< Using D2006 use Alt-r-e to break it and then run again >>

I'm not sure what you mean - are you saying that resetting the application
after the database is created is causing the problem ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


As I said in the first post the program crashed and Alt-r-e is one of the few ways I know to reliably "crash" a program.

I've just tried pasting the code I posted back into the D2006 IDE and running it. Now remember my machine has definitely been turned off overnight but I still get the error.

Error #400 the database RAM already exists

After wading through your code, the cd collector example and flogging my brain I think I know what's happening. It's probably WAD, but is counter intuitive.

The data is probably disappearing from ram (I have no real no way of knowing) but the definition stays in the configuration database so when I reopen an app the memory database is already defined. I'm used to disk databases/tables staying put but not memory ones. Those I would expect to be transient.


Roy Lambert

Tim


Mt scrawlings have prompted two more questions:

What happens to the table definition in the memory database when the app closes?

Will "DELETE FROM memorytable" reclaim the space? If not we need something that allows us to do so.

Roy Lambert