Hi,

I have a problem when I want to create memory table. Using DBISAM I put the
DBISAMTable component on the form, defined databaseName as 'memory', created
fields using Table Editor, created indexes, activated component and the
table was created within IDE.

How can I make the in memory table using EDB that can be created in design
time? I need the fields of memory table to populate DBGrid and other
components?

Thanks
Iztok Lajovic

Iztok,

Under DBISAM you can have only one memory database at a time so when you
refer to THE "Memory" database there is no doubt what database you are
talking about. In EDB you can have as many Memory databases as you want
but the price to pay is you must explicitly create memory databases
before you can use them:

CREATE DATABASE "MyTempDatabase" IN MEMORY

As soon as a memory database is created you can use it exactly the same
way you do with any other disk-stored database. There is no difference
except the fact that it is stored in memory. And you can have as many as
you need.

--
Fernando Dias
[Team Elevate]

Iztok,

<< How can I make the in memory table using EDB that can be created in
design time? >>

You can't.  You'll need to use a disk-based database at design-time, and
then switch it to an in-memory database at run-time.  You can do so fairly
quickly by using this ALTER DATABASE statement at run-time:

ALTER DATABSE MyDatabase IN MEMORY

assuming that MyDatabase is already defined with a physical path as a
disk-based database.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

In documentation I couldn't find appropriate information on memory tables. I
tried numerous ways to make things working as I was used to in DBISAM
environment with no success.

Thank you for clarification.
Iztok Lajovic



"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> je napisal v
sporoèilo news:85241A10-F2F2-4C7E-8A0B-6C1DA1CA2D5D@news.elevatesoft.com ...
> Iztok,
>
> << How can I make the in memory table using EDB that can be created in
> design time? >>
>
> You can't.  You'll need to use a disk-based database at design-time, and
> then switch it to an in-memory database at run-time.  You can do so fairly
> quickly by using this ALTER DATABASE statement at run-time:
>
> ALTER DATABSE MyDatabase IN MEMORY
>
> assuming that MyDatabase is already defined with a physical path as a
> disk-based database.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Iztok

>I have a problem when I want to create memory table. Using DBISAM I put the
>DBISAMTable component on the form, defined databaseName as 'memory', created
>fields using Table Editor, created indexes, activated component and the
>table was created within IDE.
>
>How can I make the in memory table using EDB that can be created in design
>time? I need the fields of memory table to populate DBGrid and other
>components?

You can't quite get that far. You can set up the definition of the table using the IDE and use a function (look in the extensions ng) to create the table at run time but you can't open or populate in the IDE.

Roy Lambert [Team Elevate]

Roy,

unfortunately one of very handy possibilities is therefore lost in EDB. I
used it very often to make and test memory tables within IDE, even creating
persistent fields of memory table.

Now I have to make the disk based table with EDBmgr first, make all tests
with this table and alter database in memory database in run time because I
cannot create tables in memory database ad design time (if I understood Tim
correctly).

Iztok Lajovic


"Roy Lambert" <roy.lambert@skynet.co.uk> je napisal v sporoèilo
news:1BB99EE7-FB17-4C13-A9D9-B52490879DBD@news.elevatesoft.com ...
> Iztok
>
>>I have a problem when I want to create memory table. Using DBISAM I put
>>the
>>DBISAMTable component on the form, defined databaseName as 'memory',
>>created
>>fields using Table Editor, created indexes, activated component and the
>>table was created within IDE.
>>
>>How can I make the in memory table using EDB that can be created in design
>>time? I need the fields of memory table to populate DBGrid and other
>>components?
>
> You can't quite get that far. You can set up the definition of the table
> using the IDE and use a function (look in the extensions ng) to create the
> table at run time but you can't open or populate in the IDE.
>
> Roy Lambert [Team Elevate]
>

Iztok


I don't think its any different from DBISAM in that respect apart from the fact that you need to set up the memory database first. AFAIK you've never been able to populate a memory table in the IDE just define the fields and open it.

Roy Lambert [Team Elevate]