RE: [U2] PDF printing, LaTeX, Ghostscript, etc. - [OT]

2009-01-28 Thread Brian Leach
Arnold Yes, I've been impressed with FPC generally, though it depends what type of project you are trying to migrate! For straight-forward VCL forms apps it seems like a reasonable tool. However I would have to say that whilst Lazarus has come a long way, it still lags well behind other IDEs, even

RE: [U2] Moving a UniVerse a/c from Unix to Windows

2009-01-28 Thread Brian Leach
Hi Jeff The 'magic bullet' is usually to resize all your type 1 files to type 19 before trying the migration. Regular file names (not directory) will be truncated using a sequence number but that's not an issue - they will go across correctly. Type 1 files won't. Any SQL tables will also cause pro

RE: [U2] PDF printing, LaTeX, Ghostscript, etc.

2009-01-28 Thread Brian Leach
Glen >Doesn't using PrintWizard imply the use of a Windows server somewhere? That's the way of the world. If you want a quick-and-dirty stick-some-text-into-a-doc type of PDF you can get away with cross platform solutions, but for a 'real' PDF solution - one with good font handling, images, g

RE: [U2] File Delete Logging UV

2008-12-30 Thread Brian Leach
Mac You can't delete your own VOC file using DELETE.FILE so if it is being done from UniVerse that means it is happening from another account. So you could a) look through other accounts and see if there is a suspicious Q or F pointer to that VOC which might help track down the culprit, or b) wrap

RE: [U2] DEBUG mode on a UniObjects connections

2008-12-05 Thread Brian Leach
ve two separate windows open, one populated with the client log, and the other populated with the server side log. How do I get hold of Spectrum? Thanks, Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: 05 December 2008 08:

Re: [U2] DEBUG mode on a UniObjects connections

2008-12-05 Thread Brian Leach
These are all good approaches, but the difficulty is often in trying to collate the information on what is happening client side and server side: that usually means poring through multiple log files, especially if you use different client languages as we did in my last company. Our approach wa

[U2] UniData ODBC and Vista

2008-12-04 Thread Brian Leach
Hi All Does anyone know whether the latest ODBC drivers for UniData will work under Vista? Thanks Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] DEBUG mode on a UniObjects connections

2008-12-04 Thread Brian Leach
Hi Dave A uniObjects subroutine call is a 'black box' RPC. It doesn't allow any kind of user interaction to interrupt the call. If you're going into debug, that will hang because it has nowhere from which to take input. Sorry, but that's how it is designed. Brian Hi all, I'm new to the list,

RE: [U2] biztalk adapter

2008-12-02 Thread Brian Leach
Bob It's on the UniVerse client CD as part of the UniDK package. There's no extra cost for UniObjects per se, but you might need to think in terms of some pooled connection licenses if you're processing messages in parallel. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mail

RE: [U2] Printing Graphics from UniVerse

2008-12-01 Thread Brian Leach
Hi Adam Take a look at mvpdf - it offers a range of ways to create documents, has a drawing API and despite the name also supports drect printing. Eval available on www.brianleach.co.uk Regards Brian -Original Message- From: Adam Taylor <[EMAIL PROTECTED]> Sent: 01 December 2008 21:50

RE: [U2] Counting records

2008-11-19 Thread Brian Leach
Nothing built in, but here is a simple function to do it: FUNCTION CountFile(FileName) $INCLUDE UNIVERSE.INCLUDE ODBC.H SQL = 'SELECT COUNT(*) FROM ':FileName Counter = 0 Ok = SQLExecDirect(@HSTMT,SQL) Ok = SQLBindCol(@HSTMT, 1, SQL.B.DEFAULT, Counter) Ok = SQLFetch(@HSTMT) Ok = SQLFreeStmt(@HSTM

RE: [U2][UV] Performance Improvement Hpux 11.23 & 11.31 (Itianium)

2008-11-14 Thread Brian Leach
Stewart Thanks for posting this. Very useful information. Regards Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Mitchell, Stewart > Sent: 13 November 2008 23:50 > To: u2-users@listserver.u2ug.org > Subject: [U2][UV] Performance Improv

RE: [U2] Create file on remote account

2008-11-12 Thread Brian Leach
Hi You can call out to the underlying $UVHOME/bin/mkdbfile. This creates the physical file in any location you like, then you need to create or update the VOC pointer yourself. Create a verb pointer to mkdbfile, and you can do the rest in a simple program. Syntax to mkdbfile is: mkdbfile path

RE: [U2] Documentation

2008-10-30 Thread Brian Leach
Hi Do you mean the SQLExec... functions? If so, they are defined in the BCI (Basic Calling Interface) Guide. Brian Can anyone point me in the right direction. I am looking for documentation on a Universe command "Execute.SQL" and what I need it the potential return code and the descriptions.

RE: [U2] [UV] PHP

2008-10-24 Thread Brian Leach
Hi The PDO driver looked a good start, but it may be too limited as it currently stands. It also depends on how you are hosting the PHP: most external provides won't let you load custom modules like this one. I did ask IBM last year whether they would be willing to publish the UniObjects protocol

RE: [U2] Universe Triggers

2008-10-10 Thread Brian Leach
Hi Bill That's pretty much what I do, except each file has a list of small subtriggers. That way, if we need to add another action (e.g. another secondary update) or to temporarily suspend an action, they can be added into or knocked out of the list. The overhead is on calling the master trigger

RE: [U2][UV] EQUATEs Using System Delmiiters

2008-10-08 Thread Brian Leach
Martin/Perry Thanks, nice to learn it's smarter than I thought :) Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Martin Phillips > Sent: 08 October 2008 14:50 > To: u2-users@listserver.u2ug.org > Subject: Re: [U2][UV] EQUATEs Using Syst

RE: [U2][UV] EQUATEs Using System Delmiiters

2008-10-08 Thread Brian Leach
Perry Actually you're going to feel the pain more.. Remember that an equate is nothing more than a literal substitution by the compiler. Every instance of MX will be replaced by 'ABCD':@AM:'EFGH'. So everywhere you access 'MX' you will also be performing the operation ('ABCD':@AM:'EFGH'). That's

RE: [U2] Universe Triggers

2008-10-08 Thread Brian Leach
One gotcha is that once a trigger is on there, you can't easily change/extend it unless your system has a downtime period in which everyone is logged out. For this reason on 24x7 sites I use a master trigger that can call subtriggers, held as a list in a parameter file. This means that a new subtri

[U2] [AD] Two dates for U2 users in the Uk...

2008-10-01 Thread Brian Leach
All For those of us in the Uk, a reminder of two forthcoming events: - The Uk round of the U2 University will be in Telford October 28th to October 30th. This is the main technical event for the IBM U2 community and well worth the entrance fee! I'll be there if anyone wants to buy a drink...

RE: [U2] Universe Lock Error

2008-09-18 Thread Brian Leach
Bjorn That is working as it should. To preserve the lock, pass the file variable to the called routine or hold it open in common. Locks are released when a file is explicitly closed or the file variable goes out of scope. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[

RE: [U2] cannot fnuxi a file with a trigger...

2008-09-17 Thread Brian Leach
Hi Stuart The best way I've found is to actually zero the pointer in the file header to the location of the SICA block, effectively removing the trigger and constraint details, then running fnuxi. Not good. Otherwise I have a utility program that builds a backup image of an account, set of accoun

RE: [U2] If you run UV, Read This !!! Change to UV Backup Recommendations

2008-09-17 Thread Brian Leach
Stephen Many thanks for researching and clarifying this. Regards Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Stephen O'Neal > Sent: 16 September 2008 19:47 > To: u2-users@listserver.u2ug.org > Subject: [U2] If you run UV, Read This

RE: [U2] AIX Socket Command?

2008-09-15 Thread Brian Leach
Hi Kevin Netstat - a (overall) Netpmon for stats per process ? >From memory so may be wrong Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King > Sent: 15 September 2008 16:20 > To: u2-users@listserver.u2ug.org > Subject: [U2] AIX S

RE: [U2] U2UG Website login issues

2008-09-11 Thread Brian Leach
Caleb Sorry - email from the site was down. You should get instructions now. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Ng, Caleb > Sent: 11 September 2008 17:23 > To: u2-users@listserver.u2ug.org > Subject: [U2] U2UG Website login iss

RE: [U2] call mysub vs. call @mysub

2008-08-27 Thread Brian Leach
Ross As others have said this was true for PRIME, which is why it is so often seen in legacy code, but is not the case for UniVerse. More useful is the fact that UniVerse caches subroutine object in memory until you exit to TCL, so the overheads on repeated calling are minimised anyway. Brian >

RE: [U2] Universe conversion migration

2008-08-14 Thread Brian Leach
Sorry if I'm stating the obvious, but UniVerse has been stopped (i.e. completely shut down) when you took that tar? Remember that type 30 files keep their header information in shared memory until UniVerse is closed down, so any tar whilst UniVerse has the file open (even if quiescent) may be unrel

RE: [U2] U2.NET v IBM.NET v UNIOBJECTS.NET

2008-08-14 Thread Brian Leach
Hi Susan UniObjects.net is the .Net version of UniObjects (sic) - that exposes a the native MultiValue features all nicely wrapped into classes. For details, take a look at my primer 'Writing your First UniVerse Application' on the U2UG site. That walks you through UniObjects.Net and VB.Net Expres

RE: [U2] Why Buy (or develop in) UniVerse?

2008-08-13 Thread Brian Leach
To add to my post: If you want one single good reason, take a look at the Wrox Press Expert One to One series books by Roger Jennings on database programming. He's a SQL Server and .Net guru. Read his chapters on performance tuning and concurrency management and weep for those guys. And if tha

RE: [U2] Why Buy (or develop in) UniVerse?

2008-08-13 Thread Brian Leach
David As always, that is a great post. Hit the nail on the head. I think part of the problem is we continue to call UniVerse a database. It isn't - it's an application platform that happens to have a complex storage model behind it. When you compare *application* performance against the three

RE: [U2] Getting stuck inside DOS shell UV-W2000

2008-07-30 Thread Brian Leach
Hi Try creating a verb pointer direct to the gpg executable rather than going via the DOS command. Brian -Original Message- From: "Marc Hilbert"<[EMAIL PROTECTED]> Sent: 30/07/08 02:22:36 To: "u2-users@listserver.u2ug.org" Subject: [U2] Getting stuck inside DOS shell UV-W

RE: [U2] Data Editor

2008-07-29 Thread Brian Leach
Couple more freebies: For programs, data etc. mvDeveloper is a Windows based editor (over UniObjects) that supports highlighting and lots of useful bits and pieces. Also to view data in a more structured way, ENTER is a dictionary driven screen entry/display tool. Both downloadable for free fr

Re: [U2] CAPTURING TOXML

2008-07-25 Thread Brian Leach
Hi Try using the TO option if that is supported on your release (part of that piecemeal way in which the XML stuff was released). That creates a record in &XML& somename.xml. You can also create a schema to go with it: SELECT * FROM BOOK_TITLES TOXML TO 'titles' WITHSCHEMA; Not sure whether U

RE: [U2] static/dynamic file(s) opinions wanted!

2008-07-24 Thread Brian Leach
All I've missed the start of this thread, so apologies to all if this has been mentioned before. On a 24x7 site, dynamic files should be the most useful (because there is no time available for resizing static files) but AFAIR beause the current load etc are held in shared memory, this prevents

RE: [U2] Basic SORT() Function not avail in UniVerse?

2008-07-22 Thread Brian Leach
Baker Off the top of my head: FUNCTION SortArray(InArray, AllowDups) Dc = DCount(InArray,@FM) OutArray = '' For I = 1 To Dc Locate InArray In OutArray By "AL" Setting Pos Then If AllowDups Then Ins InArray Before OutArray End Else Ins InArray Before OutArray End Next Return(OutArray)

RE: [U2] UV 10.2.7 change in behaviour for XML

2008-06-22 Thread Brian Leach
Sara Did you get BOTH REF.CODES_XML and TABLE_GENDER nodes? I would have expected the AS to override the REF.CODES_XML node, in which case you might be able to get it back by using an XMLMAPPING file. If not, I'm confused ... Brian We have just migrated from UV 10.1 to UV 10.2.7 and found we

RE: [U2] Friday query logic

2008-06-20 Thread Brian Leach
Jeff SELECT DISTINCT @ID TO SLIST 0 FROM UNNEST FILENAME ON FIELD WHERE NOT(FIELD LIKE 'SF%' OR FIELD LIKE 'SH%') ; The SQL is less of an overhead than doing a by-exp with SAVING UNIQUE @ID in RetrieVe. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]

RE: [U2] group locks and user nbr's

2008-06-19 Thread Brian Leach
Doug > But I am still a little confused on what would set a group > lock (I understand the record locks) and why a group lock > would need to be set and does it lock the entire file? > A group in a file contains pointers between records and pointers to overflow groups. So the group lock is ther

RE: [U2] group locks and user nbr's

2008-06-19 Thread Brian Leach
Doug To take the first part of your question: The lock table is used for application locks like READU and READL locks, and also for synchronisation locks. The RD and WR locks are synchronisation locks that control access to a group in a file during a read or write operation. these should be tran

RE: [U2] ActiveX component problem with Uniobjects application and Visual

2008-06-17 Thread Brian Leach
Eric At the risk of pointing out the obvious, have you loaded UniDK onto the XP machine? Rememeber the interop DLL created is only a stub to interface between .Net and the COM objects, which have to be installed and registered. BTW is there a reason why you are using the COM version of UniObjects

RE: [U2] New .Net data provider (Vista)

2008-06-11 Thread Brian Leach
Sorry David, that's still on my XP box. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan > Sent: 11 June 2008 10:55 > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] New .Net data provider (Vista) > > Hi Brian > > Have you

RE: [U2] New .Net data provider

2008-06-11 Thread Brian Leach
LE;")? > > Mike Randall, MCP > > > > > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach > Sent: Tuesday, June 10, 2008 3:43 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [

RE: [U2] New .Net data provider

2008-06-10 Thread Brian Leach
Mike Read my article on the .Net data provider in Spectrum :) You can download PDF versions from http://www.intl-spectrum.com Regards Brian Anybody out there trying to use the new .Net Data Provider? We seem to be having quite a time finding documentation and getting answers. The key a

RE: [U2] UVODBC Activation in Account

2008-06-09 Thread Brian Leach
Hi Mac At that address it is trying to open a file in your account. So I guess either the file is corrupt or there is some other file system error. Do a LISTFILES and try to clean up any crappy file pointers. Otherwise there is something wrong with one of your files or indexes. Brian > -Or

RE: [U2] UniObjects 30102 error

2008-06-04 Thread Brian Leach
Amy That sounds about right - 30102 is 'bad datum' which basically arises when something has crashed out at the back end. The full list can be found in the gcidir/include/api_public.h file on UniVerse, but I'm not sure where/if available on UniData. Brian Never mind - figured it out. Had a

RE: [U2] OT: Textpad Syntax File for Unidata

2008-06-01 Thread Brian Leach
Don Here is a definition for UniVerse that I adapted from a syntax file for DataStage that I downloaded from the site. It might be a good starting point for a UniData definition. You might also want to download a copy of mvDeveloper from my website. It's free, UniObjects driven and has highlighti

RE: [U2] Uniobjects for Java

2008-05-30 Thread Brian Leach
Charles I think you have to pull them off the uojsdk directory on your Windows PC after installing UniDK. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: 29 May 2008 21:29 > To: u2-users@listserver.u2ug.org > S

RE: [U2] [UV] Error log

2008-05-20 Thread Brian Leach
Hi They are all in the SYS.MESSAGE file in the uv account. Regards Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: 20 May 2008 16:03 > To: u2-users@listserver.u2ug.org > Subject: [U2] [UV] Error log > > Hello

RE: [U2] multi-valued extraction

2008-05-20 Thread Brian Leach
Mark You're right - I also started with F correlatives back in the dark ages. They still come back to haunt me - I even had to teach them on a training course just a couple of weeks back. But I'm prejudiced - I really dislike the PICK style descriptors immensely (yes, even A correlatives). Movin

RE: [U2] multi-valued extraction

2008-05-20 Thread Brian Leach
Tony A. FYI the ^253 is the representation of a value mark in the UniVerse editor. So the first example will work correctly. B. If I were forced to use a hideous Pick style dictionary rather than a nice I-descriptor (grin) I would probably use the following, which will also work successfully: F;

RE: [U2] multi-valued extraction

2008-05-19 Thread Brian Leach
Hi Brenda The substring extraction does not vector in an I Descriptor. One way around it is to use OCONVS() OCONVS(@RECORD<1>,"T1,4") Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price > Sent: 19 May 2008 21:24 > To: u2-users@lis

RE: [U2] Creating a file in a different account

2008-05-16 Thread Brian Leach
Bjorn You can call out to the mkdbfile executable in the $UVHOME\bin directory. mkdbfile filepath type modulus separation Depending on how you want to do this, here is a suggestion: 1. Create a Q pointer to the remote VOC 2. Open the Q pointer and get the path (use Status<27> and strip out the

RE: [U2] HP 4250dtn printer using PCL commands from Universe Basic program with hex conversion codes ... Tray 3 selection not working

2008-05-14 Thread Brian Leach
Hi Bob You are addressing the printer as a generic/text only printer? If not the PCL escape codes will just get filtered out. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bob Utech > Sent: 14 May 2008 15:14 > To: u2-users@listserver.u2

RE: [U2] Backup Question

2008-05-14 Thread Brian Leach
John et al > I've also used the unix/linux OS-level cp command > to make a duplicate copy of our entire production database for > development use evey night for the past 12 years, and have yet to run > into a single issue with file integrity. That's only possibly valid if you don't use dynamic

RE: [U2] "blink questions"

2008-05-13 Thread Brian Leach
Henry, If you're lucky the file fixing utility uvfixfile may repair it: type HELP uvfixfile for details. For anything other than automatic fixing you need to find some expertise or get the backup out. If you're really lucky, you might (might) get the content out by using RESIZE filename * * * T

RE: [U2] Blink Error - Dictionary Related

2008-05-12 Thread Brian Leach
Henry That is a really really bad idea. Each UniVerse keeps its lock table in memory, used to coordinate access at the group level whilst reading and writing as well as the record lock handling. As soon as you access a file on another system without coordinating with the remote lock table, you ar

RE: [U2] UniVerse to PDF {Unclassified}

2008-05-12 Thread Brian Leach
All Not sure whether I should put [AD] around this since it is a direct answer to this question ... So read 'AD' if you want.. mvPDF is written specifically for U2 (and now QM and D3). It's a split solution: the physical PDF generation is handled through a service written in Delphi for reasons o

RE: [U2] Universe XML is not to standard

2008-05-12 Thread Brian Leach
Keith That's probably a side effect of the piecemeal approach with which XML functionality was added over the 10.1 - 10.2 releases. Originally you had to capture (e.g. using DIVERT.OUT or COMO) which added the initial annoying blank line. The TO and WITHSCHEMA options were added later. Brian > -

RE: [U2] Universe XML is not to standard

2008-05-08 Thread Brian Leach
Keith I'm not sure that the modifiers like HEADING and the break handling in RetrieVe make sense in the XML context anyway. I'd rather see a separate keyword if you want to add a comment element. Brian -Original Message- From: "Keith Johnson (DSLWN)"<[EMAIL PROTECTED]> Sent:

RE: [U2] UniVerse Triggers

2008-05-08 Thread Brian Leach
Mike If you check the recent issues (pdfs on their site) I wrote an article on triggers for Spectrum you might find useful. Brian -Original Message- From: "Mike Randall"<[EMAIL PROTECTED]> Sent: 08/05/08 03:58:08 To: "u2-users@listserver.u2ug.org" Subject: RE: [U2] UniV

RE: [U2] UniObject.NET: What are you doing for LOCATE?

2008-05-06 Thread Brian Leach
Clif I wrote my own - BUT - now I'm thinking I should recode it as a .NET 3.5 extension method to enhance the UniDynArray class. Which, strangely enough, sounds like a good topic for next month's Spectrum :) Brian Greetings again, everyone. Second question, put in a separate e-mail for e

RE: [U2] UniObjects.NET: .GenerateXML method fails

2008-05-06 Thread Brian Leach
Hi Clif I would check to see whether the GETXMLSUB subroutine has been globally cataloged in the uv account. The code is in BP, it needs to be cataloged as *GETXMLSUB. Brian Greetings, List Citizens (Litizens?) A client of mine and I are having problems with using UniObjects.NET and the Ge

RE: [U2] Downloading and Installing RHEL Desktop 5.1 From Scratch

2008-04-20 Thread Brian Leach
Dave I'd second that - I use CD Burner XP and it is excellent. And it works on Win2003 as well as XP! Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Adrian Merrall > Sent: 20 April 2008 11:25 > To: u2-users@listserver.u2ug.org > Subject

RE: [U2] version control

2008-04-17 Thread Brian Leach
t > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:owner-u2- > > [EMAIL PROTECTED] On Behalf Of Brian Leach > > Sent: Thursday, April 17, 2008 4:14 AM > > To: u2-users@listserver.u2ug.org > > Subject: RE: [U2] version control > > &g

RE: [U2] version control

2008-04-17 Thread Brian Leach
David You might want to check out an article I wrote for Spectrum about this. Back-issues are on www.intl-spectrum.com. One other tip: We used CVS at my last company, which was quite a complex arrangement handling server and client side code (and keeping these in sync). The key was to appoint s

Re: [U2] Unidata Training

2008-04-15 Thread Brian Leach
Dawn (and apols to all) cheers! --dawn P.S. I'm not quickly putting my finger on the email from Brian that said he has a published (or soon-to-be) book for beginners -- very cool, Brian -- how does one get that? [AD - sort of - response thingy ] I've completed the first of three books - this one

RE: [U2] Difference between Universe and Unidata

2008-04-13 Thread Brian Leach
Well I couldn't resist. First, I support products on both databases. Both have broadly the same core multivalue features, though with different approaches to syntactic variances: UniVerse accounts are set up with specific 'flavors' (emulations) whereas UniData uses a combination of a run-time

RE: [U2] Unidata Training

2008-04-13 Thread Brian Leach
Greg [AD] To follow up after Kevin's great training, I've just published the first in a series of self-paced training books on UniVerse, most of which is equally relevant to UniData. This first one covers the enquiry language, I'm working hard on the next one covering server side development.

RE: [U2] Uppercase

2008-04-09 Thread Brian Leach
Dennis Then there is something wrong. UniVerse has always allowed mixed/lower case and plenty of whitespace. If you're on UniData that is still steam-powered until I think version 7(?) where you need to explicitly pass an option to the compiler (-I AFAIR but I'm not sure off-hand - I just use a pr

RE: [U2] COMMON

2008-04-04 Thread Brian Leach
Yes, but On thing to remember - OpenSeq sets a record lock. That will remain until you CloseSeq the record. If the file is unique to your user number, for example, you might want to release it rather than have a load of these clogging up your lock table. One of the few occasions when locking coul

RE: [U2] Question about windows xp

2008-03-17 Thread Brian Leach
Hi Cisar Yes it is. Just remember that XP is a workstation O/S so it only allows a maximum of 10 connections. Brian Hello It is possible install universe in windows xp? Thanks. Cisar Riba Spain No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 26

RE: [U2] Universe/SB+ printing including images

2008-03-17 Thread Brian Leach
Hi Robin [AD] You might want to take a look at mvPDF. Despite the name, it can render directly to printers as well as producing PDF documents. It's very flexible with a BASIC API underlying it so it can be tailored to most solutions, and I have a white paper on using it to capture SB+ reports.

RE: [U2] Indexes

2008-03-14 Thread Brian Leach
Dennis Two more ways to do this: 1/ you can use BASIC but it's a slight pig.. The SelectIndex statement selects keys from an index. But it generates a select list, so you need to be careful about segregating these e.g. if calling from a SUBR() in an Idescriptor. 2/ a way I'm clearly not recommen

RE: [U2] blank lines in code / mixed case

2008-03-10 Thread Brian Leach
Kevin We - 1. Accept that the list is populated by long-term professionals whose opinions aren't going to be changed. 2. Accept that this is a learning and familiarity issue. 3. Do everything we can to promote best practice in legibility regardless of case. 4. Ensure that all learning materials

RE: [U2] blank lines in code / mixed case

2008-03-10 Thread Brian Leach
Kevin That's not a full lifecycle test - which is where the casing difference really comes in. If you want to set a test, have the two groups scan through reams of unfamiliar code, make sense of it, identify the bits to change and only then do the changes. That's where the benefit lies. Though I p

RE: [U2] blank lines in code / mixed case

2008-03-08 Thread Brian Leach
Dennis I have no idea why your code should not compile ... I always use plenty of whitespace and, yes, for the past 15+ years I've been using mixed case. For good reasons - once you get used to ie (and that *IS* the caveat) it's much quicker to scan. That's why all modern languages use it. Of cou

RE: [U2] INCLUDE weirdo

2008-03-07 Thread Brian Leach
> All I can say is, you must have a lot of free time. I'm reminded of the old saying - if you want something doing, ask the busiest person. Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] Pooled UO.Net Connections

2008-03-07 Thread Brian Leach
All Being too poor to afford to purchase pooled connection licences just for testing, I'm interested in hearing from anyone using these with UO.NET in anger in terms of performance and stability. Thanks Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please vis

RE: [U2] INCLUDE weirdo

2008-03-06 Thread Brian Leach
Susan >> her RPL code was very easy to read and maintain Suspending disbelief... >>I actually liked RPL! Nooo..!! I wrote an RPL compiler for UniVerse. I still have nightmares. Whoever introduced KSUB should be tarred and feathered. And that's without some of the 'undocumented

RE: [U2] INCLUDE weirdo

2008-03-04 Thread Brian Leach
Dennis If you're using BLAT I assume you're on Windows. I've seen an INCLUDE hang if the included file doesn't have a terminating CRLF. Go into the editor and file it again and see if the problem persists. Brian I have an INCLUDE statement that brings in code from a snippets file called SNIP

RE: [U2] mvDeveloper

2008-02-29 Thread Brian Leach
Dennis Please send these to [EMAIL PROTECTED] They don't belong on the list. Thanks Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] AE editor replacement [AD]

2008-02-29 Thread Brian Leach
Perhaps a good idea would be to make the install update those paths since (as it is creating the Program Files subfolder BLC\mvDeveloper\etc) it already know the paths to the required files. dennis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian L

RE: [U2] Question about the U2 News Flash...

2008-02-29 Thread Brian Leach
Bob et al If anyone is interested I've done a writeup of the new ADO.NET provider in the next issue of Spectrum (that's www.intl-spectrum.com for details). It seems to work pretty well, especially if you restrict it to calling remote procedures. Use SQLExecDirect() in a BASIC subroutine and ass

RE: [U2] AE editor replacement [AD]

2008-02-28 Thread Brian Leach
Hi Brian > > How does one get syntax highlighting with the new mvDeveloper? > > > > slightly perplexed... > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach > Sent: 28 February 2008 11:12 AM >

RE: [U2] AE editor replacement [AD]

2008-02-28 Thread Brian Leach
Okay, so while we're on the subject, I've just posted an update to my free mvDeveloper windows based editor. This can call handler subroutines on save, build etc to keep a version track. You can download this from www.brianleach.co.uk Regard All Brian > -Original Message- > From: [EMA

RE: [U2] by.exp when

2008-02-11 Thread Brian Leach
Roger For what it's worth, I've done an equivalent query in prime flavor using my demo database and as you would expect, it works fine: SORT BOOK_SALES BY.EXP TITLE_ID WHEN TITLE_ID = "45" BOOK_SALES. 13681*55800*3 Sale Date.. 15 JUN 2005 SURNAME ALEXENDERS FORENAME... COLIN TITLE_ID QTY PRI

RE: [U2] OCONV DATE ISSUE.

2008-02-08 Thread Brian Leach
> The question is when I do > OCONV(@DATE, 'DM') I get 02 but when I do OCONV(@DATE, > 'DM')-1 I get 1 not 01. > Why? And how do I get these to match? In the first expression, 02 is a string. You are then applying an arithmetic operation, which coerces it into a number (1). To get them to match

[U2] U2UG Last Chance to Vote

2008-02-08 Thread Brian Leach
Calling all U2UG members on this list - This weekend is your last chance to vote for the new U2UG board members. So if you haven't decided yet, sign in to www.u2ug.org and go to the Election link (on the left hand side under 'Membership'!) Make it count. Brian --- u2-users mailing list

RE: [U2] [UB] Detecting KeyBoard Up Arrow

2008-02-08 Thread Brian Leach
Bill To get the keystroke you probably need raw input: C = KeyIn() ;* get initial key If Not(Seq(C) > 32 And Seq(C) < 127) Then ;* it's probably a control key... Nap 50 ;* time for slow networks and VPNs Loop Input n,-1 While n Do C := KeyIn() Repeat End Note that if you're usin

RE: [U2] NotePad++ User Defined Language

2008-02-08 Thread Brian Leach
Hi You might want to download mvDeveloper from my website. It's a free, lightweight windows based editor. And for those who already use it, I'll be posting an update later this month :) Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Den

RE: [U2] question(s)

2008-02-06 Thread Brian Leach
Doug > 1.In universe how can I tell what type of pick file I am looking > at (type 2,3,4,5,6, etc ) PROGRAM FILEINFO Get(Arg.) FileName Else Crt 'File : ':; Input FileName If FileName = '' Then STOP End Open FileName To FL Else Crt 'Cannot open ':FileName STOP End Status FStat

RE: [U2] Totaling an Oconv'd DICT column

2008-02-06 Thread Brian Leach
Baker It's clearly giving floating point maths errors, but if scaled back would the figures be correct? i.e. you could add an extra MD20 conversion in field 3 of AR.TOT.USD.FRGN (ignoring the fact that combining currencies in this way is pretty meaningless...) Brian --- u2-users mailing list

Re: [U2] UniObjects error 30105 "Unable to load subroutine on server"

2008-02-05 Thread Brian Leach
Wol >From memory (sorry using webmail here) you're calling the subroutine with a >record read throug a file object. Make sure you extract the stringvalue for the call or you may get reference errors - remember record is a dynamic array object not a string. This may be why it doesn't fail if th

Re: [U2] Re: PCL: command

2008-02-05 Thread Brian Leach
Maj Strangely enough, I've already put one on the U2UG Wiki. Regards Brian I'm surprised someone in any MV hasn't submitted a comprehensive PCL.INCLUDE that would help many of these requests. I have one that I use for 60% of what I need (pitch, orientation, typefaces, some line graphics and o

[U2] U2UG Elections...

2008-02-01 Thread Brian Leach
Calling all U2UG Members on this list... You should have received today an email with voting instructions to elect the new U2UG Board members for 2008. If not, and you're one of the 400 mail delivery failures cluttering my Inbox, you are still eligible to vote! Just find a few minutes over th

RE: [U2] Execute Windows Script

2008-01-25 Thread Brian Leach
JayJay This is pet topic of mine: for some reason so many Windows administrators are completely unaware that Windows has truly excellent scripting facilities - particularly those who migrate from UNIX and complain about the lack of shell scripting. One great thing is that you can instantiate UniO

RE: [U2] Execute Windows Script

2008-01-24 Thread Brian Leach
Hi Amy Try "DOS /C path_to_your_batchfile.bat" Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Amy Raisanen > Sent: 24 January 2008 16:10 > To: u2-users@listserver.u2ug.org > Subject: [U2] Execute Windows Script > > My goal is to run a Uni

RE: [U2] [UV] Selection help

2008-01-23 Thread Brian Leach
David Very close.. just need the uniqueness adding. How about simply: SELECT DISTINCT CODE FROM UNNEST LOOKUP.TABLE ON CODE WHERE @ID = 'XYZ' ORDER BY CODE; Code.. AAA BBB CCC 3 records listed. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On

RE: [U2] .NET ODBC Driver

2008-01-18 Thread Brian Leach
Jimmy Acccording to the release notes, only 7.1 and above. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jimmy Dixon > Sent: 17 January 2008 15:07 > To: u2-users@listserver.u2ug.org > Subject: [U2] .NET ODBC Driver > > I have been lookin

RE: [U2] accessing U2 with PHP

2008-01-14 Thread Brian Leach
Charles I guess this should be addressed to Tony, but I'll answer anyway - COM is windows-specific (which is why I didn't think to suggest it for PHP..) If you want to use UniObjects on Linux you'll need to use UOJ (java version). You might just be able to get UO up and running through an emulati

<    1   2   3   4   5   6   7   8   9   10   >