Recent content by DPilsbury

Thanks SQLSister, you are correct. But that's ok as this update statement will only be run when the database is fully refreshed with data that is exported from another system.

That did it! Thanks Sunil. I didn't know you could use group by in the set statement.

I'm not sure if this is possible, but.... Given this table structure: myTable mainID subID Amount A1 A1 10.0 A1 A2 10.0 A1 A3 10.0 B1 B1 0.0 B1 B2 25.0 B1 B3 25.0...

I had this problem too. It was a limitation on file sizes. Logon as root. Go to /etc/security look at the file called limits under defaults, locate fsize. If it's not -1, change it to -1. This will allow unlimited file sizes. It worked for me, thanks to my bud Eugene at IDS.

Thanks Yegolev and Needcoffee. I'll go with your solutions. D

Thanks again bi! Looks like I have to implement a filter if I want this to go away...and considering the number of print queues we have...I'm not sure it's worth it. But at least I know now where we stand. Maybe I will create a script that runs in CRON and enables queues.... D

Thanks for responding bi. Actually, we were at 4.3.3, but my involvment started right before we upgraded to 5.1. I don't remember it happening though during the 2 or 3 months that I was helping to support 4.3.3.

We're running AIX version 5.1.0.0. We've set up print queues to several network printers.. all of which are hplaserjet. I've noticed on several occasions that if the printer jams or runs out of paper while printing a job sent from our AIX server, the queue will go down. Thus, when the user...

Did you open the form with the vbModal setting? "Form".Show vbModal I have found that this gets rid of that error.