[U2] Just testing
It's very quiet.. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Just testing (O.T.)
And dark too, might we be eaten by a Grue? John J. Wahl Employee Owner Programmer / Analyst Tel: (888) 465-6737 Ext. 120 Fax: (330) 342-3896 Email: jw...@joseph.com Web: http://www.Joseph.com/ -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Monday, May 10, 2010 11:59 To: 'U2 Users List' Subject: [U2] Just testing It's very quiet.. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Just testing (O.T.)
'Twas brillig and the slythy tothes... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John J. Wahl Sent: Monday, May 10, 2010 9:04 AM To: U2 Users List Subject: Re: [U2] Just testing (O.T.) And dark too, might we be eaten by a Grue? John J. Wahl Employee Owner Programmer / Analyst Tel: (888) 465-6737 Ext. 120 Fax: (330) 342-3896 Email: jw...@joseph.com Web: http://www.Joseph.com/ -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Monday, May 10, 2010 11:59 To: 'U2 Users List' Subject: [U2] Just testing It's very quiet.. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [ad] XLr8Editor Updates, still $49.00 [/ad]
Among other things, we have fixed the outline not refreshing. This allows you to see what labels and now variables are contained in the program. You can click on either the outline or the variable name to see where it occurs in your code. We could not stop there. We add more color definition. Even the labels can be color coded now. Here is the full list of for 2.9.3: v2.9.3 - May 9, 2010 Bugzilla 257 - Outline fails to update. 1) Fixed. Bugzilla 258 - Outline needs to show variables. 1) Outline view now shows Labels (definition) and Variables (first use and list of references in sub item). 2) Added preferences to control syntax color and text style. Bugzilla 262 - Source folding annotation labels not working. 1) Fixed. Bugzilla 261 - U2 Preferences should have Formatting options as well. 1) Moved formatting preferences to U2 Preferences page. Moved Use FORMAT on UniVerse option out of AE format options. 2) Made lock check off by default. Regards, U2logic Team www.u2logic.com/tools.html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Soap error question
Sorry for the delay in my response, I was out of the office for the last week. It turns out that the problem was that I was calling a subroutine in my program and that doesn't work with soap. So, I included the subroutine's logic into the Basic program and it works now. Bruce -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Joshua Gallant Sent: Monday, May 03, 2010 11:33 AM To: U2 Users List Subject: Re: [U2] Soap error question I haven't worked a ton with SOAP requests but figured I'd throw this out there any how... Do you have a permissions error preventing a write? It seems most of what you've mentioned that's working are just reads but the one that write is failing. - Josh -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Friday, April 30, 2010 6:13 PM To: u2-users@listserver.u2ug.org Subject: [U2] Soap error question Hi All, We have a strange result happening with a simple soap service call and I was hoping someone has seen this problem or something like it before. We have 3 different soap calls: SSN.VERF, SSN.VERF.SUP SSN.SUBMIT. Each program has 2 inputs: CUST.NO SSN and 1 output: VERIFY. The first one: SSN.VERF is a program on UniData that accepts Cust.No last-4 of SSN. The program then reads the customer record and validates that the last 4 of that customer's SSN match the 4 digits sent in the transmission. If they match then it returns a 1 in the variable called VERIFY. Otherwise, it returns a 0 (zero) in VERFIY. SSN.VERF.SUP: Is for supervisors to send the whole 9-digit SSN and have it verified as well with the same VERIFY variable being passed back. SSN.SUBMIT: Is for adding the SSN to the customer's record if it does not already exist. It checks for the existence in the record and in the cross-reference file and returns 1 if the update was successful and zero otherwise. Now for the problem: SSN.VERF SSN.VERF.SUP both work as expected. SSN.SUBMIT appears to work when it is for an invalid entry (the SSN is already on file) but whenever a valid SSN is entered for a customer with a blank SSN field it fails with a strange error message, like this: soapenv:Envelope xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/; xmlns:soapenc=http://schemas.xmlsoap.org/soap/encoding/; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; soapenv:Body soapenv:Fault faultstringException: Internal Web Service Server Error/faultstring detail UniSOAPException errorException: Internal Web Service Server Error/error /UniSOAPException /detail /soapenv:Fault /soapenv:Body /soapenv:Envelope Can anyone suggest how we could debug this problem? Is there a way to capture whatever it is that is freaking out the soap process? TIA, Bruce Lunt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Printing images
All: In Universe I am able to use PCL commands to customize printing, fonts, spacing, orientation, etc. I'm sure many of you do this. For example by issuing CHAR(27):'(10U':CHAR(27):'(s1p09v0s6b16602T' in front of text the printing is Arial 9 bold. However, I have been unable to figure out how to print images from within Universe. Something to do with 'bit map', but I can't seem to get it. I have a file containing JPG format images. I can copy a record from this file to a windows directory and easily display the image using windows tools. But, how to get the same binary sent to a printer and print that image? Has anyone been able to do this? Thanks! Harold Harold D. Oaks Sr. Analyst/Programmer Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Printing images
A long time ago, someone shared a way of doing this. Here is what I can recollect... * Create BitMap image * Place image On a document in desired position (ie msword) * Create a new print to File printer using HP PCL type driver * Print document * Using a hex editor, delete last x number of characters * Determine x by starting at the end and locating *rB. Everything * after that is printer reset string. (escEesc%-12345X...) * Save image file from the previous step to a directory accessible from your program * Open and print each line from previous step * sourcepath='/blablabla/':LOGO.ID * openseq sourcepath to file then * loop * readseq line from file else li...@am * until li...@am do * print line * repeat * closeseq file * end Pretty rough but I remember that it was functional. HTH - Original Message - From: Harold Oaks harold.o...@clark.wa.gov To: U2 Users List u2-users@listserver.u2ug.org Sent: Monday, May 10, 2010 2:00:35 PM GMT -06:00 US/Canada Central Subject: [U2] Printing images All: In Universe I am able to use PCL commands to customize printing, fonts, spacing, orientation, etc. I'm sure many of you do this. For example by issuing CHAR(27):'(10U':CHAR(27):'(s1p09v0s6b16602T' in front of text the printing is Arial 9 bold. However, I have been unable to figure out how to print images from within Universe. Something to do with 'bit map', but I can't seem to get it. I have a file containing JPG format images. I can copy a record from this file to a windows directory and easily display the image using windows tools. But, how to get the same binary sent to a printer and print that image? Has anyone been able to do this? Thanks! Harold Harold D. Oaks Sr. Analyst/Programmer Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Printing images
Harold Forgive me if I take this step by step. A JPEG is a compressed image format, one that is understood by Windows and some other platforms. But it's not understood directly by printers. You can convert it to a bitmap (in fact, Windows does this internally when it renders it) which represents an image as a series of bits, with the header defining how those bits make up the image: the size of the image, the number of bits required to represent each color, possible color map etc. But the only reason Windows understands that this is an image, is because it looks at the file extension and because it can read and interpret the header and content. So Windows will display it. Windows will also print it, because it runs printers in graphics mode over a subsystem called GDI (Graphics Device Interface). This effectively defines an API through which Windows can make its font and graphics calls, such as Rectangle, Ellipse, DrawText and image placement. Each printer driver is responsible to translating these calls into whatever underlying instructions make sense to that style and make of printer. In other words, the printer itself does not generally understand the same image formats as Windows. Only the printer driver understands those and converts them into something the printer will understand. Now to add to the confusion, printers generally run in either text mode or graphics mode. Windows runs your printers in graphics mode so any font, for example, is actually rendered as the picture of the font. UniVerse, being text based, runs the printer in text mode so that you need escape sequences like PCL to do primitive font handling and line printing operations - just like a terminal. But unless you want to play with the raster formats in PCL, or roll your own instructions in the graphics language, if you want to print images you need to either: a) print the image under Windows and capture the output from the driver that would normally be streamed to the printer. This is possible but you can't then easily modify it. b) use some translation software that can be driven from UniVerse but actually renders images, fonts etc under Windows (or equivalent). mvPDF and PrintWizard will both do that, as may other software. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: 10 May 2010 8:01 PM To: U2 Users List Subject: [U2] Printing images All: In Universe I am able to use PCL commands to customize printing, fonts, spacing, orientation, etc. I'm sure many of you do this. For example by issuing CHAR(27):'(10U':CHAR(27):'(s1p09v0s6b16602T' in front of text the printing is Arial 9 bold. However, I have been unable to figure out how to print images from within Universe. Something to do with 'bit map', but I can't seem to get it. I have a file containing JPG format images. I can copy a record from this file to a windows directory and easily display the image using windows tools. But, how to get the same binary sent to a printer and print that image? Has anyone been able to do this? Thanks! Harold Harold D. Oaks Sr. Analyst/Programmer Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.819 / Virus Database: 271.1.1/2864 - Release Date: 05/09/10 19:26:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Soap error question
What? You can't make a SOAP call to a U2 program if that program has a CALL in it? Bill Lunt, Bruce said the following on 5/10/2010 11:53 AM: Sorry for the delay in my response, I was out of the office for the last week. It turns out that the problem was that I was calling a subroutine in my program and that doesn't work with soap. So, I included the subroutine's logic into the Basic program and it works now. Bruce -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Joshua Gallant Sent: Monday, May 03, 2010 11:33 AM To: U2 Users List Subject: Re: [U2] Soap error question I haven't worked a ton with SOAP requests but figured I'd throw this out there any how... Do you have a permissions error preventing a write? It seems most of what you've mentioned that's working are just reads but the one that write is failing. - Josh -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Friday, April 30, 2010 6:13 PM To: u2-users@listserver.u2ug.org Subject: [U2] Soap error question Hi All, We have a strange result happening with a simple soap service call and I was hoping someone has seen this problem or something like it before. We have 3 different soap calls: SSN.VERF, SSN.VERF.SUP SSN.SUBMIT. Each program has 2 inputs: CUST.NO SSN and 1 output: VERIFY. The first one: SSN.VERF is a program on UniData that accepts Cust.No last-4 of SSN. The program then reads the customer record and validates that the last 4 of that customer's SSN match the 4 digits sent in the transmission. If they match then it returns a 1 in the variable called VERIFY. Otherwise, it returns a 0 (zero) in VERFIY. SSN.VERF.SUP: Is for supervisors to send the whole 9-digit SSN and have it verified as well with the same VERIFY variable being passed back. SSN.SUBMIT: Is for adding the SSN to the customer's record if it does not already exist. It checks for the existence in the record and in the cross-reference file and returns 1 if the update was successful and zero otherwise. Now for the problem: SSN.VERF SSN.VERF.SUP both work as expected. SSN.SUBMIT appears to work when it is for an invalid entry (the SSN is already on file) but whenever a valid SSN is entered for a customer with a blank SSN field it fails with a strange error message, like this: soapenv:Envelope xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/; xmlns:soapenc=http://schemas.xmlsoap.org/soap/encoding/; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; soapenv:Body soapenv:Fault faultstringException: Internal Web Service Server Error/faultstring detail UniSOAPException errorException: Internal Web Service Server Error/error /UniSOAPException /detail /soapenv:Fault /soapenv:Body /soapenv:Envelope Can anyone suggest how we could debug this problem? Is there a way to capture whatever it is that is freaking out the soap process? TIA, Bruce Lunt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Soap error question
I don't believe that is correct. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, 11 May 2010 8:45 a.m. To: U2 Mail List Subject: Re: [U2] Soap error question What? You can't make a SOAP call to a U2 program if that program has a CALL in it? Bill Lunt, Bruce said the following on 5/10/2010 11:53 AM: Sorry for the delay in my response, I was out of the office for the last week. It turns out that the problem was that I was calling a subroutine in my program and that doesn't work with soap. So, I included the subroutine's logic into the Basic program and it works now. Bruce -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Joshua Gallant Sent: Monday, May 03, 2010 11:33 AM To: U2 Users List Subject: Re: [U2] Soap error question I haven't worked a ton with SOAP requests but figured I'd throw this out there any how... Do you have a permissions error preventing a write? It seems most of what you've mentioned that's working are just reads but the one that write is failing. - Josh -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Friday, April 30, 2010 6:13 PM To: u2-users@listserver.u2ug.org Subject: [U2] Soap error question Hi All, We have a strange result happening with a simple soap service call and I was hoping someone has seen this problem or something like it before. We have 3 different soap calls: SSN.VERF, SSN.VERF.SUP SSN.SUBMIT. Each program has 2 inputs: CUST.NO SSN and 1 output: VERIFY. The first one: SSN.VERF is a program on UniData that accepts Cust.No last-4 of SSN. The program then reads the customer record and validates that the last 4 of that customer's SSN match the 4 digits sent in the transmission. If they match then it returns a 1 in the variable called VERIFY. Otherwise, it returns a 0 (zero) in VERFIY. SSN.VERF.SUP: Is for supervisors to send the whole 9-digit SSN and have it verified as well with the same VERIFY variable being passed back. SSN.SUBMIT: Is for adding the SSN to the customer's record if it does not already exist. It checks for the existence in the record and in the cross-reference file and returns 1 if the update was successful and zero otherwise. Now for the problem: SSN.VERF SSN.VERF.SUP both work as expected. SSN.SUBMIT appears to work when it is for an invalid entry (the SSN is already on file) but whenever a valid SSN is entered for a customer with a blank SSN field it fails with a strange error message, like this: soapenv:Envelope xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/; xmlns:soapenc=http://schemas.xmlsoap.org/soap/encoding/; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; soapenv:Body soapenv:Fault faultstringException: Internal Web Service Server Error/faultstring detail UniSOAPException errorException: Internal Web Service Server Error/error /UniSOAPException /detail /soapenv:Fault /soapenv:Body /soapenv:Envelope Can anyone suggest how we could debug this problem? Is there a way to capture whatever it is that is freaking out the soap process? TIA, Bruce Lunt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Soap error question
What I was doing was calling an SB+ process from within the program and that is what caused the non-action. Bruce -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, May 10, 2010 1:39 PM To: U2 Mail List Subject: Re: [U2] Soap error question What? You can't make a SOAP call to a U2 program if that program has a CALL in it? Bill Lunt, Bruce said the following on 5/10/2010 11:53 AM: Sorry for the delay in my response, I was out of the office for the last week. It turns out that the problem was that I was calling a subroutine in my program and that doesn't work with soap. So, I included the subroutine's logic into the Basic program and it works now. Bruce -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Joshua Gallant Sent: Monday, May 03, 2010 11:33 AM To: U2 Users List Subject: Re: [U2] Soap error question I haven't worked a ton with SOAP requests but figured I'd throw this out there any how... Do you have a permissions error preventing a write? It seems most of what you've mentioned that's working are just reads but the one that write is failing. - Josh -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Friday, April 30, 2010 6:13 PM To: u2-users@listserver.u2ug.org Subject: [U2] Soap error question Hi All, We have a strange result happening with a simple soap service call and I was hoping someone has seen this problem or something like it before. We have 3 different soap calls: SSN.VERF, SSN.VERF.SUP SSN.SUBMIT. Each program has 2 inputs: CUST.NO SSN and 1 output: VERIFY. The first one: SSN.VERF is a program on UniData that accepts Cust.No last-4 of SSN. The program then reads the customer record and validates that the last 4 of that customer's SSN match the 4 digits sent in the transmission. If they match then it returns a 1 in the variable called VERIFY. Otherwise, it returns a 0 (zero) in VERFIY. SSN.VERF.SUP: Is for supervisors to send the whole 9-digit SSN and have it verified as well with the same VERIFY variable being passed back. SSN.SUBMIT: Is for adding the SSN to the customer's record if it does not already exist. It checks for the existence in the record and in the cross-reference file and returns 1 if the update was successful and zero otherwise. Now for the problem: SSN.VERF SSN.VERF.SUP both work as expected. SSN.SUBMIT appears to work when it is for an invalid entry (the SSN is already on file) but whenever a valid SSN is entered for a customer with a blank SSN field it fails with a strange error message, like this: soapenv:Envelope xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/; xmlns:soapenc=http://schemas.xmlsoap.org/soap/encoding/; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; soapenv:Body soapenv:Fault faultstringException: Internal Web Service Server Error/faultstring detail UniSOAPException errorException: Internal Web Service Server Error/error /UniSOAPException /detail /soapenv:Fault /soapenv:Body /soapenv:Envelope Can anyone suggest how we could debug this problem? Is there a way to capture whatever it is that is freaking out the soap process? TIA, Bruce Lunt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Listing via the SQL Interface...
Greetings All, Platform: UniVerse Version: 10.2.x O.S.: Windows Server 2008 (x86) 32-bit I'm wondering if there a way to get a listing of READU locks (exactly like the Verb LIST.READU, but via an SQL interface? I was going through the documents and old forum posts, but I do not see anything. Thank you for your time, -- John J. Wahl Employee Owner Programmer / Analyst Tel: (888) 465-6737 Ext. 120 Fax: (330) 342-3896 Email: jw...@joseph.com Web: http://www.Joseph.com/ ED VOC Record name = LIST.READU 4 lines long. : 0001: V : 0002: list_readu : 0003: E : 0004: BG Bottom at line 4. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Listing via the SQL Interface...
[ad] I'm not sure what SQL tools you're talking about but with mv.NET you can easily call BASIC subroutines from ADO.NET as though they were Stored Procedures. So wrap LIST.READU in a program, format the output the way you want and call it like a sproc. If you just want this data outside and you're thinking you need to do it with SQL, that's not correct. If you can describe the client-side environment maybe we can provide a more elegant method of delivering the data. Any help? Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET worldwide and provides related development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno From: John J. Wahl Platform: UniVerse Version: 10.2.x O.S.: Windows Server 2008 (x86) 32-bit I'm wondering if there a way to get a listing of READU locks (exactly like the Verb LIST.READU, but via an SQL interface? I was going through the documents and old forum posts, but I do not see anything. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Listing via the SQL Interface...
Remember the LIST.READU INTERNAL format to get a dynamic array... unfortunately it is row based rather than column based otherwise you could have probably created a dictionary to decompose the data as sets of related multivalues ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Tuesday, 11 May 2010 4:00 p.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Listing via the SQL Interface... [ad] I'm not sure what SQL tools you're talking about but with mv.NET you can easily call BASIC subroutines from ADO.NET as though they were Stored Procedures. So wrap LIST.READU in a program, format the output the way you want and call it like a sproc. If you just want this data outside and you're thinking you need to do it with SQL, that's not correct. If you can describe the client-side environment maybe we can provide a more elegant method of delivering the data. Any help? Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET worldwide and provides related development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno From: John J. Wahl Platform: UniVerse Version: 10.2.x O.S.: Windows Server 2008 (x86) 32-bit I'm wondering if there a way to get a listing of READU locks (exactly like the Verb LIST.READU, but via an SQL interface? I was going through the documents and old forum posts, but I do not see anything. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Listing via the SQL Interface...
Any valid command can be executed as a stored procedure via SQLExecDirect (eg., CALL LIST.READU - you need the CALL to specify a store procedure call). Just don't call anything requiring terminal keyboard input.. including anything that pages the output (eg. 'press any key to continue') - other it will crash and return no output. We've done this quite extensively before with UV and it works quite well. Regards David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John J. Wahl Sent: Tuesday, 11 May 2010 9:10 AM To: U2 Users List Subject: [U2] Listing via the SQL Interface... Greetings All, Platform: UniVerse Version: 10.2.x O.S.: Windows Server 2008 (x86) 32-bit I'm wondering if there a way to get a listing of READU locks (exactly like the Verb LIST.READU, but via an SQL interface? I was going through the documents and old forum posts, but I do not see anything. Thank you for your time, -- John J. Wahl Employee Owner Programmer / Analyst Tel: (888) 465-6737 Ext. 120 Fax: (330) 342-3896 Email: jw...@joseph.com Web: http://www.Joseph.com/ ED VOC Record name = LIST.READU 4 lines long. : 0001: V : 0002: list_readu : 0003: E : 0004: BG Bottom at line 4. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users