RE: [U2] RE: ODBC problems

2008-07-01 Thread Hona, David S
Is it the same query for both files/tables (that share the same dictionary)? Do both your queries work from a different client PC? If so, is there different client software versions or ODBC clients? Regards, david -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On

RE: [U2] [UV] AR collection software

2008-07-01 Thread Kathleene M Hunter
What feature do you need. -Original Message- From: John Hester [mailto:[EMAIL PROTECTED] Sent: Monday, June 30, 2008 12:48 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] AR collection software Anyone know of a good Pick-based AR collection management software package?

RE: [U2] Unidata - handler for mistyped commands?

2008-07-01 Thread Kathleene M Hunter
Create a VOC enter that is the typo that executes the correct process. Example ED VOC EDIT.PROG 01: S 02: ED BP ED VOC EDIT.PROG 01:PA 02:ED BP ED VOC EDIT.PROG 01: PQ 02: HED BP 03: P (note that line 1 may need to be PQN) If you want to have it global catalog a program under a different

RE: [U2] RE: ODBC problems

2008-07-01 Thread Anthony Youngman
What I did was link to the table in Access, open it, and then click on a column to sort it. So it should have been an identical query. I thought I'd test it - get Dr Dee Bee Spy to monitor me doing it on the table that worked - and guess what! That table won't sort now, either! I thought that

RE: [U2] Unidata - handler for mistyped commands?

2008-07-01 Thread Edward Brown
Yes, I've already got some VOC entries that are shortcuts to longer named jobs, and we do have a few VOC entries to catch common typos, what I'm wondering is if there is a more generalised way of intercepting unrecognised commands, ideally a way of calling a specific 'handler' program that can see

RE: [U2] [UV] AR collection software

2008-07-01 Thread David Ward
Columbia Ultimate http://www.columbiaultimate.com/ will likely be your only commercial, pick-style option. Ontario Systems http://www.ontariosystems.com/ used to have a system that ran on pick variants, but I think they moved everything to the Cache database (a pick/sql hybrid) The software

[U2] locking question

2008-07-01 Thread doug chanco
hey all, has anybody run across/seen an issue where a process sets a lock via READU and then when it tries to write back the record cannot because the record is locked but somehow lost the fact that the process trying to write the record is the process that created the lock? I am not

Re: [U2] locking question

2008-07-01 Thread Martin Phillips
Hi Doug, has anybody run across/seen an issue where a process sets a lock via READU and then when it tries to write back the record cannot because the record is locked but somehow lost the fact that the process trying to write the record is the process that created the lock? My money (but

RE: [U2] locking question

2008-07-01 Thread Anthony Youngman
I notice you're on nix ... Is the piece of code that writes invoked via an EXECUTE or PERFORM from the code that did the original READU? I wouldn't expect it to on doze, but on Unix that *might* change the execution environment enough to cause a problem... (grasping at straws to see if it

RE: [U2] Unidata - handler for mistyped commands?

2008-07-01 Thread Jim Anderegg
Not exactly on topic: Back in the day (that would be the early 90's) I used to work in a SCO unix environment - the command interpreter had a built in spell checker that would offer a suggestion for the command you might have meant whenever you had a typo. Pretty nifty. -Original

Re: RE: [U2] [UV] AR collection software

2008-07-01 Thread rogu2
John Are you making the move from being factored to trying to doing your own credit and collections? So that you need to track outstanding orders and compare them to outstanding invoices and the customer's credit limit? Or do you already have invoicing, cash posting and an aging system?

RE: [U2] RE: ODBC problems

2008-07-01 Thread Kathleene M Hunter
Which U2 and os -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Tuesday, July 01, 2008 1:27 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] RE: ODBC problems What I did was link to the table in Access, open it, and then

Re: [U2] locking question

2008-07-01 Thread doug chanco
Thats for the responses Wol and Martin! Wol - the lock and the write are in the same program so there is no execute involved. Martin - I need to look up the archives that previously talked about the query processor holding a group lock but that is exactly the lock we are seeing (a group

Re: [U2] locking question

2008-07-01 Thread Herve Balestrieri
If you are sure that this is a Group lock (of what type ?), you may adjust the UniVerse parameter PAKTIME, which stands for the duration of a Group lock corresponding to the record displayed just before the Press any key to continue... prompt. Reason being for that parameter that when a LIST

RE: RE: [U2] [UV] AR collection software

2008-07-01 Thread John Hester
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 11:46 AM To: u2-users@listserver.u2ug.org Subject: Re: RE: [U2] [UV] AR collection software John Are you making the move from being factored to

RE: [U2] [UV] AR collection software

2008-07-01 Thread John Hester
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kathleene M Hunter Sent: Monday, June 30, 2008 10:45 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] AR collection software What feature do you need. Kathleen, I think the main

RE: [U2] locking question

2008-07-01 Thread IT-Laure Hansen
Is the rule of thumb about the value of GSEMNUM valid for other systems? We are running UV 10.2.3 on Win2003 server with a 110 UV user license. Our VAR set GSEMNUM to 97. Is this likely to cause any problems? I hasten to say we have no locking issues on our system. Thanks, Laure Hansen, City of

RE: RE: [U2] [UV] AR collection software

2008-07-01 Thread daverch
[ad] John, We have a web based CRM system with notes, tasks and templates to create tasks that fits the bill. It is based on new technology (Eclipse based XLr8) and runs on either Unidata or Universe using Apache Tomcat and our middleware called U2Weblink(tm). One of our clients uses the system