Jump to content


Steve Kiernan

Member Since 30 Jun 2000
Offline Last Active Sep 11 2012 11:48 AM
-----

Posts I've Made

In Topic: function exceeds workspace

06 September 2012 - 12:30 PM

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

In Topic: MMSQL temporary tables

10 December 2010 - 04:07 PM

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.

In Topic: V6 Bootstraps Available

03 November 2009 - 03:34 PM

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

In Topic: Version 6.1 status

04 July 2008 - 11:02 AM

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

In Topic: Northgate takeover?

10 October 2006 - 07:31 AM

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