RE: [U2] UniVerse SQL Tables

2008-04-29 Thread David Jordan
Gerry If you define a column as integer and that attribute is not an integer, then the write will lead to a fatal error if you do not have opencheck or on error options built into your code. If you do not define a column as multivalue, then it will have a problem with multivalues. If you do not

RE: [U2] UniVerse SQL Tables

2008-04-29 Thread u2ug
Just so there is no question , below is the output of a simple test program , Note that the INSERTs fail on bad data as they should but OPENCHECK/WRITE ICHECK do not. Bad data is definitely being written into the table. OS Info : .L RELLEVEL RELLEVEL 001 X 002 10.1.8 003 NEWACC 004 005

[U2] UV users in Holland

2008-04-29 Thread martinphillips
Hi all, I am looking for a UniVerse user in the insurance business in Holland who would be willing to take a call from a prospective UV user to verify that multivalue is a serious option and not some obscure technology. I will be talking with them late May / early June but they want to find some

[U2] Press any key to continue...

2008-04-29 Thread Steve Ferries
Hi All, We were coding a standard INPUT ANS after asking a user to Press any key to continue We noticed that the program would not accept a Space Bar as a valid key; it only moves the cursor to the right. However, the Press any key to continue... message from UniVerse accepts the Space Bar

RE: [U2] Press any key to continue...

2008-04-29 Thread JPB-U2UG
INPUT ANS,1 Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Ferries Sent: Tuesday, April 29, 2008 2:46 PM To: u2-users@listserver.u2ug.org Subject: [U2] Press any key to

RE: [U2] UV users in Holland

2008-04-29 Thread Symeon Breen
Hi Martin, I know that Andy Lakeland, who I think is still on this list, is in Holland, he is not in the insurance business but he may know someone. Probably a big ask - insurance business, Holland and universe you know ... Symeon -Original Message- From: [EMAIL PROTECTED]

Re: [U2] UniVerse SQL Tables

2008-04-29 Thread Clifton Oliver
The parameter is OPENCHK. OPENCHK - the modifies the behavior of operations upon files open via the BASIC OPEN statement. When set to zero, I/O to files open with the BASIC OPEN statement ignore integrity constraints. If non- zero those files will observe the constraints. This tunable does

RE: [U2] UniVerse SQL Tables

2008-04-29 Thread u2ug
My test program uses OPENCHECK so the setting if this parameter should not be having any effect. However, just to stoke the fire, I have verified via uvconfig CONFIG DATA that we do have OPENCHK set to '1' !! So we should be seeing data constraint errors being reported by OPEN/WRITE ,

RE: [U2] UV users in Holland

2008-04-29 Thread John Jenkins
Hi Martin There are a number, but client confidentiality means I canbt respond unfortunately. If you follow up with [EMAIL PROTECTED] they should b3 able to assist if the sites are referenceable Otherwise - if you can let me know offline by PM who the Company is I may be able to put you in

RE: [U2] Press any key to continue...

2008-04-29 Thread Womack, Adrian
While INPUT ANS,1 will work most of the time, if the user decides to press the backspace key or even the ESC key, nothing will happen. An alternative is: ANS = KEYIN() CLEARINPUT Which will grab a single character (including a backspace, etc). Note: if the keystroke sends two characters (eg.