RE: [U2] Newest UV UniDebugger

2006-04-07 Thread Brian Leach
Just to add: If you have entries for defcs and udcs, change those as well. Later revisions will also allow you to specify zero for no timeout. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan > Sent: 06 April 2006 22:10 > To: '

RE: [U2] [UD] Executing save-list

2006-03-31 Thread Brian Leach
Jack RTNLIST works but it creates a select list variable not a regular dynamic array. This means you can use it to segregate list processing as below: Execute "SSELECT VOC" RTNLIST SLIST CAPTURING OUT Crt "OUT= ":OUT Fin = @False Loop ReadNext Id From SLIST Else Fin = @True Until Fin Do Crt

RE: [U2] FILE RESIZE

2006-03-29 Thread Brian Leach
David, Kevin is right (as always) - but you didn't say whether you are running UD or UV. On UV the equivalent is to use uvfixfile to verify the structure. uvfixfile also has a fix option, but make sure you take a backup of the file (at the OS level) before you try it, in case it goes horribly wro

RE: [U2] [UV] Resize error

2006-03-10 Thread Brian Leach
You might want to try "handle" from www.sysinternals.com. They do a whole range of excellent free tools for system monitoring. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jeff > Fitzgerald > Sent: 09 March 2006 17:36 > To: 'U2-users (E

RE: [U2] Universe Scalability

2006-03-03 Thread Brian Leach
Anmol, The 'small to medium' is more about market positioning than technical limitations. Small to Medium implies a number of positives, such as the low administration overheads, low cost of ownership, ability to run on limited resources etc. IBM recently benchmarked a UniVerse database at 15,00

RE: [U2] Steve Cashman

2006-02-27 Thread Brian Leach
Larry, Thanks. Steve is in hospital - I'm trying to get hold of his assistant to get this sorted. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Larry Hiscock > Sent: 25 February 2006 20:25 > To: u2-users@listserver.u2ug.org > Subject: R

RE: [U2] Returned parameter from a Uniobject VB.Net Subroutine

2006-02-17 Thread Brian Leach
et > Subroutine > > Thanks but this produces the following error: > Too many arguments in 'Public Sub New()' > --- Brian Leach <[EMAIL PROTECTED]> wrote: > > > Try using the constructor: > > > > HdrArray = New UniDynArray(objOnHand.GetArg(1)) > &

RE: [U2] Returned parameter from a Uniobject VB.Net Subroutine

2006-02-16 Thread Brian Leach
Try using the constructor: HdrArray = New UniDynArray(objOnHand.GetArg(1)) Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of John > Castilletti > Sent: 16 February 2006 14:38 > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Returned pa

RE: [U2] UV 10.1.11 Windows 2003 server SP2

2006-02-16 Thread Brian Leach
If you mean the errlog file this can be created in the uv home directory, but is not created by default. Just go to the uv account, ED &UFD& errlog and file as an empty record. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Anthony Caufi

RE: [U2] Universe users under Win2003

2006-02-16 Thread Brian Leach
Jeff, In addition: If the user is a domain user: 1. ensure they have the Log on Locally permission. 2. Use the UniAdmin Network Services to decide how the UniVerse telnet will assign their home directory. If the user is a local user: Ensure their home directory or login script takes them int

RE: [U2] CAll Stack

2006-02-07 Thread Brian Leach
Whilst we're on the subject, has anyone compiled a list of these 'undocumented' system() values? Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of James Cowell > Sent: 07 February 2006 11:48 > To: u2-users@listserver.u2ug.org > Subject: RE: [U

RE: [U2] Simple OT question

2006-02-06 Thread Brian Leach
Or what we refer to in the UK as a 'kettle lead' Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Michael Doyle > Sent: 06 February 2006 19:30 > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Simple OT question > > Evidently, it's a C-

RE: [U2] [UD] Best practices

2006-01-29 Thread Brian Leach
PROTECTED] On Behalf Of > Louie Bergsagel > Sent: 29 January 2006 17:33 > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] [UD] Best practices > > Good idea, but is there any performance penalty to using > I-types like that? > > -- Louie > > > On 1/29/06

RE: [U2] [UD] Best practices

2006-01-29 Thread Brian Leach
I would second all the points about maintainability and legibility being key. One additional thing I have seen on one site: Unlike the A/S type dictionaries, there is no standard way of separating base and synonym dictionaries using D types, which can lead to dictionary listing that takes forever

RE: [U2] U2UG board activity: [U2] Knowledgebase access

2006-01-29 Thread Brian Leach
All, Well there is a simple answer: Contribute to our (U2UG) knowledge base! That's how the open source community thrives - by people contributing. There is so much knowledge locked up in this list - so spread some of that around. I'm even willing to write the final versions if people will sen

RE: [U2] Knowledgebase access

2006-01-26 Thread Brian Leach
Phil, This is something for which the U2UG have been actively campaigning. That campaign is beginning to bear fruit: 1. There are now a number of articles on the techconnect that are available 'outside' the knowledge base (e.g.the excellent article by Mark Baldridge publicised on the list earlier

RE: [U2] Difference between IBM Universe and IBM UniData

2006-01-20 Thread Brian Leach
And Kevin, You are too modest. Your replies are never drivel. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King > Sent: 20 January 2006 14:17 > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Difference between IBM Universe an

RE: [U2] Difference between IBM Universe and IBM UniData

2006-01-20 Thread Brian Leach
Kevin, Well, many of the commands ARE the same and they are both horrible old line editors that should have been put out to pasture years ago... Personally like many people I use my own editor - with full cursor control, syntax highlighting, build commands Oh and I'm just doing some work on

RE: [U2] Moving Data between input buffers

2006-01-20 Thread Brian Leach
Doug Does UniData PROC support file buffers (&n.m format)? I've never used PROC on UniData, but that is traditionally the place to stuff things 'for future reference', e.g. MV &1.0 %1 Only if the PROC implementation supports PQN format though. Brian > -Original Message- > From: [EMAIL

RE: [U2] Difference between IBM Universe and IBM UniData

2006-01-20 Thread Brian Leach
Pankaj That's a huge subject. The fundamental database handling is broadly the same, based on the same original model. You will find yourself at home there. Most of the differences are on the periphery and to do with emulations. You will find the same thing whenever you change platform: those use

RE: [U2] Unidata on XP Lap Top

2006-01-19 Thread Brian Leach
Tony, The point I'm making is that: A) I have both VS2005 and VB Express loaded and find I'm finding that I'm far more productive using the latter for most work. Mind you, I also have Delphi for more "serious" stuff B) VB Express is highly capable as a free development tool for U2. For which th

RE: [U2] Unidata on XP Lap Top

2006-01-18 Thread Brian Leach
Larry, VB 2005 Express Edition is free - not evaluation. It is also very powerful (all the .Net 2 features) and frankly a lot nicer to use than the full blown Visual Studio 2005 which is ludicrously machine consumptive. I now use it in preference and haven't found anything I need to go back to t

[U2] RE System Migration Issues

2006-01-12 Thread Brian Leach
Steve Assuming UniVerse, uvbackup and uvrestore is safest: it is item level and will create new files on the target. Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] PROC Question

2006-01-11 Thread Brian Leach
The only sensible ways are: 1. Subroutines GOSUB n n MV #1 "blah" P .. RSUB 2. Ext subroutines C has commands [file someproc] 3. Execute something sensible like a paragraph and give up using ugly PROCs Brian "Like PROC - ugly but works" -Original Message- From: "Bob Woodward"<[

RE: [U2] DATE conversion problem

2006-01-09 Thread Brian Leach
You need to issue the server command: DATE.FORMAT This would normally be done by the UV.LOGIN paragraph in the UV account or by the LOGIN in the account, but UniObjects bypasses both of these. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf O

RE: [U2] OT - Launching DOS executables from Universe 10.0.10 on Win 2000

2006-01-09 Thread Brian Leach
Just as an off-topic side point: don't forget the oft-overlooked Windows Scripting Host. This is a very powerful beast built into all versions of windows, running VBScript and JScript (and any other scripting engines installed): very much more powerful and legible than BAT files and capable of han

RE: [U2] [UV] Create hashed file in subdirectory?

2006-01-06 Thread Brian Leach
Jacques, Does it work correctly if you specify commas between e.g. CREATE.FILE TEMP.JAG,WORK.JJ 16,17,1 18,101,1 ? It could be flavor dependent. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jacques G. > Sent: 06 January 2006 19:53 > To

RE: [U2] [UD] OSBWRITE problem

2006-01-06 Thread Brian Leach
> You can try "NOCONVERT ON" to see if that fixes your problem. > > Hth > Colin Alfke > Calgary, Canada > > >-Original Message- > >From: Brian Leach > > > >All, > > > >I'm having a problem writing a binary file fr

RE: [U2] Converting numeral to word

2006-01-05 Thread Brian Leach
utine. Brian SUBROUTINE NumberToWords(NumberIn, FormatOptions, NumberAsText) *-- * Name: NumberToWords * Description : Convert number to text * Author : Brian Leach * Project : GENERAL * Module

[U2] [UD] OSBWRITE problem

2006-01-05 Thread Brian Leach
All, I'm having a problem writing a binary file from UniData. I need to store some lengths as 4 byte integers, and I'm deliberately encoding all numbers to base 250 + 1 shifted to avoid writing char(0) or char(255)s but I'm still getting a problem with byte translation. I've narrowed it dow

RE: [U2] openseq question

2006-01-04 Thread Brian Leach
Jeff, AFAIR OpenSeq on UniData looks for either a path name, or if you specify an item id it looks for an item in a directory file (not a path). So you would need to either A) OPENSEQ "/tmp/" : MTR.REC TO F.MTR.ROW.FILE ... Or B) create a file pointer to /tmp (e.g. named TMP) and then OPENS

RE: [U2] Running Uniobjects from a web server

2005-12-23 Thread Brian Leach
You can use UniObjects but remember that UniObjects represents a single stateful login session (like a terminal) and web servers both stateless and scalable. Which means that: A) you cannot persist state at the server. So anything like common blocks and record locking probably go out the window.

RE: [U2] uniXML question on uonet7.1

2005-12-22 Thread Brian Leach
Have you tried the element syntax LIST file TOXML ELEMENTS That may parse better.. But I'm in a coffee shop with no udt to hand. Brian -Original Message- From: "Victor St Clair"<[EMAIL PROTECTED]> Sent: 22/12/05 01:29:50 To: "u2-users@listserver.u2ug.org" Subject: [U2]

RE: [U2] just because its nearly christmas

2005-12-21 Thread Brian Leach
Ok if people are going to reply ... (I *was* holding myself back, okay) .NET: In week 1 you find the System.ballistics.nonpointy.shooters.guns.gun.gunparts.moving.greasy.casing. trigger interface. In week 2, you discover the required System.ballistics.nonpointy.shooters.guns.gun.ammo.bullets.t

RE: [U2] jBASE : PRINT FMT('6.71509648127128E-02', 'R9') error

2005-12-21 Thread Brian Leach
Chuck, You were right first time. Must be the hour. Number = "1.234567E+14" Base = Number["E",1,1] Factor = Number["E",2,1] Multiplier = "1" : Str("0", Factor) If Factor < 0 Then Result = Base / Multiplier End Else Result = Base * Multiplier End Crt Result Should give: 1234567 Br

Re: [U2] Using Esc

2005-12-20 Thread Brian Leach
Mark, AFAIR UV does provide cursor driven input - see the Input @, KeyEdit and KeyTrap statements. It is however pretty horrible. You can't blame the vendors for this one though. The problem has been the mindset of a community that hasn't shared code (how many virtually identical menu runners

[U2] MV Design

2005-12-14 Thread Brian Leach
All I'm intending to put a series of articles together on Designing MultiValue solutions, starting from first principles and emphasizing best practice. These will be published in the knowledge base. Since this is a contentious subject, rather than impose my thoughts :) I would like to invite co

RE: [U2] pgsql and unidata basic

2005-12-14 Thread Brian Leach
Jeff Is postgres on the same box as udt? Brian -Original Message- From: "Jeff Powell"<[EMAIL PROTECTED]> Sent: 14/12/05 14:01:58 To: "u2 users group" Subject: [U2] pgsql and unidata basic Is there a way to execute queries to a postgresql database from within a

RE: [U2] SOX question (United States only, I believe)

2005-12-09 Thread Brian Leach
Is it sufficient to formally separate the roles and procedures, even if they are carried out by the same person? and just think, you could put in for two pay rises :) Brian "SOX-Free here" > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Lance Jahn

RE: [U2] Deciphering Pick UniBasic statement

2005-12-09 Thread Brian Leach
Caleb, Just to point out - as a newbie don't think all MV coding is like this! It's this sort of rubbish that gives our industry a bad name. (Mind you I've seen worse C++ code...) :) Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Caleb N

RE: [U2] FW: Uonet Timeout

2005-12-09 Thread Brian Leach
Bob You need to update the unirpcservices file to have a sensible timeout value for the server. This can time out without notifying the client in a manner that can be easily trapped. Look for the lines headed udcs and defcs and change the final column. Note that the values are in 1/10th seconds

Re: [U2] [UV] - word Document

2005-12-06 Thread Brian Leach
Andy, Sorry to disagree but M$ do generally provide excellent documentation through MSDN - something I wish certain other vendors would copy. As for RTF - it is ugly but it is a published standard. And M$ have announced support for the OpenDoc formats in the new Office. Brian -Original Me

RE: [U2] Re:UV XMLDB Tool

2005-12-06 Thread Brian Leach
Jonathan Thanks Brian -Original Message- From: "Jonathan D Smith"<[EMAIL PROTECTED]> Sent: 06/12/05 09:14:14 To: "u2-users@listserver.u2ug.org" Subject: [U2] Re:UV XMLDB Tool Hi All, We are already aware of the problem with Pick Flavour Accounts and the

RE: [U2] UV XMLDB Tool

2005-12-05 Thread Brian Leach
AIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach > Sent: 05 December 2005 11:15 > To: u2-users@listserver.u2ug.org > Subject: [U2] UV XMLDB Tool > > Hi, > > Does anyone know what determines whether an account appears > in the UniVerse XMLDB tool? I

[U2] UV XMLDB Tool

2005-12-05 Thread Brian Leach
Hi, Does anyone know what determines whether an account appears in the UniVerse XMLDB tool? I have an account that just doesn't want to show up in the list. For the record, it has an entry in the UV.ACCOUNT file. It has been enabled for ODBC. I also created a uci entry for it on the client in cas

[U2] U2UG Knowledge Base

2005-11-28 Thread Brian Leach
a U2 solution :-) Any articles and feedback submitted to the prototype site may (if the author wishes) be considered for the live site. Let us know what you think. Brian Leach, U2UG Board --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] 20 Digit Number

2005-11-21 Thread Brian Leach
Mark, How are these numbers originated? It is rare for such complex numbers to be produced entirely randomly. How are you being supplied with the numbers to use for testing? Are they being printed out for you? If so, from where - and could they be transmitted or OCR'ed? More background please...

RE: [U2] Unidata's .Net UniDynArray

2005-11-11 Thread Brian Leach
Like other posters I use my own functions to handle dynamic array operations. I wonder whether the server access however may be down to NLS support on UniVerse where you can redefine the delimiters. Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http

RE: [U2] UniOleDB - Delphi

2005-10-14 Thread Brian Leach
Claus, If you have set up your config file correctly (looks ok, did you use the horrible UCI Config editor to make sure it is saved in the right place ?) your connection string should just read: "Provider=IBM.UniOLEDB.1;Persist Security Info=False;Data Source=TESTFAMIS;Password={your_password_her

RE: [U2] Printer problems on UV PE under Windows XP

2005-10-14 Thread Brian Leach
Eric, A couple more points: 1. You can specify a share name to SETPTR so long as the printer has been locally added to the system. The share name cannot contain spaces. 2. SOME printers will work if you use a generic/text only driver and install them locally, however ... 3. You may need to spec

RE: [U2] Universe running on Linux/SuSE

2005-10-14 Thread Brian Leach
Rob, As a comment, at my last company all our development was (and as far as I am aware still is) done using UniVerse on Linux. This was a combination we used for over 10 years. Stable certainly. Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http:/

RE: [U2][UV] Date conversion question

2005-10-12 Thread Brian Leach
Nick D-YMD[4,2,2] Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Nick > Cipollina > Sent: 12 October 2005 13:30 > To: u2-users@listserver.u2ug.org > Subject: [U2][UV] Date conversion question > > If I want to convert a date to the follow

RE: [U2] Printer problems on UV PE under Windows XP

2005-10-10 Thread Brian Leach
Eric, Can we start from the top: 1. Is this a local printer or a share e.g. \\machine\printer ? 2. If remote, is it installed under Windows? If so, does your UniVerse user have privilege to access it? 3. Does the printer show up if you do a SPOOL -LIST ? Is there an error code reported when you d

RE: [U2] Good Programming Practice Question.........

2005-09-30 Thread Brian Leach
Susan, You make a good point, but the problem with that approach is that it stifles innovation and learning - though not in your case, of course :-) I have known programmers who took a 'lowest common demoninator' approach that was based on systems that were obsolete 20+ years ago, ignoring usefu

RE: [U2] Source Code Management

2005-09-30 Thread Brian Leach
Karen I originally used to use RCS under UniVerse with some simple verbs that committed items in and out of a work directory using an index file to map account|file|item paths to work file keys. This meant that I could easily manage items from hashed files (eg dictionaries) using some simple RCSPU

RE: [U2] Good Programming Practice Question.........

2005-09-27 Thread Brian Leach
Kevin, I disagree, for a simple reason: I use alpha labels that make sense and then place them in the code in alphabetical order. Problem solved . Just a few off the top of my head (it's late here): 1. If using UniVerse, use mixed case to encourage readability when scanning through a program wi

RE: [U2] UV User Name

2005-09-22 Thread Brian Leach
Rudy, If you want the user names reported consistently, there is a registry setting to ignore the domain prefix (particularly useful for migrating sites from UNIX). Start Regedt32, navigate to: HKEY_LOCAL_MACHINE\SOFTWARE\IBM\UniVerse\CurrentVersion and add a new DWORD key: UseShortUserNames 0x

RE: [U2] ICONV of Date - Strange result

2005-09-22 Thread Brian Leach
> I may have missed something but maybe an empty string value > is accurate for the year . > > The way we are treating our planet whose to says there will > be any computing going on anyway. But, but... Isn't that when Windows Longhorn is finally scheduled for release? Brian ---

RE: [U2] ICONV of Date - Strange result

2005-09-22 Thread Brian Leach
Hi, Check whether either account issue the DATE.FORMAT command in its LOGIN or equivalent paragraph. This toggles from US format dates (12-31-) to european format (31-12-) Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Ang Suan Yo

RE: [U2] PHP Options

2005-09-19 Thread Brian Leach
Dawn, You can also use RedBack: PHP can instantiate COM objects on Windows platforms, and has a java interface so it can create java redback objects (RedObjects). I guess these would also allow UO and UOJ, but then you're back to the old web access/connection pooling issues. There is a paper avai

RE: [U2] UV Funny

2005-09-15 Thread Brian Leach
Look in the uv account at BP ED.B. Around line 270 it has: * E2835 UPCASE if casing is insensitive IF ECFLAG THEN SENT = UPCASE(SENT) It is one of a number of bugs regarding sentence casing I've found.. Try using the DELETE command on an item in a lower case file name. Brian > -Or

RE: [U2] Unusual problem w/Dynamic Connect 'speed'

2005-09-14 Thread Brian Leach
On the plus side, given current hardware costs a decent twin Xeon server probably costs about the same as that old terminal beastie ... Brian > Oh for the glory days of a simple terminal for every user... > (just kidding, for me I want a quad processor Opteron machine > with lots of > memory!

RE: [U2] Limiting MV's in a list statement

2005-08-10 Thread Brian Leach
Bob, You need to use the WHEN connective in your LIST statement. WITH connectives (LIST file WITH expression) will select any record in which ANY value matches the criteria and return the entire set of values. This makes sense for most cases, e.g. I want to match an address without knowing which

RE: [U2] Trigger creation

2005-08-01 Thread Brian Leach
Tom Yes you can. For the complete syntax, type HELP SQL CREATE TRIGGER at TCL. This gives the argument list for the trigger subroutine. I seem to recall that if you are going to access the file from various accounts, the trigger subroutine needs to be globally cataloged. Brian > -Origi

RE: [U2] UVSH from another machine

2005-08-01 Thread Brian Leach
Andy If I understand this right, you are trying to end up running a uvsh executable on one machine on a UniVerse account on another machine. Bad idea: no least because of the locking issues. You might be better off to write a small VB Script to instantiate a UniObjects connection to the remote ma

RE: [U2] Bad Address for Breakpoint in Debugger

2005-07-28 Thread Brian Leach
Any include files that would confuse the debuggers line numbering? Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: 28 July 2005 16:21 > To: u2-Users > Subject: [U2] Bad Address for Breakpoint in Debugger > > Hi

RE: [U2] Open Excel and Import a file or execute a command from a local PC

2005-07-28 Thread Brian Leach
Ralph, 1. There are some reporting tools that will do this: mvQuery for one. 2. If you are using UniVerse 10, you can generate XML out of RetrieVe and SQL. Take a look at the TOXML ATTRIBUTES syntax. This goes to screen, but you can divert this to file using a paragraph to do a DIVERT.OUT ON filen

RE: [U2] Win2003 Serial Printers

2005-07-27 Thread Brian Leach
Thanks for all the responses, I'll pass these on to the client. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach > Sent: 27 July 2005 14:21 > To: u2-users@listserver.u2ug.org > Subject: [U2] Win2003 S

RE: [U2] UVODBC procedure call from VBScript

2005-07-27 Thread Brian Leach
Ok, Try the following. This works for me, all other routes seem to fall over :-( - Use a "?" to substitute for each subroutine argument - Create an ADODB parameter for each argument - Set the value of the ADODB parameter - Append that parameter to the command Parameters collection NOTE: Using th

RE: [U2] UVODBC procedure call from VBScript

2005-07-27 Thread Brian Leach
Dave: AFAIR this is documented in the less-than-obvious location of the UCI Guide. Here is a quick example using local UniVerse SQL in a subroutine as a stored procedure. I've used this with OleDB though not with ODBC, using the SQL CALL statement. NOTE that if you are using ODBC, I've found th

[U2] Win2003 Serial Printers

2005-07-27 Thread Brian Leach
All, One of my UniVerse clients is changing over from UNIX to Windows. They currently have a number of serial printers attached to their UNIX box using Xylogic Annex terminal servers. Since these are as old as the hills and not supported on Win2003, can anyone recommend a suitable replacement?

RE: [U2] DATABASE write problem

2005-07-20 Thread Brian Leach
Anmol, Are both of the processes UniVerse processes, or is one of them an external process (script, executable etc.)? If the latter, some contention at the OS level is probably inevitable, with the other (non-UV) process having the file open. Whenever I have had that combination, I always use a L

RE: [U2] dll File (u2libeay32.dll)

2005-07-19 Thread Brian Leach
Bjorn, A quick look with Dependency Walker shows it is exporting a set of functions for SSL, RSA encryption and certificate (X509) services. So I guess it is part of the UniVerse SSL support. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of

RE: [U2] AUTOLOGOUT

2005-07-14 Thread Brian Leach
Andy, How do you start their uv processes? If you are starting the uv process from e.g. a .profile or .login script, remember that you need to 'exec' uv to overlay the current process or it will create a subprocess to run UniVerse. In which case, the autologout will simply be returning them to th

RE: [U2] [UV] Select Question

2005-07-14 Thread Brian Leach
The first syntax is used to ensure isolation of select lists. It is a good practice to get into, in case someone later on modifies the code processing whatever you are handling in your selection, especially if that processing involves calling an external subroutine. Personally I prefer to use sele

RE: [U2] THE variable names

2005-07-13 Thread Brian Leach
> The oldest "universe" manual I have is dated from Spring1983 and is Yeah yeah, SOMEBODY had to go look ... Can we throw the inevitable "my manuals are older/wiser/more dog-eared/obsolete than yours" discussions over to the community list? Brian "Walking on hind legs? That'll never catch o

RE: [U2] Voc pointer not working (fwd)

2005-07-11 Thread Brian Leach
> Marilyn Hilb wrote: > >The trigger here seems to be files that have I_ folders on them, > >Index Map?. As Karl stated, the index file location is hard coded into the file header. You can amend this using the SET.INDEX command. This can either reset the index path to the local location OR cl

RE: [U2] Transferring UniVerse accounts from Windows to UNIX

2005-07-09 Thread Brian Leach
Paul, 1. Work out whether you are A. using global or reality style cataloging anywhere. B. intend to recompile/recatalog all your programs on the target platform. If A) make a mental note to safe off the catdir directory under the uv directory. If B) make sure you know which files to compile/

RE: [U2] spool images going to word documents

2005-07-04 Thread Brian Leach
Bob, Insert between each line. Brian > > I suspect that I need to pass a line feed of some sort into > word but the usual char(10) and char(13) do not do the trick > > Has anyone seen this before and found a fix ? > > Many thanks > > Bob --- u2-users mailing list u2-users@listserver.u2

RE: [U2] Re: U2 Users Digest V1 #718

2005-07-01 Thread Brian Leach
I have found Virtual PC to be one of the most useful > offerings to have come out from Microsoft. And another thing they bought rather than developed. I remember I was trying to get the go ahead to pay to upgrade our versions, when MS bought it and added it to the MSDN subscription. So thanks the

RE: [U2] Field Count from a Seq File

2005-06-21 Thread Brian Leach
James, Without knowing why you don't want to loop through it, these may or may not be helpful: 1. OpenSeq the file, get the size of it from a Status statement and ReadBlk the entire file in one go, depending on size of course. Then you can DCount. 2. Ditto, but loop through - not a line at a ti

RE: [U2] OCONV of no affect.

2005-06-20 Thread Brian Leach
> BTW, why did microsoft assign (-1) as true. I don't think (1) > works as true and, while being 'not zero', is hard to use > mathematically. Binary. As an UNSIGNED integer, -1 is all 1s. And you're right, for most windows languages -1 is true, 1 is false. Brian PS it's not just Microsoft eit

RE: [U2] Use of FAST utility in Universe

2005-06-20 Thread Brian Leach
Shuchi Type 1 and 19 files are operating system directories. How are they damaged? Missing .Type1 entry? File names stored without mangling? These may need to be repaired at the OS level. Which OS are you using? Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROT

RE: [U2] [UV] Disable UniObjects Access

2005-06-20 Thread Brian Leach
> Does anyone know what the various services listed correspond to? uvcs - UniObjects (UniVerse) udcs - UniObjects (UniData) defcs - UniObjects default if the database type is not specified in your connection details. Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe

RE: [U2] How to release locks (LIST.READU)

2005-06-15 Thread Brian Leach
Hi, The LIST.LOCKS command lists tasks synchronization locks. The LIST.READU command lists record and group locks. To release record and group locks you need the UNLOCK command. This is (normally) only available in the uv account, and has various options for unlocking different sets of locks,e.g.

RE: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/RO...

2005-06-14 Thread Brian Leach
> -Original Message- > Subject: RE: [U2] Best practice for Sequential IDs using > TRANSACTION START & COMMIT/RO... > > Come on, people. A request was made for options... Okay so here goes: Write a service application (e.g. Windows service app) in Delphi that maintains a table of sequen

RE: [U2] [UV] Help with @RECORD

2005-06-14 Thread Brian Leach
Barry, @Record is primarily designed for interfacing with the query processor. As each record is processed, the id is written to @ID and the record body to @RECORD. You can then use these directly in I Descriptors when accessing specific functionality: E.g. MyPartKey 1> I Get the first two parts

RE: [U2] Source code question

2005-06-06 Thread Brian Leach
>Someone already mentioned the issue of TIME() which also > impacts things > like SLEEP and RQM and NAP. This is tuneable in the UniVerse config. As long as you stick to working in whole seconds - which always used to be the default - this should be fine. >I'd also wonder about port-spe

RE: [U2] Uniobjects hack

2005-05-27 Thread Brian Leach
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson > Sent: 27 May 2005 14:09 > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Uniobjects hack > > How about using file level security, and common area in your > subroutines. If yo

RE: [U2] Uniobjects hack

2005-05-26 Thread Brian Leach
> Just because this is a wider problem doesn't mean that UO > shouldn't be called on it. So how would you go about it? UO is a tool for developers. As such, it's strength is that it is able to do anything a developer needs it to do. It is clean client/server middleware and so it can't launch a

RE: [U2] UV PE for Windows

2005-05-24 Thread Brian Leach
Mary, If you log into UV PE on Windows as an Administrator user, it will ask you for the directory to which to connect. If you specify a directory that is not yet a UniVerse account, it will further prompt you to set it up. Much quicker than using UniAdmin. Regards, Brian > -Original Messa

RE: [U2] Include Vs Call - Software Maintenance

2005-05-19 Thread Brian Leach
One nice advantage of functions, is that they must fit the DEFFUN. Which means that the compiler can check typos and that the correct number of arguments are supplied - unlike a CALL which is only resolved at run time. If you have finger trouble, that can add a little more certainty Brian -

RE: [U2] Dymanic vs Dimensioned

2005-05-18 Thread Brian Leach
Oh dear, I feel the flood gates opening... Please resist. Brian "Binary? Luxury. We couldn't afford ones AND zeros." > Gyle, > > 64KB? ROTFLMAO! The first Microdata machine I worked on had > 16KB, and ran a medical billing service bureau. It had 1 > 50MB disk drive and ran as slow as mo

RE: [U2] Questions about addRequestParameter

2005-05-17 Thread Brian Leach
Bruce, Am I right in thinking that you are consuming a web service here? You say the response is in XML. If so, check out whether your version of UniData supports the newer SOAP calling (SOAPCreateRequest etc) routines (I only have UniVerse here so I can't check). These might be more simple/appro

RE: [U2] I'm in an Array quandry, any suggestions...

2005-05-12 Thread Brian Leach
George, It really matters what flavor you're running. If you run a flavor that puts the overspill in element zero, you may be ok. If you run a flavor that puts the overspill into the last element, that might mess up any accesses to that element in the existing code. Brian > -Original Messa

RE: [U2] Validating an email adress

2005-05-03 Thread Brian Leach
Claus, Since the MATCH operator handles alphas OR numerics and not both, this is the closest I can get using a pattern match: GoodEmail = ( Convert("_.1234567890","",Email) Matches "1A0A'@'1A0A") Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On B

RE: [U2] Unidata Permissions

2005-05-02 Thread Brian Leach
John, You cannot really restrict access to individual fields within a file other than at the dictionary (enquiry) level. What you can do, is to: create a new account create local dictionary files in that account (using the same names as the live files you need) copy the live dictionary entrie

RE: [U2] uvo.net

2005-04-27 Thread Brian Leach
George, You just use a command with a selectlist, sort of as you would at TCL. The UniSession CreateUniSelectList provides access to the regular numbered select lists. For example, assuming Sess is a UniSession: Dim ACmd As UniCommand Dim ASelect As UniSelectList Dim T As String

RE: [U2] ODBC text field

2005-04-27 Thread Brian Leach
Graham I'm assuming that you mean to return the multivalued field as a single valued text field. If your are on UniVerse (you don't say) try the following ITYPE expression: CONVERT(@VM:@SVM," ", OCONV(@RECORD,"MCP")) Where 'n' is the field number of the field to return. Also make sure field

RE: [U2] uvo.net

2005-04-27 Thread Brian Leach
Seems to work... Mind you I still recommend writing code in subroutines first and then calling it, rather than using the other objects, other than for smaller uses. It is so much easier to QA as you can test the routines on the server first, write test scripts and see any error messages produced..

<    3   4   5   6   7   8   9   10   >