I have a memory table which is already created, active and named as ORD_DETAILMEM;

I have an identical table on the disk which is named as : ORD_DETAIL;

What I want to do is insert some records from the disk based table into the memory table. What is the best way to do it? (I can
copy records one by one from the disk based table into the memory table, but there must be a simpler way I guess).

The following SQL codes don't not work for the above mentioned purpose:
INSERT INTO "\MEMORY\ORD_DETAILMEM"
SELECT * FROM ORD_DETAIL;

SELECT *
INTO "\MEMORY\ORD_DETAILMEM"
FROM ORD_DETAIL;

In general, my question is : "How can I use already created memory tables in SQL queries".

Thanks in advance;

John

I forgot to mention:

The memory table is defined in a datamodule and it is used in many forms in the application.

John


I don't have any problems with it. Memory and disk tables should work identically

Roy Lambert

Hi Roy;

I know that memory and disk based tables work the same way.
My question is related to an already created memory table.

Let's say that I have a memory table in a datamodule and I can access it like "Datamodule1.TBL_MEM".
This table is active and contains data.

How can I use this table in an SQL query? What is the format?
SELECT * FROM "\MEMORY\Datamodule1.TBL_MEM" or
SELECT * FROM "\MEMORY\TBL_MEM"

Neither of the above seems to work.

John

John


OK first memory tables are accessible to all sessions WITHIN a process so if the memory table is outside of your process then you can't access it at all (you can try this by creating a memory table in DBSys, starting another copy of DBSys and you won't be able to access it, but you can in the one that created it).

Syntax is simply "memory\table" - I use quotes but I don't think they're strictly necessary.

Next - just because a TDBISAMTable component is on a datamodule doesn't mean there's a table there what you seem to be saying is that you want to address the memory table in sql using the TDBISAMTable component name. What you actually need to do is address it by the name that the component refers to. Check what the TableName property is for Datamodule1.TBL_MEM and that's what you should use.

If I've totally misunderstood what you're saying and doing sorry.

Roy Lambert

John,

<< The following SQL codes don't not work for the above mentioned purpose:
INSERT INTO "\MEMORY\ORD_DETAILMEM"
SELECT * FROM ORD_DETAIL; >>

That is the correct method to use.  What is occurring when you try that - is
there an error or do the records simply not get copied ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Yes, it works.

Sorry for the previous posts. There was a mistake on my part.

John