Recent content by davjoh

Someone in the last 24 hrs ran the utility that changes the status for every Order from Complete to History. Now when we try to reprint an invoice is gives an error message stating the CO: xxxxxx does not exist.

I want to export a string of data to Excel 2003 that contains the location of a file on my network (ie. file:///\\ss2\trace\text.txt ) and have Excel show it as a hyperlink so when the user clicks on the link it will open the specified file. Is this possible???

Paul, I tried your suggestion, but still no luck. As a last resort before reloading the server from scatch I deleted all of the .pf files from SS3 then copied the .pf files currently used in our production environment (SS2) then pasted into SS3 and only changed the -H setting from SS2 to SS3...

Good idea...but still no luck. If we can't find a solution before I go in to work tomorrow, I plan on reloading the server from scratch but won't install the R2 portion...I have been struggling with this for more than a week...I very much appreciate your suggestions and I will let you know how...

SERVICES file# # The following are SyteLine databases. Last line must be blank!!! # EXEC 19100/tcp # EXEC server cdal 19300/tcp # cdal server cdalcfg 19350/tcp # cdalcfg server dev 19400/tcp...

I enabled Windows Firewall and added the ports (from the services file for each of the databases), prowin32.exe, and _mprosrv.exe to the exception list then shutdown and restarted the databases.....now (from the client) it trys to make the connection about 1:30 seconds longer than before, but...

Please see the attached file and advise...thanks!

CDALRUN.PF# PF-TYPE = R "cdal Run" no # # SESSION,Session-related parameters -Bt 2000 # min: 10 max: 50000 Specifies the number of blocks in the buffer for temporary tabels. -D 150 # min: 5 max: 500 The mumber of compiled procedure directory entries. -TB 4 # min: 1 max: 31 The block...

This might point you in the right direction, or at least give you some ideas - 1. Print a report to show any triggers in each database – Open Procedure Editor > Tools > Data Dictionary > under Databases select ‘symix’ > from main menu select Database > Reports > Trigger > Print the report >...

When trying to make a multi-user client connection to our ERP Syteline 3.5b02a on Progress 8.2c from a client pc I receive this error "Could not connect to server for database d:\syteline.db\cdal, errno 0. (1432)."...I confirmed that the database servers are running and I can connect as a...

I receive this error message when running my progress code - "Microsoft Visual Basic Run-Time Error '5852': Requested Object is Not Available"...when I choose Debug it indicates ".Destination = wdSendToNewDocument" is the problem. The macro runs without errors when executed from Word. The...

Thank You!! Thanks plus_marca...it works great!!

I am having an issue with the syntax when trying to move a worksheet from book2.xls to book1.xls...progress doesn't like the 'move before' statement. /* VB CODE RECORDED FROM MACRO - * Workbooks.Open Filename:="C:\Book1.xls" * Workbooks.Open Filename:="C:\Book2.xls" * Sheets("Sheet1").Select...