Re: [U2] Web Services at Universe 11.n

2013-10-30 Thread Adrian Halid
ERROR.MSG: :ERROR.MSG VAR = protocolLogging(c:\tmp\ITV-SOAP5.log, OFF,15) Regards Adrian Halid    NOTICE : This e-mail and any attachments are intended for the addressee(s) only and may contain confidential or privileged material. Any unauthorised review, use

[U2] What is the equivalent to UNNEST in Universe

2013-08-20 Thread Adrian Halid
command. Not a Universe SQL command. Regards Adrian Halid ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] What is the equivalent to UNNEST in Universe

2013-08-20 Thread Adrian Halid
Thanks guys. The keyword WHEN was exactly what I was looking for. To pick up only those rows which match. I have always been comfortable using WITH and then performing post processing to figure out the records I needed. Using WHEN will save that time. Regards Adrian Halid -Original

Re: [U2] UniVerse on a Windows Virtual Server

2012-11-21 Thread Adrian Halid
runs at an acceptable level. Measure your processes in a virtual environment and then measure in a non virtual. It is up to you and your customers to what an acceptable level of performance is. Regards Adrian Halid -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread Adrian Halid
key to continue the query. If a client program uses EXPLAIN in a SELECT statement, the statement is not processed. Instead, an SQLSTATE value of IA000 is returned, along with the EXPLAIN message as the message text. Regards Adrian Halid -Original Message- From: u2-users-boun

[U2] How to create Entity Data Model using U2 Toolkit .net

2012-09-21 Thread Adrian Halid
creating an empty model and manually add my entities but am unsure how to link them to a table. I have also tried to connect to a Univese database but unsure on how to connect to the database. Any help please. Regards Adrian Halid ___ U2-Users

Re: [U2] Virtualizing a Universe server of 100+ users

2012-08-21 Thread Adrian Halid
Adrian Halid Senior Analyst/Programmer     ___      NOTICE : This e-mail and any attachments are intended for the addressee(s) only and may contain confidential or privileged material. Any unauthorised review, use

[U2] SQL Select and order by

2012-01-24 Thread Adrian Halid
the ORDER BY statement change my SLIST? Regards Adrian Halid Senior Analyst/Programmer IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153 P:  (08) 9315 7000  F:  (08) 9315 7088 E:  adrian.ha

[U2] Is there any ORM's for Universe. NHibernate, Entity Framework etc

2011-12-20 Thread Adrian Halid
Hi All, Has anybody tried or found an ORM for Universe. I am looking at something along the lines of NHibernate or Entity Framework. Regards Adrian Halid Senior Analyst/Programmer IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning Bridge WA 6153 Level 3, Kirin Centre, 15

Re: [U2] Val on UniDynArray produces unexpected results

2010-11-14 Thread Adrian Halid
of the millions of lines of code in our application and what other conditional statement may not be calculating correctly. This means we are having to do a search and replace to find all instances where we are doing a Val in a conditional statement. Regards Adrian Halid Senior Analyst/Programmer

[U2] Val on UniDynArray produces unexpected results

2010-11-11 Thread Adrian Halid
send out. Regards Adrian Halid Senior Analyst/Programmer IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153 P: (08) 9315 7000 F: (08) 9315 7088 E: adrian.ha...@itvision.com.aumailto:adrian.ha

Re: [U2] EMailing from Universe

2010-09-12 Thread Adrian Halid
thing about this is the same email created in the subroutine can be sent from unix sendmail or the windows sendmail. Regards Adrian Halid Senior Analyst/Programmer   IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road

Re: [U2] TOP/LIMIT Equivalent?

2010-02-21 Thread Adrian Halid
. This would mean you would need to continually re perform your search to update your search list. Plus I thought you would have better performance if you could perform a search an only bring back 100 records instead of 100 each time. Regards Adrian Halid Senior Analyst/Programmer

Re: [U2] TOP/LIMIT Equivalent?

2010-02-18 Thread Adrian Halid
But how would you get the 2nd 100 (101 - 200) and the 3rd 100 (301 to 400) without writing a subroutine to do it? Regards Adrian Halid Senior Analyst/Programmer   IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road

Re: [U2] TOP/LIMIT Equivalent?

2010-02-18 Thread Adrian Halid
records you want to view. Regards Adrian Halid Senior Analyst/Programmer   IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153 P:  (08) 9315 7000  F:  (08) 9315 7088 E:  adrian.ha...@itvision.com.au

[U2] UniVerse Add-ins for Visual Studio

2009-10-21 Thread Adrian Halid
UniData and UniVerse Add-ins for Visual Studio (U2.NET) http://www.rocketsoftware.com/u2/products/u2-net/ Where can I download these addins for Visual Studio 2008/2005? Are they included in the UniVerse Client CD? Regards, Adrian Halid Senior Analyst/Programmer   IT Vision Australia Pty Ltd

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

2009-10-12 Thread Adrian Halid
- Adrian Halid Senior Analyst/Programmer   IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153 P:  (08) 9315 7000  F:  (08) 9315 7088 E:  adrian.ha...@itvision.com.au    W: http

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

2009-10-08 Thread Adrian Halid
execution and control returns to the UniVerse command level. A named common area remains available for as long as the user remains in the UniVerse environment. From what it says I should be able to have them unnamed and loose it between subroutine calls. Regards Adrian Halid Senior Analyst

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

2009-10-08 Thread Adrian Halid
Yeah I tried the Dispose method after the Call but no luck there either. Adrian Halid Senior Analyst/Programmer   IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153 P:  (08) 9315 7000  F:  (08

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

2009-10-08 Thread Adrian Halid
in VB6 and throwing an exception in .NET can be downloaded from http://www.mediafire.com/?sharekey=dfc3c5e4b0702c4d2fb2ca15d7ea42d9e04e75f6e8ebb871 The subroutines have been included as text files. Adrian Halid Senior Analyst/Programmer   IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO

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

2009-10-08 Thread Adrian Halid
commons I want to be sure I understand exactly what it does as it will effect these thousands of Subroutines. Regards Adrian Halid Senior Analyst/Programmer   IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA

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

2009-10-08 Thread Adrian Halid
(); }catch(Exception e){ System.out.println(e.toString()); } System.out.println(End); } } Adrian Halid Senior Analyst/Programmer   IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning Bridge WA 6153

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

2009-10-08 Thread Adrian Halid
No connection pooling. Just the standard session. I am doing the same UniSession and UniSubroutine object setup and creation in .NET, VB6 and Java. It seems in .NET UniObjects doesn't clear unnamed commons between subroutine calls where in VB6 and Java UniObjects it does. Regards Adrian

[U2] UniObject .NET Session and Common Block Bug

2009-10-07 Thread Adrian Halid
(SR.AHTEST.CALL1, 0)     ahsub1.Call       Dim ahsub2 As Object     Set ahsub2 = objSession.Subroutine(SR.AHTEST.CALL2, 0)     ahsub2.Call       MsgBox (Done) Adrian Halid Senior Analyst/Programmer   IT Vision Australia Pty