Re: [U2] how to round to 2 decimals?

2010-10-14 Thread John Woollam
Hi I've always used 'R2' e.g. ANS = N1 * N2 'R2' No scaling, just rounding Regards John Woollam | Group Function Support 1 (Finance Systems) | Travis Perkins PLC | 01604 682751 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun

Re: [U2] how to round to 2 decimals?

2010-10-14 Thread John Woollam
Hi Never heard of the DROUND() function in Universe. Anyway, why would I want to use a function syntax when I can do ANS = N1 * N2 'R2' and it is the answer that gets rounded? Easy to write. Easy to read... John Woollam | Group Function Support 1 (Finance Systems) | Travis Perkins PLC

Re: [U2] Unix to SQLServer

2010-08-13 Thread John Woollam
We have a large SQL server database behind our Business Objects setup. We just export tilde-delimited flat files daily and have SQL Server import them. Dead easy. No learning curve really. No good for your CV, though... John Woollam | Group Function Support 1 (Finance Systems) | Travis

Re: [U2] Writeseq - getting to the EOF

2010-03-25 Thread John Woollam
We have used the SEEK filehandle, 0 2 statement It is literally an exposure of the C seek statement. Yes, it works John Woollam | Group Function Support 1 (Finance Systems) | Travis Perkins PLC | UK -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users

Re: [U2] Comparing two DIMsnsioned arrays

2010-01-22 Thread John Woollam
Nope We use Universe 10.1 at present in REALITY flavour and a trial program with your code does not compile. I recall that you can do MAT ARRAY1 = MAT ARRAY2 as an assignment, but to compare the two arrays you would have to MATBUILD both to dynamic arrays and compare those John Woollam

Re: [U2] UOJ The RPC Failed on Unifile.write()

2010-01-11 Thread John Woollam
If your Unifile is also a SQL Table, and the data you put into 73 is illegal for that table, it will cause a write failure as the SQL checking will not allow you to write it. John Woollam | Group Financial Systems | Travis Perkins PLC | 01604 682751 -Original Message- From: u2-users

Re: [U2] UOJ The RPC Failed on Unifile.write()

2010-01-11 Thread John Woollam
We find that even in a simple, running on Unix, Databasic program, if you try to write illegal data to a SQL table then you get a WRITE FAILURE error, so we guess that the SQL integrity checking is working even on a direct write from any source. John Woollam | Group Financial Systems | Travis

Re: [U2] UniVerse Indexes

2009-11-20 Thread John Woollam
. John Woollam | Group Financial Systems | Travis Perkins PLC | 01604 682751 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Hinnenkamp Sent: 20 November 2009 14:23 To: U2 Users Subject: [U2] UniVerse

Re: [U2] UniObject .NET Session and Common Block Bug

2009-10-08 Thread John Woollam
unnamed common, and include one in one subroutine and both in another, you get the common size mismatch error. In short, put all your unnamed common in one include only and your problems will go away Regards John Woollam | Group Financial Systems | Travis Perkins PLC | 01604 682751