Re: [U2] Upper Case Input

2011-09-30 Thread Trevor Fulton
Yes there is, In /HK.CONTROL the field Subr End SB.INPUT allows you to run a piece of code after every input into SB. In this you need something like IF PARMS(30)38 # 1 THEN INPVAL = OCONV(INPVAL,MCU) VALUE = OCONV(VALUE,MCU) END The PARMS(30)38 stuff

Re: [U2] The math just doesn't work.

2011-09-30 Thread Martin Phillips
Hi Mecki, I actually wonder if this feature is flavour specific? Pick didn't use floating point arithmetic and IIRC the default precision used to be 4. PRECISION affects the number of decimal places in the result when converting a floating point value to a character string. All internal

Re: [U2] Upper Case Input

2011-09-30 Thread Boydell, Stuart
In the conv slot of the field defn of the dict or in the field defn, F6 for the screen set the override conv to MCU[I -Original Message- From: Israel, John R. Sent: Friday, 30 September 2011 6:49 To: 'U2 Users List' Subject: [U2] Upper Case Input I am not sure we even want to do this

Re: [U2] Upper Case Input

2011-09-30 Thread Israel, John R.
THAT is the trick I needed (though I am not sure we will do it). I needed a single place where this could be implamented, i.e. a global setting or a single global program. Thanks! John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH  45342

Re: [U2] Reading Dictionary Items

2011-09-30 Thread Bill Brutzman
As there is only one geek here... and none of the application programs touch the dictionaries, It would be like putting a lock on the bathroom door in the honeymoon suite. --B -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org]

Re: [U2] Reading Dictionary Items

2011-09-30 Thread Bill Brutzman
Adrian: Thanks UPDATE.RECORD is a useful thing to know about. It happens that on top of this task, for JDBC reasons, I had to do something similar with creating a large @SELECT statement. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org

[U2] uniobjects issue

2011-09-30 Thread douglas chanco
I have a fairly simple c# .net console application that selects data from a pick file loads it into a (in memory) data table and then bulk loads it into a sql table. The process works fine on a test system but on another system that has the same pick table but with 20ish indexes (yeah I know)