mmeneses

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

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

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

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

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