Recent content by pcollins1

I have been tasked with using a 4-4-5 date scheme and have created a SQL command to query a table to calculate beginning and end date for periods. I have determined the command itself returns the result quickly, but if called from the select expert it is slow. Here is the SQL command...

We upgraded the other night to version IP Office 9.1 and had several issues with the soft console. First could not login which turned out to be that the current 9.0 soft console and previous releases will not work with 9.1. Would receive Login error. After upgrading to the new version was able...

I was able to accomplish this by newly installing Macola on the new test Application server from the new test SQL server. Creating a new mapped drive to the Test App Server macsql directory. Copying over the Test macsql directory with the prod macsql directory. Restoring the Production data...

We are on 7.7.700 in production on a separate Macola App Server and Data on a Separate SQL Server. What I was hoping to do is install Macola on a Test App Server and restore the Production Macola data to a test SQL server. Then copy the production Macola App Server folders over the newly...

We are doing some heavy development with Wisys and Macola 7.7 and need to set up a different Progression and SQL environment that will not affect production. I have both a separate Dev Macola server and Dev SQL server available. Would like to restore production data to this Dev SQL Server and...

I have put the exact same post out on the HP forum, but as of yet have had no response. The bug check I posted above does say driver_fault: DEFAULT_BUCKET_ID: DRIVER_FAULT but it does not at least as I can tell which driver is causing the fault. I do know it is these windows updates that are...

I have 2 brand new HP XW4600 Workstations. After Last weeks Microsoft Security updates for May were downloaded and installed on these workstations, they Blue Screened and kept rebooting directly after login. I windbg the mini dumps and it seems to point to CSRSS.EXE crashing after these updates...

I have a named instance that is installed on a local machine with SQL Express. When I try to connect to it remotely , I get "under default settings SQL Server does not allow remote connections." I go to the configuration manager, but I can not see the named instance to set "allow remote...

Thanks LB worked like a charm!

Hello, I have a report that contains a formula field in it. I am trying to filter out all records that contain whole integer values that are diplayed form the formula field. If it says 1.00 or 8.00, I want to filter these out, but if it says, 0.92 or 2.83 I want to display these on the report...

I do! Thanks for the help.

Thanks, that seems to be working. I am just checking some values to compare against.

SLSID ITEM_NO PROMISE_DATE QTY_ON_HAND ORDER# Line# Bill_TO BC 1.5S1432 20070906 51,500 134576 1 ABC Co. BC 1.5S1432 20070906 51,500 134576 2 ABC Co. DK 1.5S1432 20070910 51,500 136240 1 XYZ Co. @READY_TO_SHIP QTY_ORDERED RUNNING_TOTAL TRUE...

{@runningtotal) RT ("Amount","Sum",{OEORDLIN.QTY_ORDERED},{IMINVLOC.ITEM_NO})

Right, it is Macola using the older Pervasive Databases. How can I make a record selection formula to show this. It will not let me create record selection using the formula. The message I receive is cannot use formula in formula, it must be evaluated later! Any other ideas?