Re: [AD][U2] and PDF

2007-10-22 Thread Brian Leach
Or: [AD] use a dedicated tool like mvPDF that offers a page designer... [/AD] If you factor in the time you save in setting up some of these tools the cost disappears pretty quick. Brian On 10/20/07, Hona, David S [EMAIL PROTECTED] wrote: What does 'manage' mean? Do you need barcodes, table

RE: [U2] Indexing Optimization

2007-10-22 Thread Jerry Banker
Isn't that true only when using 'AND' with the 'WITH' phrase? Using 'OR' would have to use the whole index/selection again. -Original Message- From: Ray Wurlod [mailto:[EMAIL PROTECTED] Sent: Saturday, October 20, 2007 11:30 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Indexing

Re: [U2] ODBC error

2007-10-22 Thread Jeff Schasny
UV 10.0.10 and ODBC driver 3.07.02.7013 This same combination of UV and ODBC driver are working just fine on my personal laptop also under XP Pro I get the same error from HS.SALES, HS.SERVICE and my newly created account. Hona, David S wrote: What are UV server and client releases? Can

RE: [U2] RBO properties lose their values (RedBack 4.3)

2007-10-22 Thread D
Laure, We noticed this problem about two years ago. We have a client that uses RedBack exclusively for data entry and reporting for their public storage warehouse. Every now and then we lose data inexplicably. This happens about twice or three times a week. Since we use RedBack for most of

RE: [U2] -UV- HTTP secure logins

2007-10-22 Thread karlp
Thanks Jeff, I wrote an ftp_get/put as well, but it uses standard AIX programs and works very well. I've used sftp in the past and if that comes up, I'm prepared. It's just that I'm new to the HTTP retrieval world. Just getting it to work at all was exciting for me... Do you know if curl works

RE: [U2] -UV- HTTP secure logins

2007-10-22 Thread karlp
Never mind about the AIX question. I installed the Linux Applications CD for AUX and curl is on it. Now for some good, old fashioned elbow grease. This is the exciting part of my job. Karl quote who=[EMAIL PROTECTED] Thanks Jeff, I wrote an ftp_get/put as well, but it uses standard AIX

RE: [U2] Universe and Microsoft Data Transformation Services (SQL Server)

2007-10-22 Thread Janet Bond
Hello Marcos, Please contact me I can connect you with our developers to review this process. Thanks Janet Bond FusionWare Corporation Sales Operation Manager 1.866.266.2326 x159 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent:

RE: [U2] -UV- HTTP secure logins

2007-10-22 Thread karlp
Okay, I've re-written the application that retrieves product data so it now uses curl, but I'm stumped on the password section. The way the vendor site is written, it doesn't require a password to get search results. If our salesmen are logged in, they get: Retail Price: 2.02 Your Price: 1.21

Re: [U2] -UV- HTTP secure logins

2007-10-22 Thread Jeff Schasny
Not a trivial subject. You should probably contact the site owner and inquire as to what URL encoded string their login program wants to see as a beginning point. [EMAIL PROTECTED] wrote: Okay, I've re-written the application that retrieves product data so it now uses curl, but I'm stumped on

RE: [U2] -UV- HTTP secure logins

2007-10-22 Thread David Jordan
The application checks to see if the user has access to the web page. If the user does not it should go to a login page to prompt for username and password. To by pass this, you may be able to call the login page, feed username and password and then call the page you require. Regards David

Re: [U2] ODBC error

2007-10-22 Thread Ray Wurlod
Excel is different. To get a list of tables from Excel you must specify that you want to retrieve system tables. For some arcane reason best known to Microsoft and not revealed to the great unwashed, Excel worksheets are reported to the ODBC driver as system tables (and therefore get their

RE: [U2] Indexing Optimization

2007-10-22 Thread Ray Wurlod
No, it's true for all cases. UniVerse indexes are only used on restrictions in the first WITH phrase in the query. That's one of the rules. Indexes are used except: 1. if the NO.INDEX keyword is specified 2. if an active Select List can be used (similar logic to current thread) 3. if the

[U2] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?

2007-10-22 Thread Brenda Price
One of our end users started getting the printer on (AccuTerm - this prints everything you do to the printer and keeps it attached to your session so no one else can print) last week. One of our other programs, found the reason was he'd changed some equated statements from having the actual value

RE: [U2] -UV- HTTP secure logins

2007-10-22 Thread Tony G
From: karlp Okay, I've re-written the application that retrieves product data so it now uses curl... I've used cURL for many years and recommend it highly. It's now in its tenth year as open source with a business-friendly license and exceptional maintenance record. While on-going maintenance

Re: [U2] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?

2007-10-22 Thread Richard Nuckolls
When the new version of the equate was compiled under Information flavor, the compiler warned that it was a Reality style LOCATE. To its credit, the compiler defers the evaluation of the EQU until it is used, at which point, it evaluates it in context, so the compiler is evaluating

RE: [U2] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?

2007-10-22 Thread Allen E. Elwood
Very oddnot sure why, mass hysteria? ;-) I'll tell you what, this is an easier construct, especially if you have two dozen or so values to stick into an array. TEMP = CHANGE('A.B.D.M.S.V','.',@VM) EQU VALID.CC.TYPES TO TEMP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: [U2] ODBC error

2007-10-22 Thread Hona, David S
Are you able to successfully complete the ODBC connectivity tests to the demo accounts on your server? If not, fix that first and then if that's not the problem it's probably related to a UV configuration problem. Check your unirpcservices config file and check there is no conflict with any other

RE: [U2] -UV- HTTP secure logins

2007-10-22 Thread karlp
Thanks Tony. I've subscribed to lists and have used OSS (open source software) since about 1991. There is one thing about this situation and using cURL. I'm on AIX and the Linux Applications are specifically remastered for use on AIX. Frankly, I don't think the vigilance is as necessary as I'm

RE: [U2] Universe and Microsoft Data Transformation Services (SQL Server)

2007-10-22 Thread Hona, David S
Let's start with the basics: 1) What version of the UV/ODBC driver are you using to push the data from SQL Server into UV? 2) UV version and OS platform 3) Not really applicable in this particular issue, but: if on UNIX platform: what ODBC driver manager are using and the version? Have you

RE: [U2] Indexing Optimization

2007-10-22 Thread Jef Lee
So, Ray, where do I find these rules? Are they written down somewhere that I can get to and acquire a copy? Jef. - Partial Original Message- No, it's true for all cases. UniVerse indexes are only used on restrictions in the first WITH phrase in the query. That's one of the rules.

RE: [U2] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?

2007-10-22 Thread Gyle Iverson
Richard Nuckolls wrote: the compiler is evaluating VALID.CC.TYPES1,1 as A':@VM:'B':@VM:'D':@VM:'M':@VM:'S':@VM:'V'1,1 The precedence of concatenation is lower than dynamic array extraction. Try placing parenthesis characters around the equate definition. E.g. EQU VALID.CC.TYPES TO

RE: [U2] ODBC error

2007-10-22 Thread Tony G
From: Ray Wurlod For some arcane reason best known to Microsoft and not revealed to the great unwashed... I've blogged some notes on this largely OT subtopic. http:// removepleaseNebula-RnD.com/blog/tech/2007/10/sql-with-excel01.html HTH Tony Gravagno Nebula Research and Development TG@