Search results for query: *

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?

I have a report that is displaying the detail for items sold vs available quantity. I have a running total formula that tracks when Item sold exceeds Qty_ON_HAND. This is based on a formula: {IMINVLOC.QTY_ON_HAND}-{@RunningTotal}>=-1. This gives me a True/False response sorted by ship date. I...

It is weird the user said she could not login to Macola this morning. It was trying to login to the old company we keep for historical year end, we have two companies setup. When I looked at the production company she was no longer listed in the production company, but did exist in the...

Hello, I have a user account that is missing. When I look in the Visual Menu Builder she no longer exists. When I try and create a new account for her, it states that New User is already on file. If I look into User Module Maintenance she exist. How can I get this user back? Where does the...

Windows XP Pro using Fortigate Client. I connect via Wirless WAN connection. I start the Fortigate Client and connect succesfully VPN to Fortigate 200. One issue is I have to log in first to windows via Doamin cached account, then connect to Wireless, then to VPN. I am not able to browse the...

Thanks, Chopstick It worked. Sorry it took so long to reply. I did not have the chance to make the change. pcollins1