TEMPORAL TABLES

[#1]

Hi,

Anyone can give me a little explanation on how can i make temp tables on qv script plz?, or how can i handle sql temp tables on the qv script plz.

Any help will be appreciate.

Carlos

[johnw]

Here is an example of creating a temp table from an SQL temp table, if I understood your question:

MyTempTable:
LOAD *
;
SQL
SELECT Z, A, B, A+B AS C FROM (
SELECT Z, MAX(ABC) AS A, SUM(XYZ) AS B
FROM some table
WHERE some condition
GROUP BY Z ) AS TEMPTABLE
;
...
Do things with MyTempTable
...
DROP TABLE MyTempTable
;

[#3]

Thanks a lot John, you were very helpful.

Regards

CArlos

[#4]

Hi, Carlos.

In the other way, you can create temp tables witch "Load InLine ..." statement manually.

This is only usefully for short quantity of data. For example you can make something like this

TempTable:
Load * inline
[campo1texto,campo2numero,campo3texto
"1",1,"texto1"
"2",2,"texto 2"
];

[#5]

Hi Carlos,

Thanks for your post.

Regards

Carlos