Steve Kiernan

Thanks Steve,

I don't think there's a fault in the function because (as an example) the function was giving us the error and by defining some scratch vars it worked again.


Steve

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.

Did anybody get hold of them before they went or does anybody know the definition for vipbm19.pro?

Hello,
Does anyone have any new info on this? We have a customer who wants to install Vista on their workstations so that means we have to give them the 6.1 client. I'd like it to go smoothly, so any pointers before they begin would be greatly appreciated.

We're running on Vista using 5.5r3.4.5 & mfc524 and have been for many months

I made an offer of £1.20 and they're still considering it. I think I overvalued the company myself.