RE: [U2] UV objects question

2008-06-03 Thread Les Hewkin
We found the best way is to have all the logic in databasic. Call a subroutine to return the data you want. This can be tested before it is used within VB. Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Rye Hill House T 01604 592289 M 07917 856195 -Original

RE: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD

2008-06-03 Thread Bill Haskett
Jak: This worked fine for me in an EVAL. UD v7.1 in Win 2K3 with ECLTYPE = Pick. :list APOPEN ACCTS AMTS EVAL DCOUNT(EXTRACT(@RECORD, 9, 0, 0), @VM) COL.HDG Cnt APOPEN ACCT. ACCT/AMTS Cnt... 69*7 2090270.06 1 830*38779 3060120.64 2 3070

[U2] Can the catalog space get full?

2008-06-03 Thread Dennis Bartlett
We're having weird issues here where programs that have worked forever are suddenly being reported as UNABLE TO LOAD XYZ. Indiviually cataloging the programs fixes the problem. I'm not sure each time what the original method of cataloging was so I'm simply doing a local catalog. The problem

Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD

2008-06-03 Thread Jeff Butera
Jeff, what actually worked was... DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) Yeah - I mixed the syntax for EXTRACT with that for FIELD. doesn't seem to work in an EVAL though eg LIST STK EVAL DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) A30 jak - Original Message - From: John Kent [EMAIL

[U2] wsdl

2008-06-03 Thread Jeff
Are there any implementations of a unibasic program calling web service (jax-ws)? Our desire is to connect a SBClient screen to a web service interface hosted at one of our vendors. TIA --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit

[U2] HP Laserjets and AIX/Unix

2008-06-03 Thread rogu2
Looks like HP has discontinued the 4240, 4250, 4350 LaserJets and their various tnd models and replaced them with various models P4014, P4015 and P4515 with some new letters. While we can still find leftovers of the old models, it is only a matter of time. The only Supported operating

[U2] Windows Unidata -- adding users?

2008-06-03 Thread Mark Thornton
Good morning from Central Texas, I am trying to understand the ODBC connectivity with Unidata. I am having problems with privileges assigned to tables and views in my 6.0 production Unix version so I installed the 7.1 Windows personal version to do some testing with. Now I can't determine how to

Re: [U2] Can the catalog space get full?

2008-06-03 Thread Wally Terhune
For UniData: B' $UDTBIN/sbcsprogs displays active shared programs B' Size of each segment is set in udtconfig SBCS_SHM_SIZE B' $UDTBIN/ipcstat bmb | grep sbcs b Lists all sbcs segments. B' udt processes attach sbcs segments as needed b Depends on which segments

RE: [U2] wsdl

2008-06-03 Thread Symeon Breen
Hi yes - take a look at the unibasic extensions manual for the http and soap client functions. If you want an example I can provide some. Rgds Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Sent: 03 June 2008 13:39 To:

RE: [U2] HP Laserjets and AIX/Unix

2008-06-03 Thread JPB-U2UG
Seems strange that HP would have done that since they have their own 'nix, HP-UX. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 9:36 AM

[U2] Unidata 7.1 ODBC Threading Problems?

2008-06-03 Thread Kevin King
Is the Unidata 7.1 ODBC driver thread/process safe? As I've written in previous posts, one of my customers has this Zeacom phone system that has the ability to call a (VBScript) script to gather information from a back-end database so that it can display that information for a customer service

RE: [U2] HP Laserjets and AIX/Unix

2008-06-03 Thread Drew Henderson
The 4250 doesn't have *nix listed as a supported operating system, either. Since you're probably just sending plain text or embedding your own PCL commands, I would expect it to work ok. I suspect the supported is really referring to the interoperability of the printer with the OS (Hi, I'm an HP

[U2] re:form multiple spreadsheets excel file in universe

2008-06-03 Thread Irina Lissok
Hi everyone, We have the program which runs and creates separate excel files for relational data. We want to put all this data in one file but on separate work sheets. Does anyone know how we can implement it? Irina Lissok. --- u2-users mailing list u2-users@listserver.u2ug.org To

RE: [U2] wsdl

2008-06-03 Thread Jeff Powell
o;?Symeon, My manual (Version 6.0) don't have any reference to SOAP. Is this UV only? I have Unidata ver 6.1.15. Thanks. On Tue, 2008-06-03 at 15:19 +0100, Symeon Breen wrote: Hi yes - take a look at the unibasic extensions manual for the http and soap client functions. If you want an

[U2] Wellington, New Zealand User Group

2008-06-03 Thread David Murray
I have recently moved back to Wellington. Anyone interested in getting together informally or even formally to establish a user group around U2? You can email here or contact me directly if interested. Cheers, David Murray [EMAIL PROTECTED] --- u2-users mailing list

Re: [U2] re:form multiple spreadsheets excel file in universe

2008-06-03 Thread rogu2
Import each excel file on a separate tab? - Original Message - From: Irina Lissok Date: Tuesday, June 3, 2008 5:32 pm Subject: [U2] re:form multiple spreadsheets excel file in universe To: u2-users@listserver.u2ug.org Hi everyone, We have the program which runs and creates separate

Re: [U2] wsdl

2008-06-03 Thread Kevin King
You should be able to find some info in the UniBASIC Extensions manual for 6.1. On Tue, Jun 3, 2008 at 2:42 PM, Jeff Powell [EMAIL PROTECTED] wrote: o;?Symeon, My manual (Version 6.0) don't have any reference to SOAP. Is this UV only? I have Unidata ver 6.1.15. Thanks. On Tue,

Re: [U2] re:form multiple spreadsheets excel file in universe

2008-06-03 Thread Kevin King
You can use Excel's XML features to create one sheet that has multiple tabs, colors, formulae, etc. Warning, however, it's complicated. Create a sheet in Excel and save it as XML and you'll see the basic structure of the document. I used to have a link to a page @ Microsoft that described the

Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD

2008-06-03 Thread John Kent
Bill, not for me though LIST STK EVAL DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) 09:01:48 04 Jun 2008 1 STK... Illegal attribute: select criteria EVAL is not a field. whereas an itype will ED DICT STK JAK Top of JAK in DICT STK, 6 lines, 50 characters. 001: I 002:

Re: [U2] Is there a UNIDATA equivalent of Universe Itype

2008-06-03 Thread Thomas Derwin
Hi, Note that in Bill's example, he typed list in *lower-case*. That's why it worked. If you're running ECLTYPE P (Pick mode) and you issue Unidata commands in lower-case, the commands will run using ECLTYPE U, which is required to use EVAL. This (possibly undocumented) feature is a great way to

RE: [U2] re:form multiple spreadsheets excel file in universe

2008-06-03 Thread Ross Ferris
Depends a lot on HOW you are getting data into the spreadsheet in the first place -- we normally just use script the DOM to go create new worksheets, load data etc -- if your current mechanism is simply to write flat data out to a text file, then you are likely to have more of a problem ... or

Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD

2008-06-03 Thread Wally Terhune
John Kent wrote: LIST STK EVAL DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) 09:01:48 04 Jun 2008 1 STK... Illegal attribute: select criteria EVAL is not a field. whereas an itype will ED DICT STK JAK Top of JAK in DICT STK, 6 lines, 50 characters. 001: I 002: DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) 003:

Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD

2008-06-03 Thread Don Verhagen
John, Try using lower case list, this will force ECLTYPE U (Unidata) flavor. Don Verhagen - Original Message - From: John Kent [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, June 03, 2008 6:41 PM Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype

Re: [U2] Is there a UNIDATA equivalent of Universe Itype

2008-06-03 Thread John Kent
Tom, at last it makes sense jak - Original Message - From: Thomas Derwin [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, June 04, 2008 10:02 AM Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype Hi, Note that in Bill's example, he typed list in

RE: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD

2008-06-03 Thread Bill Haskett
Jak: Are you in Pick mode or UniData mode at TCL? If in Pick mode the verb should be lower-cased list. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of John Kent Sent: Tuesday, June 03, 2008 3:41 PM To: u2-users@listserver.u2ug.org

Re: [U2] wsdl

2008-06-03 Thread Jeff Powell
Thanks Kevin, I downloaded the 6.1 series from IBM and it is in there. On Tue, 2008-06-03 at 16:08 -0600, Kevin King wrote: You should be able to find some info in the UniBASIC Extensions manual for 6.1. On Tue, Jun 3, 2008 at 2:42 PM, Jeff Powell [EMAIL PROTECTED] wrote: o;?Symeon,