Jump to content


mmeneses

Member Since 29 Sep 2003
Offline Last Active Jul 11 2007 02:29 PM
-----

Topics I've Started

65000 records

15 May 2006 - 12:57 PM

Hi to all!

I have a problem dumping data to excel spreadsheet. I came across with this problem when the program tries to dump a record of more than 65000 (excel maximum number of rows per spreadsheet).

Any idea how to dump the data to the next sheet once I reached this maximum number of rows?

p.s. I call a batch file to open an excel template.


Thanks,
Mike

Maintain Groups and Files - Regen option

08 September 2005 - 01:35 PM

Hi Everybody,

Anyone out there encountered this error in super layer? I got this error every time I choose the option 'G' - maintain groups and files from the function regen window. Pls. advise.

Pro-iv Error :
(error code 28)
018 - Error In Writing File - S_SLGRP S_SLGRP (IN SL FUNCTION: SLGRPS)

System Error:
No space left on device



thanks,
Mike

isamdef

01 August 2005 - 07:08 PM

Hi all,
I’ve read some topic from this forum about ISAMDEF setup and they suggested having these entries in your ISAMDEF file.

MAXFILES = max # of open isam files
SHMSIZE = shared memory size (alternate to above 4 parms)

Note : SHMSIZE is the alternate of the following

MAXUSERS
USRFILES
MAXLOCKS
AVGLOCK

Is there any conflict or problem if I combine these entries on my ISAMDEF file?

MAXFILES = 200 max # of open isam files
MAXUSERS = 64 max # users in system
USRFILES = 10 max # open files per user
MAXLOCKS = 100 max # of simultaneous rcd locks
AVGLOCK = 64 average size (bytes) of a record lock
SHMSIZE = 65532 shared memory size (alternate to above 4 parms)


Thanks,
Mike

Multiple Database

01 June 2005 - 04:49 PM

We have a lot of applications and incoming applications that need to access the SQL server. This is what I’m doing so far to access the other database (SQL server)… create an ORACLE VIEW and connect it via the gateway, then create the external file so I can use it in our PRO-IV application.

Though all of the apps were written in the ORACLE stored procedure it’s not a guarantee that you will have a quick response from the database because every time we request a query via gateway it slows down our glovia apps.

As far as I’m concerned I don’t want to resort to any other database layer. So since we have a lot of incoming projects I just thought of this using multiple databases in PRO-IV (SQL and ORACLE) so I can access it direct. Is this possible?

Thanks,
Mike

Blinking Field / Color Red

28 April 2005 - 02:09 PM

Hey guys, Do you know how to display a blinking field ? I have a program and I just want to get the user's attention on that field.

thanks,
Mike