[U2] UniObjects 'Exec'

We are using a product and just found out that one of the reasons we're having some difficulties on an installation was that one of my dictionaries was not defined at a new site. This caused a 'Exec' of a SELECT to fail, but here's the kicker -- in BASIC, we could have 'seen' the error with

Re: [U2] TOP/LIMIT Equivalent?

Does UV SQL have a rownumber function similar to MS-SQL? http://drsql.spaces.live.com/blog/cns!80677FB08B3162E4!241.entry?wa=wsignin1.0sa=536000658 If so, then use SQL for your query against UV. I Seem to recall this coming up about a year or so ago, and the solution was creating a dict item

Re: [U2] UniObjects 'Exec'

Hi Dave Whenever a call is made to a UOJ subroutine, this will return an error code as part of the object if the subroutine fails for any reason. The developer can then interrogate this error code and take the appropriate actions. HTH Sunny -Original Message- From:

Re: [U2] UniObjects 'Exec'

We've worked around this by having another way to run screens, etc. in a character mode. So if we're having an issue, we run the screen or web page in this special testing mode which doesn't go to uniobjects, but captures everything that would go there and puts it out in a log we can read.

Re: [U2] UniObjects 'Exec'

David The Command object does have a Response property which is like the THIS in your example. But that would have to be logged in some way. Also, if you're running UniVerse, it may create an entry in the errlog .. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] UniObjects 'Exec'

How about this. Rename the VOC entry for SELECT to SYS.SELECT. Write a shell program called SELECT that grabs the @SENTENCE and executes it again using SYS.SELECT. Grab the return values as required and log if necessary. Same would work for LIST, SSELECT, SORT, COUNT etc. Another trick is to

Re: [U2] UniObjects 'Exec'

It's UniData, sadly! This is half the challenge!! They are definitely more UniVerse developers than UniData. However, they tell me that 'Response' does NOT contain the message I would see in THIS -- which would be Illegal Attribute:^am:select criteria THISDICT is not a field.:^am You're saying

Re: [U2] UniObjects 'Exec'

David, I'm running UniData and have no issue tracking down error messages from UniObjects. I have three methods that help. 1. I wrote my own interface so that I would have full control over the data flow. 2. I write information/errors to a log file during execution. 3. I, like Dianne, wrote a

Re: [U2] UniObjects 'Exec'

A try catch around the exec will capture the exception. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: 19 February 2010 14:49 To: 'U2 Users List' Subject: [U2] UniObjects 'Exec' We are using

Re: [U2] UniObjects 'Exec'

I spoke to one of our UO support guys. In general - he confirms that the Response property should contain some error text. I also wanted to point out a UniData 7.2 feature that can help with debugging UO runtime errors with called UniBasic subroutines. (though this is a slightly different

Re: [U2] UniObjects 'Exec'

I did some playing around with this and was surprised at what I found. First I would have assumed that any error messages would have been returned as part of the command.Response But they aren't. So I tried setting up a simple program to execute a command line, capture the output and CRT it.

Re: [U2] TOP/LIMIT Equivalent?

Wouldn't you just SELECT xxx FIRST 100 ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Thursday, February 18, 2010 9:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] TOP/LIMIT

Re: [U2] UniObjects 'Exec'

Wally? This is exactly what I'm hearing from my vendor, and is not what you're being told... Any other suggestions? Or did we just find a UO bug??? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug Sent:

Re: [U2] TOP/LIMIT Equivalent?

Adrian: Here's a dumb little solution that might work for you if you can run a VOC paragraph (I don't know how your interface to the web application is set up). We have Universe. I make use of the standard line editor ED which I think everybody has. In the VOC file create the two paragraphs

Re: [U2] Transferring Data for Development

Hi Andrew, I'm a former developer at Eclipse were I worked with data conversions. We ran into the issue of moving files between systems on a number of occasions. One method we used was to T.DUMP the files on one system and T.LOAD them on another. However I don't think we ever tried moving

Re: [U2] Error connecting to Universe using Web Service Developer Tool

Jason Lin tempest at ucla.edu writes: Bill, I don't know if connection pooling license is the issue here. We are running Unvierse 10.1.2 and the client tool is version 10.3 so there may be some compatibility issue. Nevertheless, Uniobject.net works so I will have to use that for now.