2 replies to this topic

[Steve Kiernan]

I need to create temporary data in msssql which I can then read in a proiv update or paging screen.

Creating the table and inserting into it is not a problem using

SQL
CREATE TABLE #TEMP
(
COL1 VARCHAR(2),
COL2 VARCHAR(30)
)

INSERT INTO #TEMP(COL1, COL2) VALUES('a',’b’)
ENDSQL


(at least I get no errors!)
but when I try to select and then subsequently read the selected entries by inserting

SELECT COL1, COL2 FROM #TEMP before the ENDSQL I get no records returned into the @F which corresponds to the file

Any suggestions please?

[Michael Pistrang]

I need to create temporary data in msssql which I can then read in a proiv update or paging screen.

Creating the table and inserting into it is not a problem using

SQL
CREATE TABLE #TEMP
(
COL1 VARCHAR(2),
COL2 VARCHAR(30)
)

INSERT INTO #TEMP(COL1, COL2) VALUES('a','b')
ENDSQL


(at least I get no errors!)
but when I try to select and then subsequently read the selected entries by inserting

SELECT COL1, COL2 FROM #TEMP before the ENDSQL I get no records returned into the @F which corresponds to the file

Any suggestions please?

Is your SELECT statement in the same SQL DYNAMIC block as the CREATE and INSERT statements? Try having the SELECT statement in a seperate SQL DYNAMIC -> ENDSQL block. Also, make sure your SELECT statement is in the appropriate Logic point/location depending on the type of function you are programming in.

Edited by Michael Pistrang, 10 December 2010 - 03:58 PM.

[Steve Kiernan]

I need to create temporary data in msssql which I can then read in a proiv update or paging screen.

Creating the table and inserting into it is not a problem using

SQL
CREATE TABLE #TEMP
(
COL1 VARCHAR(2),
COL2 VARCHAR(30)
)

INSERT INTO #TEMP(COL1, COL2) VALUES('a','b')
ENDSQL


(at least I get no errors!)
but when I try to select and then subsequently read the selected entries by inserting

SELECT COL1, COL2 FROM #TEMP before the ENDSQL I get no records returned into the @F which corresponds to the file

Any suggestions please?

Is your SELECT statement in the same SQL DYNAMIC block as the CREATE and INSERT statements? Try having the SELECT statement in a seperate SQL DYNAMIC -> ENDSQL block. Also, make sure your SELECT statement is in the appropriate Logic point/location depending on the type of function you are programming in.

Thanks Michael - I included all statements inside the same SQL block.

Interestingly, when I tried to get PROIV to write/read a global temporary table (##TEMP) it had no problems.