Re: [U2] Uppercasing in SELECT

2010-12-06 Thread Bill Haskett
The downside is if you want to output the field in its input format you'll either need to create a separate dictionary of use the EVAL keyword in the query. I've been down this road far too often and am happy with the EVAL keyword instead of the normal PICK method of creating another dictionar

Re: [U2] Editors/Development Tools for Universe Basic programs.

2010-12-07 Thread Bill Haskett
Ken: You know, it'd really be cool if you'd capture what you did on the screen to do development in a video and post it. I think there's some really nice video capture software available. I can't tell you how much that would be useful. Bill

Re: [U2] Uniobjects on windows

2010-12-12 Thread Bill Haskett
Doug: Check out the Pickwiki at http://www.pickwiki.com/cgi-bin/wiki.pl?Accessing_U2_From_PHP HTH, Bill Doug Chanco said the following on 12/12/2010 9:59 AM: With the free version of universe 10.3 does uniobjects work?

[U2] [UD] Killing a UO connection

2010-12-28 Thread Bill Haskett
nnection so I can program it into BASIC? Thanks, -- Bill Haskett */Advantos Systems, Inc./* ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [UD] Killing a UO connection

2010-12-29 Thread Bill Haskett
ion) but that's the command that I understand is supposed to be used in place of UniAdmin to force a user down. -------- Subject:[UD] Killing a UO connection Date: Tue, 28 Dec 2010 13:48:48 -0800 From: Bill Haskett To: U2 Mail List I'm running UO for m

Re: [U2] U2 Wrapper

2011-01-11 Thread Bill Haskett
Dan: I created custom VOC entries that look like: 001 V 002 U2.LISTINFO ...for the following verbs: 6 Dev (0)-> SORT VOC WITH F1 = "V" AND WITH F2 = "U2.LISTINFO" ID-SUPP @ID_A ID DELETE-LIST DELETE.LIST DELETELIST DL SAVE-LIST SAVE.LIST SAVELIST SL delete-list delete.list deletelist

Re: [U2] re directing a unidata directory to another server

2011-01-22 Thread Bill Haskett
From what I understand you have Unidata on one machine and you want to write to a directory on another machine within your network (node). I'm not sure what you mean by "a folder on another server that is in the same virtual machine"...a virtual machine spans two physical machines? Assuming I

Re: [U2] re directing a unidata directory to another server

2011-01-22 Thread Bill Haskett
I don't think UD has the NFSALLOW flag. In UD, you can simply write to any directory that's available to the network where the user had write privileges. This raises a number of issues but, for instance, in Windows 2003 Server you can create a VOC entry to: OSFILE 001 DIR 002 \\SOMESERVER\D$

Re: [U2] Data in Dict

2011-01-24 Thread Bill Haskett
Kate: It seems to me that this is very tidy! :-) Bill Kate Stanton said the following on 1/24/2011 1:27 PM: Hi David, The reason we use dictionaries for data entry, reports, queries and forms is so we can use the same d

Re: [U2] unidata triggers and record locks

2011-01-25 Thread Bill Haskett
Jeffrey: I had to use the following code in my trigger to figure out what was going on. * ** Determine status of trigger call. * StatusOfCall = STATUS() * IF StatusOfCall = 1 OR StatusOfCall = 2 THEN * HLDMSG = TriggerToRun : " trigger for " : atFILENAME : ', ' : atID *

Re: [U2] Data in Dict

2011-01-25 Thread Bill Haskett
file you want to keep one on to avoid losing all your keys with one file issue. What other methods are people using to track next ID? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, Janua

Re: [U2] Refresh UV user permissions without restarting UV Service ?

2011-01-28 Thread Bill Haskett
Arnold: I'm not sure about UV but in UD, when I change windows permissions, they immediately work through UD. This is because UD uses Windows permissions and doesn't have their own security (well, limited anyway). I didn't realize UV was different. Bill

Re: [U2] What do you do with CallHTTP?

2011-01-31 Thread Bill Haskett
Jeff: I don't believe phantoms use a seat by default. The solution you advocate is one that has been occurring in the PICK market for years; if you want to do something reasonable then get off of PICK to another product that doesn't use a very expensive "telnet" licensing paradigm, especiall

Re: [U2] What do you do with CallHTTP?

2011-02-01 Thread Bill Haskett
George: I'm not sure what you mean by "front-end". No software can be sold today with a telnet-based "character" interface. So, if you mean a CUI front-end then I'd have to point out that you don't really get a "front-end" with U2 either, because CUIs are unusable and, therefore, of no valu

Re: [U2] What do you do with CallHTTP?

2011-02-01 Thread Bill Haskett
all the CUI unusable, maybe not pretty, maybe inflexible but definitely not unusable. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, February 01, 2011 3:09 PM To: U2 Users List Subje

Re: [U2] What do you do with CallHTTP?

2011-02-02 Thread Bill Haskett
Symeon: To your comment, I can only agree. :-) Bill Symeon Breen said the following on 2/2/2011 12:00 AM: I am not being rude, but the whole concept of being data storage agnostic and building the application layers abo

Re: [U2] What do you do with CallHTTP?

2011-02-03 Thread Bill Haskett
This reminds me of the spare light bulbs in our home. My wife keeps them in five (5) different places. I keep complaining I can never find the right light bulb for the right light fixture with a burned out bulb. :-) When software is spread around like the spare light bulbs in our house, pe

Re: [U2] What do you do with CallHTTP?

2011-02-04 Thread Bill Haskett
Doug: Let me point out an alternative perspective. An ISV's job is to sell our applications. If we can't compete in our business marketplaces, we need to make adjustments or look at alternatives. Competition mostly means we need to offer a product that benefits our customers at a price tha

Re: [U2] What do you do with CallHTTP?

2011-02-05 Thread Bill Haskett
org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Friday, February 04, 2011 2:07 PM To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? Doug: Let me point out an alternative perspective. An ISV's job is to sell our applications. If we

[U2] [UD] Building a Dictionary with MV Functions

2011-02-08 Thread Bill Haskett
he TEST_REQUEST definition to work (although ACTIVE is working now in a different way) because it bothers me to not be able to get this to work. -- Bill Haskett *//* ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [UD] Building a Dictionary with MV Functions

2011-02-08 Thread Bill Haskett
02-07-1110:35:10 87229 02-07-1111:10:52 85087 02-08-1109:45:21 3818 7 records listed. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.or

Re: [U2] [UV] UODOTNET.DLL and 64bit windows.

2011-02-18 Thread Bill Haskett
I use version 2.2.0.7276 on Windows 2008 R2 (it's only a 64 bit O/S). Bill On 2/17/2011 2:10 PM, Jacques G. wrote: Hello, I wanted to know if anyone here uses the Uodotnet.dll with 64bit versions of Windows. Particularly

Re: [U2] Frustrated with Rocket / Unidata 7.2

2011-02-18 Thread Bill Haskett
Kevin: I had a problem with SETPTR on UD v7.2.5 when I converted to Windows 2008 R2 (Windows 7 Server). I contacted Rocket, we identified the problem as having to do with the user setptr was running under, and they fixed the problem in v7.2.7. This all took about a month or so. I'd say tha

Re: [U2] U2UG Elections 2010 - Request For Comment - The I-Beam

2011-03-18 Thread Bill Haskett
Bill: My wife has reminded me of this fact for years!I hardly know what the word "you" means anymore. :-) Bill On 3/18/2011 5:14 PM, Bill Brutzman wrote: I learned about the "I-Beam of Interpersonal Communications"

Re: [U2] Epicor and Eclipse Was Re: PICKSystems Administratorposition

2011-04-06 Thread Bill Haskett
John: Don't let weisenheimers scare you away. Most of us appreciate thoughtful contributions; of which, yours was one. :-) Bill - Original Message - *From:* jcar...@impactbuscon.com *To:* 'U2 Users List' *Date

Re: [U2] Databasic conversion

2011-04-06 Thread Bill Haskett
ot of emails on this, but the following is one in particular. HTH, Bill - Original Message - *From:* Bill Haskett *To:* 'Bob Little' *Date:* 2/28/2006 6:29 AM *Subject:* Re: [U2] Changes to mail list config

Re: [U2] Game changer for U2 editors ([AD] added for Doug)

2011-04-06 Thread Bill Haskett
Charlie: Why not try "PickWiki"? Bill - Original Message - *From:* cwn...@comcast.net *To:* U2 Users List *Date:* 4/6/2011 7:05 PM *Subject:* Re: [U2] Game changer for U2 editors ([AD] added for Doug) Hey Dubya (

Re: [U2] Databasic conversion

2011-04-07 Thread Bill Haskett
WRT the OP : As soon as I saw the question about D3 to Unidata I immediately thought of the years of pain to which Bill Haskett was subjected. From his experience I swore off ever porting to Unidata. YMMV Symeon, perhaps in another thread (or email) you could explain why a site feels a need to migrate

Re: [U2] Extreme slow down on Universe periodically

2011-04-08 Thread Bill Haskett
Curt: Try installing ProcessExplorer from Microsoft's SysInternals site... http://technet.microsoft.com/en-us/sysinternals/bb896653 This has solved a number of similar problems I've had with clients in the past. Most of these problems I trace down to a service that starts and is running with

Re: [U2] Case Sensitivity and Databasic conversion

2011-04-08 Thread Bill Haskett
wear at case-insensitivity, but I swear by it. WRT the OP : As soon as I saw the question about D3 to Unidata I immediately thought of the years of pain to which Bill Haskett was subjected. From his experience I swore off ever porting to Unidata. YMMV Symeon, perhaps in another thread (or em

Re: [U2] PDF Files directly from UniData or UniVerse

2011-04-12 Thread Bill Haskett
Doug: We've incorporated the PrintWizard PCL2PDF executable on our UniData server. Our application asks the user to generate a report, then asks them where to output the report when it's done. If the user selects a ".pdf" then a BASIC program runs the PW executable that converts the spooler

[U2] UniData memory errors

2011-04-17 Thread Bill Haskett
AccuTerm 2K2 on XP. I am, however, getting the errors using DesignBais. -- Bill Haskett */Advantos Systems, Inc./* 1042 N El Camino Real, Suite B305 Encinitas, CA 92024 ? Tel: 760-944-5570 (CA) | ? Fax: 760-655-1583 "What Software can be." ___

Re: [U2] UniData memory errors

2011-04-17 Thread Bill Haskett
Yes. All the accounts exist and they've been accessed via telnet for quite a while. This somehow seems like a Windows 7 error because I can replicate it using a Windows 7 machine loggin in via AccuTerm 7, from one machine, using the wireless network card. The other ones came from an unknown

Re: [U2] UniData memory errors

2011-04-18 Thread Bill Haskett
HM_LCINENTS = 100 (max 100 control entries / group) SHM_LPAGESZ = 8 (4K bytes / local page) SHM_FREEPCT = 25 SHM_NFREES = 1 SHM_FIL_CNT = 2048 N_FILESYS= 200 rm_pid = -1 rm_msqid = -1 rm_shmid = -1 Bill Haskett */Advantos Systems, Inc./* 1042 N El Camino Real, Suite B

Re: [U2] UniData memory errors

2011-04-18 Thread Bill Haskett
Oops. Sorry. I was sending this to myself. :-( Bill - Original Message - *From:* wphask...@advantos.net *To:* U2 Users List *Date:* 4/18/2011 2:49 AM *Subject:* Re: [U2] UniData memory errors C:\Users\wphaskett

Re: [U2] Saying Goodbye...

2011-04-28 Thread Bill Haskett
Say what!? The maximum count for a WG license is 24. It comes with device licensing included. The dealer cost is something like $225/user or $5,400 for a full license. Considering you can get a CPU license of SQL Server Standard for this kind of money, this isn't cheap! And it's the cheape

Re: [U2] Reliability doesn't raise enough issues to keep the list busy

2011-05-03 Thread Bill Haskett
Symeon: I think there are two problems here; closed platform, and deployment costs. You know how many times Kevin King was hoping to find a native connector to PHP. No response. How long did it take to get a .NET connectivity product? I can't find out a darned thing about the product (an

Re: [U2] uv v ud

2011-05-04 Thread Bill Haskett
Symeon: We use mv.NET with "uodotnet" and have seen various Windows errors. Tony G. indicated that mv.NET is just a wrapper for UO.NET, at this level, and the problem is with "uodotnet". We're running UD V7.1.9 in our production environment and "uodotnet.dll" v2.1.1.7211. I'm not a rocket

Re: [U2] uv v ud

2011-05-04 Thread Bill Haskett
st.net The views and opinions expressed herein are my own (Charlie Noah) and do not necessarily reflect the views, positions or policies of any of my former, current or future employers, employees, clients, friends, enemies or anyone else who might take exception to them. On 05-04-2011 10:49 AM, Bi

Re: [U2] uv v ud

2011-05-04 Thread Bill Haskett
continue to spend hours trying to debug UO potholes - I have no code and can't interpret logs. Bill shouldn't have to do that either. The people with the code should be supporting that component. Regards, T From: Bill Haskett An interesting side note is debugging. When technologists sug

[U2] XAdmin

2011-05-16 Thread Bill Haskett
Does the Eclipse-based XAdmin tool, provided by RS on the client CD, only work with UniData 7.2 and higher? I can't seem to connect to any UD v7.1 machines. Will I have to reinstall UniAdmin in order to access those machines? Thanks, Bill Ha

Re: [U2] XAdmin

2011-05-17 Thread Bill Haskett
s. Will I have to reinstall UniAdmin in order to access those machines? Thanks, Bill Haskett ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] XAdmin

2011-05-17 Thread Bill Haskett
already there. I didn't have time to take it any further. hth Colin Alfke Calgary, Canada - Original Message - *From:* wphaskett Does the Eclipse-based XAdmin tool, provided by RS on the client CD, only wor

Re: [U2] Pondering recent thread on compact framework

2011-05-19 Thread Bill Haskett
And now for a dose of reality... Consider the problem with Sony servers in the gaming environment. How in the world is a smaller MV company supposed to keep up with all of this technology blowing in the wind? This technology de'jour mentality puts us all out of business, because there's no w

[U2] [UD] Extract a line with a CR and/or LF character in it.

2011-05-25 Thread Bill Haskett
ark. Therefore, the REMOVE() function, READSEQ statements don't work (a single line is considered two lines), and FORMLIST/READNEXT don't work because the key is too long for a select list. Anyone know how to extract a line of a simple csv file that contains a CR and/or LF within the

Re: [U2] [UD] Extract a line with a CR and/or LF character in it.

2011-05-25 Thread Bill Haskett
't work because the key is too long for a select list. Anyone know how to extract a line of a simple csv file that contains a CR and/or LF within the line? Thanks, Bill Haskett _

Re: [U2] [UD] Extract a line with a CR and/or LF character in it.

2011-05-25 Thread Bill Haskett
I figured out how to do this. I read each line and use a subroutine to go through each character. It sets a variable 'QuoteOn' if we're in a quoted string. Obviously if the line ends while in a quoted string, the next line belongs to the current line. Man, what a pain this was! :-) Thanks

Re: [U2] [UD] Extract a line with a CR and/or LF character in it.

2011-05-26 Thread Bill Haskett
ave commas inside as well e.g. ,"field ""description,"" here", so you can not always just split on " or , Another alternative is to preprocess the csv using the linux tr command. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-

Re: [U2] [UD] Extract a line with a CR and/or LF character in it.

2011-05-26 Thread Bill Haskett
Programmer/Analyst Accounting/Data Division ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett [wphask...

Re: [U2] [UD] Extract a line with a CR and/or LF character in it.

2011-05-26 Thread Bill Haskett
point you have the entire line. On May 26, 2011, at 2:57 AM, Bill Haskett wrote: I figured out how to do this. I read each line and use a subroutine to go through each character. It sets a variable 'QuoteOn' if we're in a quoted string. Obviously if the line ends while in a

[U2] UniQuery Output to File

2011-06-02 Thread Bill Haskett
(Virtual Attribute) calling a BASIC subroutine. Any help would be appreciated. Thanks, Bill Haskett Advantos Systems, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UniQuery Output to File

2011-06-03 Thread Bill Haskett
O DELIM? -- TO [DELIM "char"] text_file Lists records to a UNIX text file. If you use the DELIM keyword, UniData places char between each attribute in text_file. text_file cannot be strictly numeric. On 6/2/2011 9:43 PM, Bill Haskett wrote: I can't remember how to send UniQuery

Re: [U2] UniQuery Output to File

2011-06-03 Thread Bill Haskett
Lists records to a UNIX text file. If you use the DELIM keyword, UniData places char between each attribute in text_file. text_file cannot be strictly numeric. On 6/2/2011 9:43 PM, Bill Haskett wrote: I can't remember how to send UniQuery output to a file. I've looked all throu

Re: [U2] Universe 11.1.2 list line limit

2011-06-06 Thread Bill Haskett
David: What you're saying is mostly true, totally true with older machines with .25Gb of memory, etc. Today I have an 8Gb notebook and opening a 40Mb file should be trivial in our development environment. It should be our developers who decide which tools to place into production, not the db

Re: [U2] SB Error

2011-06-07 Thread Bill Haskett
...and to see what processes are running, from another process with root permissions: PORT.STATUS PID CALL.STACK This is pretty useful when you need to find out what's running. HTH, Bill Haskett - Ori

Re: [U2] Installing UniObjects on Windows 2008 64 bit

2011-06-13 Thread Bill Haskett
Jim: I installed the U2 client from the "udt_7.2acl.zip" file onto Windows 2008 R2. It installed just fine. One thing I always do on Win 2008 R2 is run everything like this as "administrator". There is so much that can go wrong, and very few people know how to resolve permissions issues.

Re: [U2] Unidata command stack (history)

2011-06-13 Thread Bill Haskett
Jeff: The U2 command stack is completely neanderthal. I've been using UD for awhile and have ignored the U2 stack completely. I run a home-written shell. There's one on Pickwiki and I have one I'd be glad to give you. Here's some documentation on the U2 stack The UniData command stack sto

Re: [U2] UniData Triggers

2011-06-14 Thread Bill Haskett
Shaun: Remember, when you start going down the "trigger" path in UD, you may want to simply create two globally cataloged routines: U2.MASTER.TRIGGER.D U2.MASTER.TRIGGER.U ...or something like this. These two triggers simply "call" defined subroutines. We use a TRIGGER.CONF file like: 00

Re: [U2] Eclipse release 3.7 (Indigo)

2011-06-23 Thread Bill Haskett
G-Man: You __SHOULD__ advertise, as I'd never know what's up without guys like you, Doug, and others letting us know of their offerings. I'm not in the least offended by yours, and others, advertising, as I own a business and understand the need. Remember, if you get too much flack then FTI

Re: [U2] Adding capabilities in the sort term

2011-07-07 Thread Bill Haskett
Symeon: Maybe you could outline the reasons why it would be advantageous each way, and give a small example for each. It'd be an excellent PickWiki addition. The reason I say this is because most of us would like to try out this stuff starting out with very simple examples. Bill

Re: [U2] Found something interesting.....Bug or No Bug....that is my question?

2011-07-07 Thread Bill Haskett
I'm not sure about that. This, I believe, has always been the case. I've always had problems worrying about whether the 1st select returned anything; that's why I always do a SYSTEM(11) test after the initial select, and rarely use the trick of loading TCL commands into an array to execute al

Re: [U2] 2008 server and UNiverse Status command

2011-07-07 Thread Bill Haskett
I don't think I've ever seen U2 (or any Pick for that matter) crash and need a re-install when using it, unless there were serious hardware problems. Clearly, this is an issue for U2 support. Contact your support person at Rocket. HTH, Bill -

Re: [U2] Found something interesting.....Bug or No Bug....that is my question?

2011-07-07 Thread Bill Haskett
T FILENAME # "EXISTING_ID" 54 records selected to list 0. SELECT FILENAME = "EXISTING_ID" No data retrieved from current (S)SELECT statement. SELECT FILENAME # "EXISTING_ID" 54 records selected to list 0. select FILENAME "EXISTING_ID" REQUIRE.SELECT 1 records

Re: [U2] Interesting article

2011-07-12 Thread Bill Haskett
Symeon: I wonder if this implies that those who U2 are all database "gurus"? :-) Bill - Original Message - *From:* syme...@gmail.com *To:* 'U2 Users List' *Date:* 7/12/2011 1:31 AM *Subject:* [U2] Interesting art

Re: [U2] Interesting article

2011-07-12 Thread Bill Haskett
e up on that idea, very quickly! Bill - Original Message - *From:* 3xk547...@sneakemail.com *To:* u2-users@listserver.u2ug.org *Date:* 7/12/2011 12:46 PM *Subject:* Re: [U2] Interesting article From: Bill Haskett I wonder if this implies that those who U2 are all database "g

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-13 Thread Bill Haskett
Kevin: According to the BASIC manual: Description The UniBasic MATREADL command assigns the values found in successive attributes of a record to corresponding elements of a dimensioned array. MATREADL checks for locks and will not read a record locked with an exclusive (U) lock. If the record

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-14 Thread Bill Haskett
Symeon: Man...my modified optimistic update subroutine is at least 35 lines of code; which doesn't take into account managing the checksum variable. :-( Bill - Original Message - *From:* syme...@gmail.com *To:*

Re: [U2] Rocks

2011-07-14 Thread Bill Haskett
Jeff: "...and to us it's as easy as pie to develop in this environment." When Pick first came out the people who built the hundreds of business applications were business people, not techno-geeks, who somehow think C# is the be-all and end-all of computer languages. This should say it all.

Re: [U2] Why Pick U2 ?

2011-07-14 Thread Bill Haskett
Yea...and wouldn't it be nice of the TO.DELIM keyword in UniQuery worked! Bill - Original Message - *From:* charles_shaf...@ntn-bower.com *To:* U2 Users List *Date:* 7/14/2011 2:18 PM *Subject:* Re: [U2] Why Pick U

Re: [U2] Why Pick U2 ?

2011-07-15 Thread Bill Haskett
Charles: But, obviously, not technology to a technologist! :-) Bill - Original Message - *From:* charles_shaf...@ntn-bower.com *To:* U2 Users List *Date:* 7/15/2011 6:53 AM *Subject:* Re: [U2] Why Pick U2 ? [sni

[U2] LIST TO DELIM on Windows

2011-07-15 Thread Bill Haskett
+ From: Wally Terhune To: Bill Haskett I’m pretty buried in other stuff at the moment. It would be helpful if you created a small account and added the file with the 1 record, the dict, the test BP. Nothing obvious jumps out at me. I was mostly reacting to the blanket statement

Re: [U2] SELECT question, paginated select.

2011-07-20 Thread Bill Haskett
Chris: I'm betting the solution also needs indexing, because you want to pick up where the last list left off and you don't want to wait for a select to return to save the list. So, SAMPLE isn't really a solution but indexing is. We do this all the time, but we have to use indexing. In fac

Re: [U2] SELECT question, paginated select.

2011-07-20 Thread Bill Haskett
Chris: For instance, we have checks file. A number of our clients have over a million records in the file. It's indexed on vendor no. and check date. The index would look like: 00CAPGE15857 (7 digit vendor and 5 digit date) This is a left justified so it's easy to sort and select. I can

Re: [U2] SELECT question, paginated select.

2011-07-20 Thread Bill Haskett
Chris: Indexes aren't created by default. The @ID is hashed into the file which allows you to retrieve an item via the @ID with a single disk read. To index, you need to create a dictionary. I create all our index dictionaries as "INDEX_{n}" (e.g. INDEX_1, INDEX_2, etc). They're I-Descrip

Re: [U2] udt dir file max key length

2011-07-22 Thread Bill Haskett
Really! My machine looks like: 5 Dev (0)-> LIMIT U_MAXFNAME: File name limit = 118. Windows 2008 R2 and UD v7.2.7 If this isn't configurable, as Wally says, I wonder what accounts for the difference between our two environments? Bill -

[U2] Login Abort

2011-08-02 Thread Bill Haskett
Faulting module path: unknown Report Id: 8227d383-bd53-11e0-b65c-b8ac6f7d8d12 Does anybody know what this is all about? Thanks in advance. Bill Haskett ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] UD - Triggers

2011-08-15 Thread Bill Haskett
Did anyone know that when one creates a trigger for a multi-level file, and references the full file to delete or update a record, the triggers _DON'T_ work. e.g. CUSTOMERFILE + NEWCUST + PREVCUST If I delete the "CUSTOMERFILE,CUSTOMERFILE" triggers don't work but they do if I dele

Re: [U2] UD - Triggers

2011-08-16 Thread Bill Haskett
cause there isn't one set up at the partition level. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: 15 August 2011 19:37 To: U2 Mail List Subject: [U2] UD - Triggers Did anyone know that wh

Re: [U2] UD - Triggers

2011-08-17 Thread Bill Haskett
as long as you have the trigger on CUSTOMER. LIST.TRIGGER CUSTOMER and LIST.TRIGGER CUSTOMER,CUSTOMER are the same. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: 16 August 2011 20:25 To: U2 Users Li

Re: [U2] UniVerse backups to disk

2011-08-20 Thread Bill Haskett
That's what I like... "As others have mentioned, you can pause the database. If you've got a mirror then DBPAUSE the database, break the mirror, and DBRESUME. " Sounds so simple yet can be so complex and expensive. There are so many "ifs" with the term "break the mirror" it's not much of a w

Re: [U2] UniVerse backups to disk

2011-08-20 Thread Bill Haskett
otting for a clean backup with less than 10 seconds of downtime: Dbpause Sleep few (3-5) seconds File system snapshot (5 seconds or so) Dbresume Backup from snapshot Trash snapshot Only cost in this is enough disk for snapshot. Jeff Butera Sent from my iPhone On Aug 20, 2011, at 1:51 PM, Bi

Re: [U2] Stuck getting started with DataVu

2011-08-24 Thread Bill Haskett
Harold: I thought this'd be great but with UD I had to do all that ODBC crap! Not interested in reconfiguring my entire hosting accounts for this. So much for simple access to a U2 (UD) account. Sometimes I don't understand why there's an assumption users only have one (1) production accou

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Bill Haskett
fight with all that this entails. Are you sure I misunderstood this? Thanks, Bill Haskett - Original Message - *From:* slestak...@gmail.com *To:* U2 Users List *Date:* 9/2/2011 9:47 AM *Subject:* Re: [U2] DataVu

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Bill Haskett
options I've been looking into. Bill - Original Message - *From:* slestak...@gmail.com *To:* U2 Users List *Date:* 9/2/2011 10:14 AM *Subject:* Re: [U2] DataVu Query [ad] On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskett wrote:

Re: [U2] DataVu Query

2011-09-07 Thread Bill Haskett
:-) Bill Haskett - Original Message - *From:* jscha...@gmail.com *To:* U2 Users List *Date:* 9/7/2011 7:38 AM *Subject:* Re: [U2] DataVu Query I've managed to get this installed, define a "

Re: [U2] Move UniVerse Data from 32 bit server to 64 bit server

2011-09-08 Thread Bill Haskett
With respect to UniData, we moved from Windows 2003 Server to Windows 2008 R2. I had to upgrade to UniData v7.2.7 and they fixed a permissions problem in STARTPTR (I think). Other than that, everything worked as it had previously. I suspect UV is the same thing. Contact Rocket to find out w

[U2] UD IPC logs

2011-09-12 Thread Bill Haskett
No EDA.. 7.2 No 727 I've been scrounging around in the old UD manuals to try to figure this out but can't seem to isolate what's up. Does anyone have an idea? Thanks, Bill Haskett ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UD IPC logs

2011-09-12 Thread Bill Haskett
il: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, September 12, 2011 6:15 PM To: U2 Mail List Subject: [U2] UD IPC logs I've bee

Re: [U2] Job scheduling in UniVerse

2011-09-13 Thread Bill Haskett
I have a simple BASIC program I "phantom" off when Windows starts (and UD has been started). This does __NOT__ use a UD license. This program reads a UD "services" file for information and will "logto" then "phantom" a specific program. This is simple and home-grown and might be something yo

Re: [U2] Start job on Universe boot under Windows

2011-09-13 Thread Bill Haskett
I have no idea why the U2 products don't have this capability; then these things would run every time U2 starts! Instead, we have to futz around with the O/S and if we restart U2, without restarting the O/S, then these things have to be manually started. I've gotten used to the idea that if I

Re: [U2] Start job on Universe boot under Windows

2011-09-13 Thread Bill Haskett
ipt and you can add commands to the bottom. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: 13 September 2011 17:45 To: U2 Users List Subject: Re: [U2] Start job on Universe boot under Windows I

Re: [U2] The math just doesn't work.

2011-09-29 Thread Bill Haskett
I tried this on UD v7.2.7 on Windows 2008 R2. I added the following code at the top of George's code: EXECUTE \SET.WIDEZERO 0.001\ This is what I got... 2 Dev (0)->RUN BP BILL (A+B) = C? YOU ROCK A = 4096.9, B = 106.19, (A+B) = 4203.09, C = 4203.09 2 Dev (0)-> Bill -

Re: [U2] The math just doesn't work.

2011-10-10 Thread Bill Haskett
Brett: When I run the following code on UD v7.2.7, it works fine. * ** Test program EXECUTE \SET.WIDEZERO 0.01\ * NUL = '' CM = ',' A = -409071.8775: CM: 475000: CM: -652413: CM: 652413: CM: -475000: CM: 409071.8775 * TEST.VMC = 1 TEST.TOTAL = 0 * LOOP UNTIL FIELD(A, CM, TEST.VMC) = NUL DO

Re: [U2] Finding Triggers on files

2011-10-10 Thread Bill Haskett
Dean: This is interesting to know! 2 Dev (0)-> BPTEST OPEN '', 'ARTMASTER' TO ARTMASTER ELSE STOP 201, 'ARTMASTER' ; CRT FILEINFO(ARTMASTER, 25) ; CRT FILEINFO(ARTMASTER, 26) ; END Compiling Unibasic: SAVEDLISTS\BpTest_487376561 in mode 'p'. compilation finished U2.MASTER.TRIGGER.U U2.MASTER

Re: [U2] SB Icons

2011-10-14 Thread Bill Haskett
John: Try the following: http://www.howtogeek.com/howto/windows-vista/easily-disable-vistas-aero-before-running-an-application-such-as-a-video-game/ HTH, Bill - Original Message - *From:* johnisr...@daytonsuperio

Re: [U2] UniBasic Question

2011-10-24 Thread Bill Haskett
Kebbon: I've converted our application from D3 to UniData. There were a number of issues with the Heading statement and, if I remember correctly, wouldn't allow me to do what you're trying. Fortunately, we already had a "scrolling" program to pass output into so this didn't cause problems.

[U2] UD Re-indexing

2011-11-01 Thread Bill Haskett
ppening here and why I'm getting a "permissions" error? Things I didn't try; reload Windows, reinstall UniData, deleting and re-creating the data file. Thanks, Bill Haskett ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UD Re-indexing

2011-11-01 Thread Bill Haskett
e PSTools to find it. When you delete.index ... ALL it actually deletes the X_... file so you get this message if someone has it open. hth Colin Alfke Calgary, Canada -Original Message- From: Bill Haskett I run UD v7.2.7 on a Windows 2008 R2 machine. I've an account that has admini

Re: [U2] [ot] A/P Dos 5.2.7 install on Windows 7?

2011-11-21 Thread Bill Haskett
Does CDP still have traffic? Will wonders never cease! :-) Bill - Original Message - *From:* 3xk547...@sneakemail.com *To:* u2-users@listserver.u2ug.org *Date:* 11/21/2011 3:27 PM *Subject:* Re: [U2] [ot] A/P Dos

Re: [U2] Unidata 7.1 Unresponsive UO Connection

2011-12-01 Thread Bill Haskett
Symeon: Your "pooling" connection is set up for a single dbms account, correct? You'd need a separate "pooling" license for each dbms account to access, correct? That is some dance you need to go through to do what, basically, the computer is supposed to do! Bill

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