Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 7 of 7 total |
creating memory tables |
Mon, Feb 16 2009 12:39 PM | Permanent Link |
"Iztok Lajovic" | 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 |
Mon, Feb 16 2009 1:03 PM | Permanent Link |
Fernando Dias Team Elevate | 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] |
Mon, Feb 16 2009 3:21 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Mon, Feb 16 2009 5:00 PM | Permanent Link |
"Iztok Lajovic" | 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 > |
Tue, Feb 17 2009 3:40 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
Tue, Feb 17 2009 5:26 AM | Permanent Link |
"Iztok Lajovic" | 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] > |
Tue, Feb 17 2009 6:45 AM | Permanent Link |
Roy Lambert NLH Associates 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] |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |