Jump to content


Michael Pistrang

Member Since 23 Jun 2010
Offline Last Active Sep 10 2012 08:17 PM
-----

Posts I've Made

In Topic: PROIV Hangs

24 May 2011 - 10:47 PM

Just exported around 170 functions/files:
Proiv client times out after about 7 seconds, but after a minute of the progress bar stuck at 11%, the export is completes successfully.


Hi Michael,

How long are you actually waiting until it times out?

Lew



In Topic: PROIV Hangs

24 May 2011 - 10:31 PM

We sometimes experience a similar situation to this when performing any list based tool with maybe 30 functions or more. The local computer behaves as if Windows thinks Proiv has timed out, but if we wait long enough the Proiv process finishes and Window is happy again.

Client Version 6.1.57 (local machine is Vista:))

In Topic: MMSQL temporary tables

10 December 2010 - 03:57 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.

In Topic: FOLDER file type

23 June 2010 - 11:08 PM

Is anyone using this and knows how it is supposed to work or can point me at where it's documented?

T.I.A.


We currently use this file type to check if a file exists in a specified directory. I was also able to create a little recursive global update which searches a folder and all sub-folders within the defined folder for a specific file name, returning the path of the first file that matches. :)