RE: Calling UniData subroutines via OLEDB

2004-04-27 Thread Brian Leach
Steven, Sorry I don't know this for UniData, but I posting just in case it may use similar techniques to those under UniVerse. On UniVerse you can use the CALL statement (that's CALL as in SQL CALL not a BASIC CALL) CALL subroutine(Args) MyCmd.Text = 'CALL MySub(1)' (NOTE : This is

RE: [UV] Problem reactivating select list

2004-04-27 Thread Brian Leach
John, Why write a wrapper? ED is a scrudgy BASIC program - (uv Account BP ED.B). You could just modify that. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Hester Sent: 26 April 2004 22:22 To: U2 Users Discussion List Subject: [UV] Problem

RE: How far can U2 scale?

2004-04-23 Thread Brian Leach
Dawn, Looking at this from outside, I would suggest that session persistence creates the overheads, so if you are running a traditional application that needs to maintain a single session per user (e.g a green screen or UniOjects application) you are probably limited to several thousand users on

RE: GUI as nice as character-based

2004-04-20 Thread Brian Leach
To go back to Dawn's original post - Dawn, I've been writing GUI applications for UniVerse for about 15 years now. Some have worked, some have - well - been learning experiences. You shouldn't really compare GUI and character based. Why? Because then you inevitably start to think of the GUI in

RE: GUI as nice as character-based

2004-04-20 Thread Brian Leach
I was hoping Ross would recognise the possiblity that Windows might go the same way despite current market domination. So write your clients in Delphi - Delphi for Windows native Delphi for .Net Delphi (Kylix) for Linux and D2J - produces Java bytecode from Delphi. Or if you want browser based

RE: GUI as nice as character-based

2004-04-20 Thread Brian Leach
(scary how much php has moved up lately!) Actually I find it reassuring to know that PHP is still more popular than C# Brian This email was checked on leaving Microgen for viruses, similar malicious code and

RE: GUI from Mv code Re: Crystal Reports

2004-04-19 Thread Brian Leach
When we advise clients on GUI, we always advise a divide and conquer approach. It is amazing just how small a percentage of a system actually needs to be GUItized, once you have partitioned out the business rules, report and (strange) user menus, admin facilities etc. Use a regular report

RE: UV to Text Conversion Standard?

2004-04-14 Thread Brian Leach
Jim, I don't see why on earth you want to use fixed length data with Excel. Do you need to normalize the data or are you intending to use multi-line cells? The best way to importing multiline cells into Excel is to generate a HTML file that represents the spreadsheet cells as an HTML table.

RE: UV to Text Conversion Standard?

2004-04-14 Thread Brian Leach
True, But Jim didn't specify his version of UniVerse. if his version does support TOXML it may still be the simplest option, and avoids having to do any coding. If not, it is always available on the Personal Edition ... Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: [ANNOUNCEMENT] Visage Roadshow in NZ

2004-04-13 Thread Brian Leach
If only ... You shouldn’t torture us like that - on our first day back to work after the Easter weekend! Now I'm going to spend the rest of the day thinking about the Black Barn vineyard in Hawkes bay... Enjoy your roadshow you swine grin Brian Leach -Original Message- From: [EMAIL

RE: Performance

2004-04-08 Thread Brian Leach
Duh duh duh Please ignore my last post. I scanned it and missed 'AIX'. It's the end of the day here Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Vezertzis Sent: 08 April 2004 17:08 To: [EMAIL PROTECTED] Subject: Performance We

RE: The lists are closing

2004-03-29 Thread Brian Leach
Cliff, We whose lists are about to die, salute you. It's been a great service - you should be held up as a shining example to moderators everywhere in promoting the best blend of discussion, humour and debate amongst a very informative list. More than that, you have made us all into a (not

RE: VB / SQL questions

2004-03-29 Thread Brian Leach
Just to add, And if they clash with SQL keywords like DATE, USER or STATUS. So it's just generally safer to enforce them, as you never know what keywords are likely to be added in the future. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry

RE: Modern Universe - was: The lists are closing

2004-03-29 Thread Brian Leach
Joe, I shouldn't even dignify this crap with a reply, but anyway ... 1. Populate UV and Oracle with around 10 Million records. 2. Write fairly complex Web Application against it. 3. Run a Web Application Stress tool(around 1000 Users) switching Databases within the same DB Machine. We've

RE: Writing a RPC Service

2004-03-26 Thread Brian Leach
Sounds like a pretty stupid idea to me. Shut down unirpc and write something else instead. Best option - buy redback and restrict access to the RBO designer. Then they can only use the objects and their properties published. Brian -Original Message- From: [EMAIL PROTECTED]

RE: ANTIVIRUS

2004-03-25 Thread Brian Leach
We used until very recently to run McAffee on Linux to scan all of our emails. It was slow and difficult to incorporate into our configs, but it was effective. Mind you, our mail server wasn't exactly the most powerful Linux box we were running... Now that is handled corporately, so I don’t know

RE: ANTIVIRUS

2004-03-25 Thread Brian Leach
Of course, as every article will tell you, the main thing is not what AV you are running. There are lots of good ones out there. The main thing is to ensure that your definitions are kept up to date. Otherwise they are all equally useless. I did run one that used some form of heuristics to try to

RE: Suppressing detail in UniObjects command

2004-03-15 Thread Brian Leach
Sounds like your ECL type is set differently for your login and Objects sessions. Remember, UniObjects doesn't run LOGIN. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Southwell Sent: 15 March 2004 16:15 To: U2 Users Discussion

RE: EVAL

2004-03-11 Thread Brian Leach
Is there a way to assign a justification to an EVAL item other than having it use the justification of a field used in the formula? I know you can assign different formatting and conversion. Yes, use the FMT keyword. Brian.

RE: Mvquery Client Not Responding

2004-03-11 Thread Brian Leach
. Regards, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave S Sent: 11 March 2004 15:48 To: [EMAIL PROTECTED] Subject: Mvquery Client Not Responding When running the Mvquery client on my desktop and performing a query, the windows

RE: How do I make this easier to read?

2004-03-11 Thread Brian Leach
You could either: A: Use two I Descriptors to turn on and off video attributes testing against @NI: IF NOT(MOD(@NI),2) THEN video_chars ELSE B: Buy a reporting tool like mvQuery (blatant ad) and use the report designer to do it for you. Brian -Original Message- From: [EMAIL

RE: UX to NT

2004-03-08 Thread Brian Leach
Mark, Are you specifying -nodrv when restoring? Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Waldron Sent: 07 March 2004 22:42 To: [EMAIL PROTECTED] Subject: UX to NT Having trouble with the uvbackup on unix and uvrestore on

RE: UV - Database backup

2004-03-08 Thread Brian Leach
Firstly - do not tar a running uv system! This is because: A) you will get physical errors if writes are in progress. B) you will get logical errors if transactions are in progress. C) if you use dynamic files, the headers will not be updated. D) 'nuff said uvbackup should be aware of the

RE: VB primer help ?

2004-03-05 Thread Brian Leach
the lines of: set fso = CreateObject(scripting.filesystemobject) Set F = FSO.OpenTextFile(fn, 1) Do while not F.AtEndOfStream s = F.ReadLine MyFields = split(s,MyDelimiter) ' do some processing here Loop F.Close I'll let you work out the rest yourself! Brian Leach -Original Message

RE: Pick AP-Pro Discs

2004-03-05 Thread Brian Leach
Mark, I assume you've asked the question on comp.databases.pick? If not, you may get more joy there. Brian I'll restate the question: snip Does anyone have the box, manuals and installation diskettes for AP-Pro for the Pentium I system that they could give/loan/sell?

RE: [UV] Variable never assigned a value warning

2004-03-03 Thread Brian Leach
warnings like this that you might lose a legitimate warning amongst them. Less of a problem on U2 where you are not linking so much code into a single routine, but potentially annoying all the same. Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED

RE: When is developing with UniObjects the correct approach?

2004-03-01 Thread Brian Leach
to make U2 look relational. Which is isn't (really). The only time I would consider these is when interfacing to standard packages that don't understand anything else: and then I'd go for OleDB over ODBC for all of the usual client-side performance reasons. Regards, Brian Leach -Original

RE: [UV] Recursive GOSUB

2004-03-01 Thread Brian Leach
Yes. Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Manyevere Sent: 01 March 2004 10:08 To: [EMAIL PROTECTED] Subject: [UV] Recursive GOSUB Hi All, Can a UV GOSUB directly or indirectly refer to itself? Something like

RE: Uniobjects Asp

2004-02-27 Thread Brian Leach
, including call centres, billing and other fairly intensive applications and performance has not been an issue. Regards, Brian Leach -Original Message- From: Cooper, Rudy [mailto:[EMAIL PROTECTED] Sent: 26 February 2004 21:46 To: [EMAIL PROTECTED] Subject: Uniobjects Asp Hello

RE: mvQuery's MVQUERY_LOGIN MVQUERY_ABORT features

2004-02-27 Thread Brian Leach
to an issue with UniObjects). If this is your configuration there is a patch we can ship you. Regards, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Denny Watkins Sent: 26 February 2004 21:20 To: [EMAIL PROTECTED] Subject: mvQuery's

RE: [UV] Very slow SQL query

2004-02-20 Thread Brian Leach
fields or I Descriptors? Do any call BASIC subroutines, or do translates (TRANS or XLATE functions?) 3. The obvious one - what is the file sizing like? 4. What does the BASIC program do that is different? There should be no reason for this SQL command to be slow. Brian Leach Hello, I

RE: version control software

2004-02-19 Thread Brian Leach
, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Steinmetz Sent: 19 February 2004 02:20 To: [EMAIL PROTECTED] Subject: version control software I am looking for a version control application for U2 software development. Ideally

RE: Swap array values? In UV

2004-02-16 Thread Brian Leach
It's an 'old as the hills' C programmers' trick Which is no relection on Glenn of course ... Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 16 February 2004 16:47 To: [EMAIL PROTECTED] Subject: Re: Swap array values? In

RE: SQL Server and Crystal Reports

2004-02-11 Thread Brian Leach
licence as well as licences for all the MS platforms, office versions, development tools etc. If your client wants to retain you this could be a very good investment on their part. Regards, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf

RE: UV on SCO Unix

2004-02-11 Thread Brian Leach
Bill, We have run UniVerse on Linux for years (actually about 10 years, originally using the SCO emulation package for Linux). If you know your way around Linux, and if it is UNIX-y enough for you, we have always found it to be solid. Regards, Brian Leach -Original Message- From

RE: Real Time Data Warehouse

2004-02-10 Thread Brian Leach
the spurious credibility of a well presented report. Brian Leach This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any

RE: Formatting a Negative

2004-02-10 Thread Brian Leach
OCONV(value, MDn) where n is your descale factor, e.g. Crt OConv(123.45,MD2) gives 1.23 Crt OConv(-123.45,MD2) gives 1.23 For more detail, HELP CONV MD (UniVerse). Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baruch Salamander Sent: 10

RE: Help wanted creating an efficient SELECT statement

2004-02-04 Thread Brian Leach
= [EMAIL PROTECTED], 3, DCount(Text,@FM)-3] ;* remove leading and trailing blank lines Open "SAVEDLISTS" TO FL Then Write Text On FL, "MyList" End CHAIN "GET.LIST MyList" Hope this helps, Brian Leach From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED

RE: UV SELECT Info Display

2004-02-04 Thread Brian Leach
Mark, This is probably too late, but FYI it's EXPLAIN Regards, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Eastwood Sent: 03 February 2004 21:59 To: 'U2 Users Discussion List' Subject: UV SELECT Info Display Brain Freeze

RE: COM Exception

2004-02-04 Thread Brian Leach
Gene, More information needed, I'm afraid. What are you actually using to access UniVerse: is it UniObjects, UniOjbects for Java, ODBC, OleDB ? Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gene W. McDonald Sent: 04 February 2004 13:55

RE: The result of VARIABLE[1,3] + 0

2004-02-02 Thread Brian Leach
Marco, Sounds like a bug inwhatever pointrelease you are running. What happens if you say B = A[1,3] * 1 ? I would be very worried about a runtime errorfrom '123' + '456'. Not good. Brian Leach From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco ManyevereSent: 02