Re: [U2] SQL query locks

2007-08-28 Thread Ray Wurlod
If this is UniVerse there is a uvconfig parameter MAXRLOCK that specifies how many record locks to take (on an INSERT, UPDATE or DELETE statement) before choosing to use a FILELOCK. Reducing this parameter will mean fewer record locks per query, at the cost of greater danger of another

RE: [U2] Learning Uniobjects.NET

2007-08-28 Thread Jonathan Lienhoop
Yea, I can make a connection just fine. But I would like to create a connection pool so my web app always has a couple open connections to work with. Jon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Jenkins Sent: Monday, August 27, 2007 7:26

RE: [U2][UV] Up casing Login IDs {unclassified}

2007-08-28 Thread Jonathan Lienhoop
Yea, I can make a connection just fine. But I would like to create a connection pool so my web app always has a couple open connections to work with. Jonathan Lienhoop Marvin Johnson Associates, Inc. 1.800.457.5255 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

RE: [U2] SQL query locks

2007-08-28 Thread Wally Terhune
as far as I know, this issue was specific to UniData - as it was an SQL engine problem - not common client-side software. When you say 'it', to you mean that you are running a SQL update statetment with a WHERE clause and you see the records that were excluded from the query by the WHERE clause

RE: [U2] Learning Uniobjects.NET

2007-08-28 Thread Symeon Breen
Hi Jonathon As far as I am aware, connection pooling will work in an asp.net environment. The connection is then shared by the web users, not sure if this would be restricted to the application pool or not tho (it is something I am going to be doing very soon). You need to buy a special

Re: [U2] SQL query locks

2007-08-28 Thread Pamela J Robbins
No, it UniVerse. Thanks, Pam Wally Terhune wrote: If this is UniData, we fixed a problem in this area at 6.1.7 (released 3/18/05): Issue 6917 - Problem Description UniData -- A lock release in SQL UPDATE failed, causing SQL to hold the locks for records that were excluded from the query with

[U2] Forms printing

2007-08-28 Thread Andrea Charles
I was wondering if anyone could suggest a method or product they have used to take reports normally spooled to a line printer with preprinted forms, and print them on alaser printer using a stored form and logo, with the data overlaid. Ideally it should be transparent in that the UniVerse report

Re: [U2] SQL query locks

2007-08-28 Thread Pamela J Robbins
This is from our Cold Fusion programmer: All our apps do are SQL SELCT statements (a few of which are complex with joins), but the only commands being sent are SELECT. I do not explicitly set a lock command or statement anywhere in the application. We are using Cold Fusion 7 connecting to

RE: [U2] [ud] makeudt shot in the dark...

2007-08-28 Thread Ken Wallis
John Solie wrote: Hi, I'm wondering if anyone's had success in doing a makeudt with Unidata 7.1.10-64 on AIX 5.3-06 using gcc 4.0.0. Thanks, Not specifically, but try posting the output you're getting and we might be able to provide pointers on where to look next. I typically use gcc 4.0.2

RE: [U2] [ud] Question on Alpha Sorting...

2007-08-28 Thread Ken Wallis
David, Doubtless you'll have coded this by now, but certainly in the situation you describe, I'd store just the 'as typed' case version of the list on disk, then immediately after read, I'd create an in memory 'all uppercase' version in one go - just UPCASE the whole attribute - and I'd probably

RE: [U2] Forms printing

2007-08-28 Thread Bob Witney
We use this software which sits on a virtual server that aix thinks is a network printer http://www.formsmaster.com/ Just spool the report and then revamp it using the middleware Easy peasey :-) Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of

RE: [U2] [ud] Question on Alpha Sorting...

2007-08-28 Thread David Wolverton
Yes - project finished - I ended up coding it to do the UPCASE on the fly by moving the current Attribute into a WorkVariable and UPCASEing the WorkVariable. Ultimately, it seemed better than 'permenantly' wasting the space on disk when we may never have to do another insert. I didn't do the

RE: [U2] Forms printing

2007-08-28 Thread Davis, Dawn
Source4 Formport is awesome as well... Dawn Janel Davis DBA II [EMAIL PROTECTED] 410-386-8058 Carroll Community College 1601 Washington Road Westminster, MD 21157 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Tuesday, August 28,

[Fwd: RE: [Fwd: Re: [U2] SQL query locks]]

2007-08-28 Thread Pamela J Robbins
Can you update your post to ask specifically a)if someone has encountered locks while strictly doing SELECT statements? b)Does the with (nolock) work the same for UniVerse as it does for SQL Server? c)Do transaction isolation levels apply to users or transaction types, and how can they be

RE: [U2] Forms printing

2007-08-28 Thread Barry Rogen
AdvancedWare puts out a very nice package that lets you do just that. We use the product to print POs, Invoices, BOLs, etc. Does a nice job. Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED]

[AD] RE: [U2] Forms printing

2007-08-28 Thread Carl Dula
Yes, we have a product that will do exactly what you want if you are running on an AIX based IBM RS6000 and have a postscript printer. Our Laser Forms Printing System (LFPS) will allow you to take normal print files sent to a line printer with pre printed forms, and print them on a laser printer

[U2] HTML to ...something else...

2007-08-28 Thread Kevin King
Having spent quite some time in and around Optio, I - prodded by a few clients - am searching for a better way. Is anyone aware of any tools that take HTML to other formats, like PS, PDF, PCL? I know of the HTML2PCL script that's floating around but that seems to be a bit too limited. Any other

RE: [U2] Learning Uniobjects.NET

2007-08-28 Thread Bill Haskett
Jonathan: The only advice I can give is to get some __HELP__. This kind of development environment is extremely complex and not for the faint of heart! Sure, you can create a single web service, or a single program, but when one starts working more with this technology it becomes clear that

RE: [U2] Forms printing

2007-08-28 Thread Les Hewkin
We use a big Xerox for this type of thing, but we are printing over 20,000 pages a day. I believe they have smaller printers that can do the same thing. Les Sherlock Hewkin Project Manager - Financial Systems 01604 592289 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: [U2] Forms printing [not-secure]

2007-08-28 Thread Hennessey, Mark F.
Look into PlanetPress Suite: http://www.objectiflune.com Excellent software, well supported, and it doesn't cost an arm and a leg. We pump stuff from our UniVerse box (10.0.8 on Solaris) and our IBM mainframe... (It understands lots of formats for input). Contact me off list if you want any

RE: [U2] Learning Uniobjects.NET

2007-08-28 Thread Jonathan Lienhoop
I don't quite understand how adding a webservice to my project would really help, but maybe its cause I'm not a developer. Here are the basics of my class file and how I open and manage sessions and file. -us1 is a public UniSession variable declared in my class file (DAL.cs). This way I can

[U2] Moving Average Cost

2007-08-28 Thread Baker Hughes
Hey, I have a distribution/manufacturing question. Could some of you share your formula for calculating Moving Average Cost. Consider: Assume you are receiving stock into the warehouse, and recalculating your new average cost upon each receipt (which later serves as basis for your cost-plus

RE: [U2] Forms printing

2007-08-28 Thread Larry Hiscock
Checkout UnForm from Synergetic Data Systems (http://www.unform.com). Their latest version can sit on a server and look like a JetDirect device. It can also create and email PDF files, and with some optional addons, archive all of the printed output. In addition to using overlays, their markup

RE: [U2] Learning Uniobjects.NET

2007-08-28 Thread Jonathan Lienhoop
Makes me laugh, I've only preaching the same thing (about getting experienced help) since January. But my boss doesn't seem to think hiring developers either as consultants or staff is worthwhile. He expects me to learn this stuff. So while I'm here I will and I want to do the best I can. In

Re: [U2] Tlnet error 1067

2007-08-28 Thread jjuser ud2
What operating system? On 8/27/07, Charles Barouch [EMAIL PROTECTED] wrote: Brenda, Certainly worth a look see. - Chuck Brenda Price wrote: My only glimmer of an idea is that it worked before I installed my software for dialup internet access (i.e.: EarthLink). Maybe it does

[U2] Telnet Errors

2007-08-28 Thread jjuser ud2
Hi there, Can somebody at least point me to the correct documentation for troubleshooting this error? It is given by the udtelnet service on RedHat Linux Enterprise 3. in file: udtelnetd-10709.log 09/04/2007 14:45:54 UniData telnet/SSL server started at Tue Sep 4 14:45:54 2007 09/04/2007

RE: [U2] Forms printing

2007-08-28 Thread phil walker
Create!form/Create!Print does the same thing. You basically create a data map overlay of the existing print job and then position these maps on the designed form. You can use data within the map to do conditional processing. Very good. Phil -Original Message- I was wondering if

[U2] Clearing a portion of a screen

2007-08-28 Thread Joseph Ruiz
I know this is an easy question but how would I, in Universe, clear out a section of a screen? Now I am doing the following: COL = 1 FOR XXX = IST.ROW TO LST.ROW CRT @(COL,XXX):@(-4) NEXT XXX Say the first position is (1,1) and the last is (6,6). I think I have done this

RE: [U2] Forms printing [not-secure]

2007-08-28 Thread Anthony Caufield
We use unform by SDSI. Prety cool and will run on unix,linux and windows. New programming to learn but very cool. Tony Caufield IS Manager Harbor Wholesale Grocery Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hennessey, Mark F. Sent: Tuesday,

RE: [U2] Moving Average Cost

2007-08-28 Thread Brutzman, Bill
We have done a lot here recently with inventory valuations. Why care about Moving Average Costs. Consider using receivers as lot numbers and do actual costs of what is there. We do our valuations on a monthly basis. If weekly or daily costs are needed, consider saving this daily data to a

RE: [U2] Learning Uniobjects.NET

2007-08-28 Thread Bill Haskett
Jonathan: You ask; But is there any way I could create my own connection pool?. The answer is yes, and here is how it can be done: 1) You get extremely lucky in your development and make a thousand design decisions correctly, 2) You get outstanding help (not just any .NET programmer) from

RE: [U2] Moving Average Cost

2007-08-28 Thread Larry Hiscock
Don't use absolute value, or you'll screw up your average costs. When you're adjusting inventory out, you're REDUCING the total value of your inventory. The average cost for whatever's left should be the new inventory total value divided by the new quantity on hand. For example: if you receive

Re: [U2] Forms printing

2007-08-28 Thread Nancy Fisher
Is that the name of the product: Create!form/Create!Print ? Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] - Original Message - From: phil walker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, August 28, 2007 1:04 PM

RE: [U2] Learning Uniobjects.NET

2007-08-28 Thread Nick Cipollina
The only thing I can say about this is that your boss is actually doing you a favor in forcing you to learn this stuff. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jonathan Lienhoop Sent: Tuesday, August 28, 2007 2:32 PM To:

RE: [U2] Clearing a portion of a screen

2007-08-28 Thread Brutzman, Bill
Try the command space(Width) per the following. -Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Joseph Ruiz Sent: Tuesday, August 28, 2007 4:42 PM To: u2-users@listserver.u2ug.org Subject: [U2] Clearing a portion of a screen I know this is an

RE: [U2] Clearing a portion of a screen

2007-08-28 Thread u2
It depends on what kind of terminal you're using. If you're using a terminal emulator like Accuterm, there are command to set and clear an arbitrary block on the screen. If you're using a vt100-type terminal or emulator, you can set a scrolling region and then clear the region (by scrolling it).

Re: [U2] Clearing a portion of a screen

2007-08-28 Thread Ray Wurlod
Close, but the first column on the screen is #0. Your approach clears to the end of the line for each row processed. You can also use @(-3), which clears from current cursor position to end of screen. Tip: the @() function is quite expensive to evaluate - evaluate it once (outside the loop)

RE: [U2] Forms printing

2007-08-28 Thread phil walker
http://www.bottomline.com/document_process_automation/createform.html I think these guys must be agents for it. Here is there blurb Create!form(r) Award-Winning Document Process Automation Solution The Create!form(r) suite - featuring Create!form Designer(r) and Create!form Director -

Re: [U2] SQL query locks

2007-08-28 Thread Ray Wurlod
When a UniVerse/SQL SELECT is in progress, each group (one at a time) is latched to prevent the current group from being modified. However, these group latches are released immediately the SELECT has finished processing that group, so that ought not to be an issue apart from the minor

[U2] Uniobjects error 39027

2007-08-28 Thread Paul Parkinson
I'm sure this question must have been asked many many time and you folk out there have probably encountered it yourself. I have an application written in VB6 which has been working fine and now when the app tries to connect to the Unidata account it throws out the connection with error 39027

Re: [U2] Uniobjects error 39027

2007-08-28 Thread John Kent
Paul, i rewrote all my VB6 apps in C# and VB.Net and used Uniobjects dotNet instead of Uniobjects. In UniObjects dotNet there is a parameter, ie Service which lets you specify a Universe or Unidata platform. You are probably going to have to do the same, eventually. jak - Original

Re: [U2] Tlnet error 1067

2007-08-28 Thread Charles Barouch
Windows, but I don't know which version. jjuser ud2 wrote: What operating system? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Clearing a portion of a screen

2007-08-28 Thread MAJ Programming
Ray: How do you figure 'expensive' and under what circumstances (ie processor and number of users?) It's been a while since a topic like this has come up for me. Actually, now that I think of it, it was in the late 1970's when setting up local 9600 baud terminals and then being home with a 300

Re: [U2] Moving Average Cost

2007-08-28 Thread MAJ Programming
Note on your calculations: If you account for everything, the minus 100 would have hit the GL for a -$500 loss (shrinkage etc). Then your $1010 would be an inventory overvaluation that would have been caught on the accounting side as you would have variance between the purchase price (amount