From owner-sqr-users@list.iex.net Mon Apr 1 00:02:59 2002 Date: Mon, 1 Apr 2002 00:00:01 -0500 From: Nathan Stratton Treadway Subject: Monthly sqr-users Hints Posting sqr-users Mailing List Hints and Guidelines Nathan Stratton Treadway, Ray Ontko & Co. (nathant@ontko.com) $Revision: 1.9 $ $Date: 2001-06-17 13:23:18-04 $ This document gathers in one location information about the sqr-users mail list. Directions for common list-server commands (including unsubscribing) are given, as are guidelines for list usage. ______________________________________________________________________ Table of Contents 1. Changes Since Previous Version 2. Introduction 2.1 sqr-users Mailing List 2.2 sqr-users Hints and Guidelines Document 2.3 Related Mailing Lists 3. Basic List Server Commands 3.1 Subscribing to the List 3.2 Unsubscribing from the List 3.3 Digests 3.4 Problems 4. Posting to the sqr-users List 4.1 General Guidelines 4.2 Posting a Message 4.3 Replying to a Message 5. Job Announcements ______________________________________________________________________ 1. Changes Since Previous Version Changes since the version dated 2001/01/26: o Announce new sqr-jobs mailing list; Job Announcements section updated to reflect this new list. 2. Introduction 2.1. sqr-users Mailing List The sqr-users mailing list was created to enable discussion related to the SQR database language from Brio Technology (and to other products in the Brio.Report line). Note: SQR used to be published by SQRIBE Technologies, which was merged into Brio Technology on August 3, 1999. The mailing list is provided as a service of Ray Ontko & Co. A searchable archive of past postings to the mailing list is available from the SQR Users Group web site . 2.2. sqr-users Hints and Guidelines Document This document gives various hints and guidelines about the sqr-users mailing list. It will be posted approximately monthly to the mailing list so that new users can see it (and existing users can find it easily). An HTML version of the document is always available at http://www.sqrug.com/sqr-users/sqr-users-hints.html. If you have comments or suggestions about this document, please contact me directly at the address listed in the title section. This document is Copyright (C) 1999-2001 by Ray Ontko & Co. It may be freely copied and distributed provided it is not modified in any way and it retains the original copyright notice. 2.3. Related Mailing Lists sqr-jobs : SQR Jobs This list may be used for posting SQR-related resumes, recruitments, job announcements, project announcments, help- wanted, work-wanted ads, etc. To join, follow the link above, or send any message to "sqr-jobs-subscribe@yahoogroups.com". peoplesoft-fans : PeopleSoft Fans Moderated list covering technical and functional aspects of PeopleSoft. To join, follow the link above, or send any message to "peoplesoft-fans-subscribe@yahoogroups.com". psusers : PeopleSoft Users For questions related to any aspect of PeopleSoft (including PeopleSoft-specific SQR issues). This list has merged with the Peoplesoft Fans mailing list and is no longer active, but the message achive can still be found at the link above. rm-users : ReportMart Users List for discussion of Brio.Portal (previously called ReportMart). To join, follow the link above, or send a message containing the word "subscribe" in the body to "rm-users- request@sqrug.com". 3. Basic List Server Commands Note: The list used to be hosted on usa.net , but the list-hosting service was moved to list.iex.net . The old addresses for the list, list server, and list owner no longer work. A few basic list server commands are listed below. Send these commands as the only line in the body (not the subject line) of an e- mail message sent to "listserv@list.iex.net". 3.1. Subscribing to the List To subscribe to the mailing list, the command is subscribe sqr-users Your Name Note that you do not need to provide your e-mail address as it is taken from your message's header. You will be e-mailed a confirmation number, which you must then send back to the list server software before the command goes into effect. 3.2. Unsubscribing from the List To unsubscribe, the command is simply unsubscribe sqr-users Once again, you will need to confirm your command before it goes into effect. 3.3. Digests Once you are subscribed, you can request to get your messages in digest form (one large message containing all of the posts made each day) by sending the command set sqr-users digests If you use digests you should not just "reply" to the digest mailing. Instead, be sure your message's subject header matches the subject in the original posting to which you are replying, and that you don't include a quoted copy of the entire digest in your post. Use "nodigests" instead of "digests" to restore normal distribution. 3.4. Problems If the above commands do not work, please contact the list manager at "sqr-users-request@list.iex.net". (Do not send a message to the list itself -- no one there can help you with your problem!) Please include a copy of the error message you received from the list server. 4. Posting to the sqr-users List In order to post to the mailing list, you must be subscribed to it (see directions above). 4.1. General Guidelines For any message you send to the list, please: o make sure your mail software is not requesting a "Return Receipt". (If a "Return Receipt Requested" message is sent to the list, several dozen receipt messages will be sent out to the mailing list in reply from other subscribers.) o do not send messages in HTML or other special formats. (These are not usable by many subscribers, especially those who receive their messages in digest format.) o keep in mind that over 500 people will receive your message, and that it will appear in the list archives. Try to keep your messages on-topic and relatively short. Consider sending your message directly to particular people if it won't interest many of the list's subscribers. 4.2. Posting a Message Once you are subscribed, you can post to the list by sending a message to "sqr-users@list.iex.net". Be sure your subject heading describes your specific problem or question (i.e. don't just use "SQR Question"). In the body of your message, please include the following information: o Brio product and version number o Operating system and version number o Database name and version number o Application name (i.e. PeopleSoft) and a version number, if any Also, include a short code sample whenever possible. It's much easier for other people to understand what you are trying to do when they can see the actual code. (At the same time, be careful not to post confidential or proprietary code, since the posting will be placed in a public web archive.) Note that your question should relate to SQR or other Brio Report product in some way. Don't ask questions about PeopleSoft, for example, unless you are having SQR-related issues. To find out your version of SQR, you can run the following program: begin-program show $sqr-ver end-program This will produce a line that looks something like this: SQR/3.0.15/Intel/SCO Unix R3.2 V5.0/Oracle 7.2.2.3/Sep 25 1996 Include the full line of output in your message. Note that the oper- ating system version number listed here is the one under which this copy of SQR was compiled, so you'll still need to include your own information. 4.3. Replying to a Message Messages sent out on the list have a Reply-To header pointing to the list. This means that you should be able to simply use your mail reader's "reply" function to send a reply to the list. Generally, all answers to questions sent out on the list should be public replies, so that other subscribers can benefit. In those cases where a private reply is appropriate, be sure to over-ride the default Reply-To address. If your message is not actually a reply to the earlier message, please do not use the "reply" function. Instead, address a new e-mail message to the list as described in the previous section. (This is because the list archives will incorrectly show the new message in the original thread if you use "reply".) You should quote enough lines from the original message that later readers can understand your answer even if they missed the original question. At the same time, you should remove any unnecessary lines from the quote in order to make your message shorter and easier to understand. (Remember that some people read the mailing list in digest form, and the digests become much larger if unnecessary lines are quoted.) In particular, in order to prevent mail loops, the list server will not accept messages that contain From:, Sender:, etc. lines pointing back to the sqr-users list, even if these lines are quoted (i.e. with ">" characters). Be sure to delete these from your reply message before sending it. 5. Job Announcements Please do not post job announcements on the sqr-users list, but use the sqr-jobs list instead. (See ``Related Mailing Lists'' for more information on this list.) A large number of sqr-users subscribers do not want to receive job announcements (for various reasons) and such posts tend to cause a lot of disruption of the discussion on the list. From owner-sqr-users@list.iex.net Mon Apr 1 06:52:52 2002 Date: Mon, 1 Apr 2002 06:44:16 -0500 From: Pamela Lantzy Subject: Re: PDF Limitations Ok, the SQR original was printing the results to the printer, I changed it to create a pdf file (adding SQR flag). Is there something addtional within the SQR besides print statements? -----Original Message----- From: Larry Roux [mailto:lroux@SYR.EDU] Sent: Sunday, March 31, 2002 9:57 AM To: SQR-USERS@LIST.IEX.NET Subject: Re: PDF Limitations TOC = Table of Contents. SQR Always creates the SPF file first. That's just the way SQR operates. It then takes the SPF File and converts it to the .lis (or other format). ****************************** Larry Roux Syracuse University lroux@syr.edu ******************************* >>> PLantzy@UAMAIL.ALBANY.EDU 03/31/02 08:48 AM >>> Ray, I'm not sure what TOC is? I am running this through the PS process scheduler, appending the -printer:pd flag in the process defintion. Here is the command line taken from the process monitor Command Line = prcs_sqr UASFUHSI SYSADM/%ACCESSPSWD%@HE76DEVL -f '-printer:pd' 63500 UBSPLL BILLING I noticed in the output directory, that while the SQR runs it generates a .spf and then it converts it to .lis could this be the problem? How would i prevent the .spf file being created originally? Thanks, Pam -----Original Message----- From: Ray Ontko [mailto:rayo@ONTKO.COM] Sent: Friday, March 29, 2002 9:38 PM To: SQR-USERS@LIST.IEX.NET Subject: Re: PDF Limitations Hi Pam, I think that prior to SQR 4.3.3 there was a limit of 1000 pages in a PDF file. I think that it was raised to 5000 pages in SQR 4.3.3. That's the only PDF-related limit of which I'm aware. Do you have an unusual number of TOC entries? Anything else that might be suspicious? Ray [Charset iso-8859-1 unsupported, filtering to ASCII...] > Hi, > > Does anyone know what limitations of the size a PDF can be? I can generate > invoices for a couple of people and it works fine. Now I am trying to > generate invoices for 629 people and the SQR processes until the end and get > the errors below either on NT or AIX. > > I am using the flag: -printer:pd. > > NT: > PDFLib (Fatal): Error parsing AFM file > \\waiter\psdevl$\he76\sqrbinw/Courier.afm > Unix: > PDFLib (Fatal): Error parsing AFM file > //he01/app/sqr434/ora/bin/Helvetica-Bold. > afm > > > The permissions on these files are fine. I am runing SQR V4.3.4 and Oracle, > and PeopleSoft 7.6 > > > Thanks, > Pam > ---------------------------------------------------------------------- Ray Ontko rayo@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ From owner-sqr-users@list.iex.net Mon Apr 1 08:55:32 2002 Date: Mon, 1 Apr 2002 08:40:59 -0500 From: Christopher Wanko Subject: Re: Resolved! (was: output buffer in SQR? ) >>> david.thompson-hall@DOIT.WISC.EDU 03/29/02 11:22AM >>> OK, it appears the "buffer problem" was not with SQR, but with my text editor (and/or it's interaction with Windoze...) >>> Ironically, I've been following this thread and I said to myself, "If this isn't solved by the time I reach the last message I'm gonna suggest he use the UNIX command "tail" or equivalent to see if he's really stuck or not. You also got a good suggestion earlier - check the actual db process to see if it's doing anything - but since it does create output eventually, viewing the file was your problem, hindsight notwithstanding. -Chris From owner-sqr-users@list.iex.net Mon Apr 1 09:59:29 2002 Date: Mon, 1 Apr 2002 08:47:43 -0600 From: "Fetzik, John" Subject: Re: Resolved! (was: output buffer in SQR? ) Hello, > -----Original Message----- > From: David Thompson-Hall [mailto:david.thompson-hall@DOIT.WISC.EDU] > Sent: Friday, March 29, 2002 10:23 AM > To: SQR-USERS@list.iex.net > Subject: Resolved! (was: output buffer in SQR? ) > > > OK, it appears the "buffer problem" was not with SQR, but > with my text editor (and/or it's interaction with Windoze...) > > I use TextPad, and one of the reasons I like it is because it > will tell you when a file you are looking at has changed. > Since I see it tell me "File X has changed, would you like to > refresh it?" fairly often, I assumed that it would do so > every time the file changed. > > Well, we all know what assuming does, and this time it did it > to me. When > I ran with a Commo Box open, I could see that the shows were > there... and then I thought, what if the file is actually not > refreshing? So I forced a refresh in TextPad, and viola! the > "right" data showed up. > > I don't know whether this is really a problem with TextPad > (not catching the file change) or Windows NT (not telling > TextPad the file changed), but I don't really care.... The > lesson is, don't attribute problems to applications (SQR) > when you can blame other applications (TextPad) or the > Operating System( Windoze). The problem is with Windows, not TextPad. TextPad will detect changes to the file, but only when Windows actually decides to write to the disk. Because of the way that Windows caches disk reads and writes it can be a while before the write shows up on disk and that information is available to other programs. Basically under Windows you can not count on the contents of a file if any program has it open. John S. Fetzik S&C Electric Company 773-338-1000 x2763 jfetzik@sandc.com From owner-sqr-users@list.iex.net Mon Apr 1 10:24:22 2002 Date: Mon, 1 Apr 2002 09:09:10 -0600 From: David Thompson-Hall Subject: Re: Resolved! (was: output buffer in SQR? ) At 08:47 AM 4/1/02 -0600, John S. Fetzik wrote: >The problem is with Windows, not TextPad. TextPad will detect changes to the >file, but only when Windows actually decides to write to the disk. Because >of the way that Windows caches disk reads and writes it can be a while >before the write shows up on disk and that information is available to other >programs. Basically under Windows you can not count on the contents of a >file if any program has it open. This makes perfect sense to me... but it doesn't fit what I saw. I was able to get "current info" to show in TextPad if I used the "Revert to saved" command, which basically re-read the disk. Because this seemed to work, I take it that Windows was writing stuff to disk, but TextPad wasn't catching the updates. I'd bet that something got lost in the "update" process -- either TextPad wasn't looking, or Windows wasn't notifying it. Either way, knowing I can "refresh" is good enough for me. DTH David Thompson-Hall 1210 W. Dayton St. Programmer/Analyst Madison, WI 53706 Apps Tech/Operational Support Apps 608/265-9571 Div of Info Technology (DoIT) University of Wisconsin-Madison david.thompson-hall@doit.wisc.edu From owner-sqr-users@list.iex.net Mon Apr 1 09:31:37 2002 Date: Mon, 1 Apr 2002 09:28:06 -0500 From: Raemil Billings Subject: Re: SQR3 Installation Problems I think you are going to need a 16-bit Oracle installation since SQR3 is 16-bit. Once you get the 16-bit Oracle installed ( I have 7.3.4), go into the Orawin/BIN directory. Copy the Ora73Win.DLL and rename it Ora7Win.DLL. That will correct that problem. You may also have to modify your WIN.INI file to contain [SQR Products] SQRDIR= Hope this helps, Raemil Billings ==================================== Raemil Billings Systems Engineer Johnson Controls 321-784-7796 srik@CAPITOLSYST EMS.COM To: SQR-USERS@list.iex.net Sent by: cc: SQR-USERS@list.i Subject: SQR3 Installation Problems ex.net 03/29/2002 04:30 PM Please respond to sqr-users Hi, I am using Oracle 8i database.I installed SQR3 WorkBench(I know it is a Old version but i had only that vesrion software) on my machine.At the time of Installation it gave 2 options for selecting the database(Oracle 7 or Oracle 6).I choosed Oracle 7. The installation goes well.After Installation i am trying to open SQR ReportMate Oracle7 it gives this error message dialogbox. File Error: Cannot find ORA7WIN.dll. This is the First time i am using the SQR.Can anyone help me in getting out of this. Thanks Srik From owner-sqr-users@list.iex.net Mon Apr 1 11:53:06 2002 Date: Mon, 1 Apr 2002 11:25:05 -0500 From: Dan Vega Subject: Changes To Yahoo Accounts Hi everyone, The annoying change below does affect our Yahoo accounts for the SQR-Jobs group. I recommend that everyone edit their Yahoo 'Marketing Preferences' and set all options to 'No.' Instructions appear below. If you would like to tell Yahoo what you think of this change, here is a link to their feedback page: http://add.yahoo.com/fast/help/us/privacy/cgi_feedback?radio30=radio305 HTH -- Dan V. *********** BEGIN FORWARDED MESSAGE *********** On 3/31/02 at 12:01 PM isig-request@blu.org wrote: >Today's Topics: > > 1. Yahoo resets everyone to receive SPAM - ACT NOW (Tracy Marks) > 2. New Yahoo Privacy Policy Expands Sharing Of User Data (Tracy Marks) > >--__--__-- > >Message: 1 >Date: Sun, 31 Mar 2002 02:32:46 -0500 >To: isig@Blu.Org >From: Tracy Marks >Cc: tracy@windweaver.com >Subject: [Isig] Yahoo resets everyone to receive SPAM - ACT NOW >Reply-To: isig@blu.org > >Folks - > >Apparently in an attempt to increase their income >from advertising, Yahoo has reset all preferences >for people registered with its services - subscribing >to any Yahoogroups, using a My Yahoo page, >having a Yahoo email account, having a Yahoo >geocities site - to YES for spam by email, mail and >telephone calls. > >They're giving people several weeks to opt out by >changing their preferences but meanwhile they are >putting us all on advertiser lists...........Here's some >info I received about it (there are also a few >newspaper articles). I checked out my own >preferences and indeed it now said I that I agreed >to receive advertising by email, mail and phone >from over 100 companies. > >I really encourage you to change your Yahoo account >information immediately if you use any Yahoo services >whatsoever and don't want this to happen to you. > >Tracy Marks > > > >>- Yahoo sets you for SPAM - ACT NOW >>Yahoo appears to have reset the "Marketing >>preferences" of all registered Yahoo users to esentially >>" Do you want SPAM from us? YES " > >>** Important: Read UNLESS you like getting spammed ! ** >>I've just been alerted that Yahoo has made a sneaky change to >>everybody's 'Marketing Preferences' the result - loads of #%$ >>SPAM! So, I've just been in and changed back what they've >>done. They had gone and changed ALL of my *No's* to *Yes!* >> >>Here's what you need to do: Go to your My Groups or a group >>home page at http://www.yahoogroups.com >>OR to your My Yahoo page or any customized page >>you have with Yahoo. >>Click on Account Info on the top-right. Verify your >>password if it asks you to, and there's your Yahoo ID page. >>Under 'Member Information' you'll see *Edit your Marketing >>Preferences* in blue. Change all those dozens of Yes's in >>regard to receiving advertising email, mail and phone calls >>back to No's! Click *Save Changes*. > > >--__--__-- > >Message: 2 >Date: Sun, 31 Mar 2002 02:37:06 -0500 >To: isig@Blu.Org >From: Tracy Marks >Cc: tracy@windweaver.com >Subject: [Isig] New Yahoo Privacy Policy Expands Sharing Of User Data >Reply-To: isig@blu.org > > >>New Yahoo Privacy Policy Expands Sharing Of User Data >>By: Peter Loftus >>Dow Jones Newswires > >EXCERPT > >>One policy change will require Yahoo users to take action. >>Previously, users were able to click only once to decide whether to >>receive promotional e-mails from both Yahoo and its partners. Under >>the new policy, Yahoo users must visit a section of the Web site >>called "Edit Marketing Preferences." There, they must choose >>separately whether to receive more than a dozen categories of >>special offers and marketing e-mails from Yahoo, such as "managing >>personal finances." >> >>For most of the categories, the default option is to receive the >>promotional e-mails. So, if users don't want to receive any of >>them, they must click "No" for each option. The only category where >>"No" is the default option is "Yahoo! Delivers," which features >>special offers from Yahoo's business partners. >> >>The setup raises the possibility that Yahoo users who don't edit >>their marketing preferences will begin receiving Yahoo promotions, >>even if they had previously opted out of such services. >> >>The company is essentially using this requirement to promote its >>newer services. For instance, users who signed up for Yahoo two or >>three years ago -- and who opted out of promotional e-mails at the >>time -- might not be aware that Yahoo has upgraded its job-listings >>service with the recent acquisition of HotJobs Ltd., Ms. Srinivasan >>said. Now, when they edit their marketing preferences, they can >>decide whether to receive information about "finding a job or an >>employee." >> >>Ms. Srinivasan pointed out that users will have 60 days to edit >>their preferences. Also, she said it was the first time Yahoo has >>required users to edit preferences in company history. >> >>-Peter Loftus; Dow Jones Newswires; 201-938-5267; >>peter.loftus@dowjones.com >> >>(Compiled from Dow Jones Newswires and other sources) > >_______________________________________________ >Isig mailing list >Isig@blu.org >http://www.blu.org/mailman/listinfo/isig *********** END FORWARDED MESSAGE *********** From owner-sqr-users@list.iex.net Mon Apr 1 13:16:09 2002 Date: Mon, 1 Apr 2002 13:10:55 -0500 From: Jamie Harris Subject: Re: Changes To Yahoo Accounts --=_81DC18DF.BCDDBBC8 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline Thank you! I checked mine and indeed every option was set back to "Yes". That definitely explains my recent influx of spam emails. :) ----------------------------------------------------- Jamie Harris Junior Systems Programmer/Analyst Information Technology Division Frederick Community College ----------------------------------------------------- >>> vega@CASSI.COM 4/1/2002 11:25:05 AM >>> Hi everyone, The annoying change below does affect our Yahoo accounts for the SQR-Jobs group. I recommend that everyone edit their Yahoo 'Marketing Preferences' and set all options to 'No.' Instructions appear below. If you would like to tell Yahoo what you think of this change, here is a link to their feedback page: http://add.yahoo.com/fast/help/us/privacy/cgi_feedback?radio30=radio305 HTH -- Dan V. *********** BEGIN FORWARDED MESSAGE *********** On 3/31/02 at 12:01 PM isig-request@blu.org wrote: >Today's Topics: > > 1. Yahoo resets everyone to receive SPAM - ACT NOW (Tracy Marks) > 2. New Yahoo Privacy Policy Expands Sharing Of User Data (Tracy Marks) > >--__--__-- > >Message: 1 >Date: Sun, 31 Mar 2002 02:32:46 -0500 >To: isig@Blu.Org >From: Tracy Marks >Cc: tracy@windweaver.com >Subject: [Isig] Yahoo resets everyone to receive SPAM - ACT NOW >Reply-To: isig@blu.org > >Folks - > >Apparently in an attempt to increase their income >from advertising, Yahoo has reset all preferences >for people registered with its services - subscribing >to any Yahoogroups, using a My Yahoo page, >having a Yahoo email account, having a Yahoo >geocities site - to YES for spam by email, mail and >telephone calls. > >They're giving people several weeks to opt out by >changing their preferences but meanwhile they are >putting us all on advertiser lists...........Here's some >info I received about it (there are also a few >newspaper articles). I checked out my own >preferences and indeed it now said I that I agreed >to receive advertising by email, mail and phone >from over 100 companies. > >I really encourage you to change your Yahoo account >information immediately if you use any Yahoo services >whatsoever and don't want this to happen to you. > >Tracy Marks > > > >>- Yahoo sets you for SPAM - ACT NOW >>Yahoo appears to have reset the "Marketing >>preferences" of all registered Yahoo users to esentially >>" Do you want SPAM from us? YES " > >>** Important: Read UNLESS you like getting spammed ! ** >>I've just been alerted that Yahoo has made a sneaky change to >>everybody's 'Marketing Preferences' the result - loads of #%$ >>SPAM! So, I've just been in and changed back what they've >>done. They had gone and changed ALL of my *No's* to *Yes!* >> >>Here's what you need to do: Go to your My Groups or a group >>home page at http://www.yahoogroups.com >>OR to your My Yahoo page or any customized page >>you have with Yahoo. >>Click on Account Info on the top-right. Verify your >>password if it asks you to, and there's your Yahoo ID page. >>Under 'Member Information' you'll see *Edit your Marketing >>Preferences* in blue. Change all those dozens of Yes's in >>regard to receiving advertising email, mail and phone calls >>back to No's! Click *Save Changes*. > > >--__--__-- > >Message: 2 >Date: Sun, 31 Mar 2002 02:37:06 -0500 >To: isig@Blu.Org >From: Tracy Marks >Cc: tracy@windweaver.com >Subject: [Isig] New Yahoo Privacy Policy Expands Sharing Of User Data >Reply-To: isig@blu.org > > >>New Yahoo Privacy Policy Expands Sharing Of User Data >>By: Peter Loftus >>Dow Jones Newswires > >EXCERPT > >>One policy change will require Yahoo users to take action. >>Previously, users were able to click only once to decide whether to >>receive promotional e-mails from both Yahoo and its partners. Under >>the new policy, Yahoo users must visit a section of the Web site >>called "Edit Marketing Preferences." There, they must choose >>separately whether to receive more than a dozen categories of >>special offers and marketing e-mails from Yahoo, such as "managing >>personal finances." >> >>For most of the categories, the default option is to receive the >>promotional e-mails. So, if users don't want to receive any of >>them, they must click "No" for each option. The only category where >>"No" is the default option is "Yahoo! Delivers," which features >>special offers from Yahoo's business partners. >> >>The setup raises the possibility that Yahoo users who don't edit >>their marketing preferences will begin receiving Yahoo promotions, >>even if they had previously opted out of such services. >> >>The company is essentially using this requirement to promote its >>newer services. For instance, users who signed up for Yahoo two or >>three years ago -- and who opted out of promotional e-mails at the >>time -- might not be aware that Yahoo has upgraded its job-listings >>service with the recent acquisition of HotJobs Ltd., Ms. Srinivasan >>said. Now, when they edit their marketing preferences, they can >>decide whether to receive information about "finding a job or an >>employee." >> >>Ms. Srinivasan pointed out that users will have 60 days to edit >>their preferences. Also, she said it was the first time Yahoo has >>required users to edit preferences in company history. >> >>-Peter Loftus; Dow Jones Newswires; 201-938-5267; >>peter.loftus@dowjones.com >> >>(Compiled from Dow Jones Newswires and other sources) > >_______________________________________________ >Isig mailing list >Isig@blu.org >http://www.blu.org/mailman/listinfo/isig *********** END FORWARDED MESSAGE *********** --=_81DC18DF.BCDDBBC8 Content-Type: text/plain Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="Jamie Harris.vcf" BEGIN:VCARD VERSION:2.1 X-GWTYPE:USER FN:Harris, Jamie TEL;WORK:2668 ORG:Work;Division of Information Technology EMAIL;WORK;PREF:JHarris@fcc.cc.md.us N:Harris;Jamie TITLE:Systems Analyst, PeopleSoft ADR;DOM;WORK;PARCEL;POSTAL:;L-205 LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=QUOTED-PRINTABLE:Harris, Jamie=0A= L-205 END:VCARD --=_81DC18DF.BCDDBBC8-- From owner-sqr-users@list.iex.net Mon Apr 1 13:19:44 2002 Date: Mon, 1 Apr 2002 13:17:59 -0500 From: Jamie Harris Subject: Re: Select * - sample SQR for Oracle --=_15488C4D.8DEC8AF9 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline That's very similar to one of my programs. It's nice to see that it really *can* be done in SQR. :) ----------------------------------------------------- Jamie Harris Junior Systems Programmer/Analyst Information Technology Division Frederick Community College ----------------------------------------------------- >>> Dmueller@NMH.ORG 3/29/2002 3:29:43 PM >>> Below is an SQR that I wrote that will prompt for a TABLE NAME and an optional WHERE clause, and dump the data to a spreadsheet format. It is written for Oracle, but could be easily modified to handle other database types. (Just change the table name and column names in the "build-column-list" procedure) Basically you select one BIG character field, which is all the columns concatenated together and separated by commas, then write it to an output file, rather than issue PRINT commands. Using .CSV (Comma Separated Values) output format allows you to open the file with Excel, which keeps formatting nice and eliminates wrapping. Excel also allows printing in a variety of formats. Here it is: !--------------------------------------------- ! Select * from a table (ORACLE version) !--------------------------------------------- begin-report input $Table-Name 'Enter Table Name' let $Table-Name = upper($Table-Name) input $Where 'Enter optional WHERE clause' open 'c:\temp\sel.csv' as 2 for-writing record=5000:vary do build-column-list let $dis= 'Column list for table '||$Table-Name||':' display $dis display $col-list display 'Where clause: ' display $where write 2 from $col-hdr do get-data end-report !--------------------------------------------- begin-procedure get-data !--------------------------------------------- begin-SELECT [$col-list] &record=char write 2 from &record from [$table-name] [$where] end-SELECT end-procedure !--------------------------------------------- begin-procedure build-column-list !--------------------------------------------- let $col-hdr = '' let $col-list = '' begin-SELECT c.column_id c.column_name c.data_type let $type = substr(&c.data_type ,1,4) let $col = rtrim(&c.column_name,' ') let $col-hdr = $col-hdr||',' ||$col ! build for each field: ||','||'"'||$col||'"' ! then strip first 7 after loop evaluate $type when = 'VARC' !Character field let $col-list = $col-list ||'||' ||'''' ||',' ||'''' ||'||' ||'''' ||'"' ||'''' ||'||' ||$col ||'||' ||'''' ||'"' ||'''' when = 'DATE' !Date field let $col-list = $col-list ||'||' ||'''' ||',' ||'''' ||'||' ||'''' ||'"' ||'''' ||'||' ||'to_char('||$col||','||''''||'yyyy-mm-dd'||''''||')' ||'||' ||'''' ||'"' ||'''' when = 'NUMB' !Number field let $col-list = $col-list ||'||' ||'''' ||',' ||'''' ||'||' ||'''' ||'"' ||'''' ||'||' ||'to_char('||$col||','||''''||'999999999.99'||''''||')' ||'||' ||'''' ||'"' ||'''' end-evaluate from all_tab_columns c where c.table_name = $table-name order by 1 end-SELECT !remove first 7 characters from list let #tmp = length($col-list) - 7 let $col-list = substr($col-list,8,#tmp) !remove first comma from header let #tmp = length($col-list) - 1 let $col-hdr = substr($col-hdr,2,#tmp) end-procedure > -----Original Message----- > From: Jamie Harris [SMTP:jharris@FCC.CC.MD.US] > Sent: Thursday, March 28, 2002 7:41 PM > To: SQR-USERS@list.iex.net > Subject: Re: Select ALL > > Peter, you seem to be saying that nobody would ever want to "select * > from" in an SQR program, so it's not necessary for the language to > support it. > > If so, I have to respectfully disagree with that. :) For reporting > purposes, you're absolutely right: "select * from" isn't very useful. > You're also right that adding the ability to SQR wouldn't gain much at > all because you wouldn't be able to do anything with the data returned > (without changing the rules of the language). > > However, I have several utility programs I've written for > troubleshooting/testing purposes (where the data itself is much more > important than how it looks) which make use of "select * from" and are > *quite* useful to me. If I had to give these programs up, I'd > definitely put up a fight since I use them very frequently. > > Since SQR just doesn't do such things I've had to write these programs > using Perl and one of the database modules (I personally use Win32::ODBC > but DBI [which is much more platform & database-independent] would work > too). It works for me, I know both languages and to me they are the > screwdriver and the hammer -- two valuable tools that this particular > "carpenter" cannot live without. > > For someone who doesn't know both Perl and SQR, but can still think of a > need for "select * from", it can be frustrating that SQR doesn't let > them do it. > > To everyone: please, we don't need another "SQR vs. Perl" debate. I'm > just pointing out that I've had the need for "select * from" on a few > occasions and I've had to turn to another language for it. > > [note: lengthy example below to illustrate one of the things I use > "select * from" to do.] > > I have one program that I use to generate test populations at random. I > give it an SQL statement (pasted right out of query analyzer, comments > and all) and a row count. It then picks that many rows at random and > dumps the data to a tab-delimited file (with the first row containing > the field names). If I care about field names and the order they are > in, I can specify all that in the SQL statement like this: > > select > A.EMPLID 'Student ID', > A.NAME 'Name', > B.CUM_GPA 'Cumulative GPA', > B.CUR_GPA 'Current GPA', > C.* -- I don't care what table C looks like > from (...) > where (...) > > If I'm not picky about it, I just use "select * from" and it works just > as well: why type the names all out if you want everything and don't > care what order? I can then open the output in Excel or feed it into > another program for further processing. > > A re-usable program such as this would be very hard (as far as I know) > to write in SQR if it can be done at all. Sure, you could have an SQR > that asks for the table name and then generates another SQR that will do > this to that table, but I can't see a way to write one program that will > do this for *any* table. > > This isn't the best example of why "select * from" might be something > you'd want to do in SQR, but it's an example of the *kinds* of things > one *could* do with that ability. You'd also have to re-work the SQR > language itself in order to allow something to be *done* with the data. > I don't know if it would be worth it in the long run to modify SQR in > such a way. > > ps. Some of my other programs would be better examples, but explaining > what they do and how I use them would make for a *much* longer email > than this one. :) > > ----------------------------------------------------- > Jamie Harris > Junior Systems Programmer/Analyst > Information Technology Division > Frederick Community College > ----------------------------------------------------- > >>> pburton@BRIO.COM 03/28/02 10:48 AM >>> > Greetings, > > Supporting "SELECT * FROM TABLE" will get you absolutely nothing. > > Let us suppose SQR did support that functionality. How would manipulate > a > column value? What about placement on the page? What about formatting? > In > order to do these things you need to know the name of the column. I > doubt > that anybody would accept blindly printing a database table in the order > of > the columns defined and using default formatting settings. You wouldn't > have any idea of what is being printed. > > You can use ReportBuilder to browse the database schema and create an > SQR > report. > > Peter --=_15488C4D.8DEC8AF9 Content-Type: text/plain Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="Jamie Harris.vcf" BEGIN:VCARD VERSION:2.1 X-GWTYPE:USER FN:Harris, Jamie TEL;WORK:2668 ORG:Work;Division of Information Technology EMAIL;WORK;PREF:JHarris@fcc.cc.md.us N:Harris;Jamie TITLE:Systems Analyst, PeopleSoft ADR;DOM;WORK;PARCEL;POSTAL:;L-205 LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=QUOTED-PRINTABLE:Harris, Jamie=0A= L-205 END:VCARD --=_15488C4D.8DEC8AF9-- From owner-sqr-users@list.iex.net Mon Apr 1 14:15:08 2002 Date: Mon, 1 Apr 2002 13:04:21 -0600 From: Tom Whipple Subject: HTML + begin-header problem > Hello, > > I am using the HTML functions from html.inc to format the HTML version of > a report. Although PDF output is fine, for HTML it seems that the header > and footing sections are getting executed _after_ a section ( probably > about a page ) of the main body of the report. > > Is there some setting I am missing? Is there a way to suppress the output > of
and tags at the bottom (or is it part of the header) of > each page? > > Thanks in advance! > > From owner-sqr-users@list.iex.net Mon Apr 1 14:46:24 2002 Date: Mon, 1 Apr 2002 11:33:00 -0800 From: Ken Boettger Subject: New SQR'r begin-select T.field1 T.field2 let f1 = &T.field1 let f2 = &T.field2 print f1 (+1,5) print f2 (,20) from table1 T end select Everything works fine until I put an ON-BREAK on field1: begin-select T.field1 on-break t.field2 let f1 = &T.field1 let f2 = &T.field2 print f1 (+1,5) print f2 (,20) from table1 T end select With this, I get errors that read: "Columns names and expressions must be unique or be given unique pseudonyms (&name)." "Referenced variables not defined" Can someone help explain to me the problem here? It seems the code is valid as it runs fine until I insert the ON-BREAK. Thanks. -Ken From owner-sqr-users@list.iex.net Mon Apr 1 14:59:42 2002 Date: Mon, 1 Apr 2002 14:54:41 -0500 From: Rod Wright Subject: Re: New SQR'r You need to give it something to do when a break occurs. For example: MHD.DEPENDENT_BENEF () on-break print=never level=1 after=DepBenefChange You seem to need the () before the on-break. They are part of a print statement, telling SQR where to print the information. Since you don't want anything to print, you give it the "print=never" option. The "level=1" option tells SQR that this is a level 1 break, as opposed to level 2, 3, etc. This is not required in all cases. the "after=DepBenefChange" tells SQR to execute the DepBenefChange procedure after the value changes. I suggest looking up the syntax for on-break. It's associated with the Print statement. Rod Ken Boettger @list.iex.net> on 04/01/2002 02:33:00 PM Please respond to sqr-users@list.iex.net Sent by: "Discussion of SQR, Brio Software's database reporting language" To: SQR-USERS@list.iex.net cc: Subject: New SQR'r begin-select T.field1 T.field2 let f1 = &T.field1 let f2 = &T.field2 print f1 (+1,5) print f2 (,20) from table1 T end select Everything works fine until I put an ON-BREAK on field1: begin-select T.field1 on-break t.field2 let f1 = &T.field1 let f2 = &T.field2 print f1 (+1,5) print f2 (,20) from table1 T end select With this, I get errors that read: "Columns names and expressions must be unique or be given unique pseudonyms (&name)." "Referenced variables not defined" Can someone help explain to me the problem here? It seems the code is valid as it runs fine until I insert the ON-BREAK. Thanks. -Ken From owner-sqr-users@list.iex.net Mon Apr 1 15:07:23 2002 Date: Mon, 1 Apr 2002 15:05:38 -0500 From: "Patel, Samir" Subject: Re: New SQR'r Ken, Try this... begin-select T.field1 () ON-BREAK PRINT=NEVER AFTER= T.field2 let f1 = &T.field1 let f2 = &T.field2 print f1 (+1,5) print f2 (,20) from table1 T end select -----Original Message----- From: Ken Boettger [mailto:BoettgeK@CWU.EDU] Sent: Monday, April 01, 2002 2:33 PM To: SQR-USERS@list.iex.net Subject: New SQR'r begin-select T.field1 T.field2 let f1 = &T.field1 let f2 = &T.field2 print f1 (+1,5) print f2 (,20) from table1 T end select Everything works fine until I put an ON-BREAK on field1: begin-select T.field1 on-break t.field2 let f1 = &T.field1 let f2 = &T.field2 print f1 (+1,5) print f2 (,20) from table1 T end select With this, I get errors that read: "Columns names and expressions must be unique or be given unique pseudonyms (&name)." "Referenced variables not defined" Can someone help explain to me the problem here? It seems the code is valid as it runs fine until I insert the ON-BREAK. Thanks. -Ken From owner-sqr-users@list.iex.net Mon Apr 1 15:08:46 2002 Date: Mon, 1 Apr 2002 12:07:40 -0800 From: Ken Boettger Subject: Re: New SQR'r Thanks Rod, That did the trick. I was reading the book this morning and the reason I came up with this question. It doesn't explain the usage of the parenthesis well under ON-BREAK or in the Break section of the User's Guide. Thanks for your help. -Ken >>> rwright@THEROUSECOMPANY.COM 04/01/02 11:54AM >>> You need to give it something to do when a break occurs. For example: MHD.DEPENDENT_BENEF () on-break print=never level=1 after=DepBenefChange You seem to need the () before the on-break. They are part of a print statement, telling SQR where to print the information. Since you don't want anything to print, you give it the "print=never" option. The "level=1" option tells SQR that this is a level 1 break, as opposed to level 2, 3, etc. This is not required in all cases. the "after=DepBenefChange" tells SQR to execute the DepBenefChange procedure after the value changes. I suggest looking up the syntax for on-break. It's associated with the Print statement. Rod Ken Boettger @list.iex.net> on 04/01/2002 02:33:00 PM Please respond to sqr-users@list.iex.net Sent by: "Discussion of SQR, Brio Software's database reporting language" To: SQR-USERS@list.iex.net cc: Subject: New SQR'r begin-select T.field1 T.field2 let f1 = &T.field1 let f2 = &T.field2 print f1 (+1,5) print f2 (,20) from table1 T end select Everything works fine until I put an ON-BREAK on field1: begin-select T.field1 on-break t.field2 let f1 = &T.field1 let f2 = &T.field2 print f1 (+1,5) print f2 (,20) from table1 T end select With this, I get errors that read: "Columns names and expressions must be unique or be given unique pseudonyms (&name)." "Referenced variables not defined" Can someone help explain to me the problem here? It seems the code is valid as it runs fine until I insert the ON-BREAK. Thanks. -Ken From owner-sqr-users@list.iex.net Mon Apr 1 15:44:37 2002 Date: Mon, 1 Apr 2002 14:00:29 -0700 From: srik Subject: Re: SQR's documentation Hi, Can anyone tell where can i find the SQR documentation or suggest some books on SQR bcz i couldn't find any books over internet search. Thanks Srik From owner-sqr-users@list.iex.net Mon Apr 1 16:04:59 2002 Date: Mon, 1 Apr 2002 13:03:00 -0800 From: Sam Spritzer Subject: Re: SQR's documentation Go to Amazon and look for the following... SQR Programmer Reference: SQR Language Version 2.x-5.x by Don Mellon (editor) SQR in PeopleSoft and Other Applications by Galina and Vlad Landres Sam --- srik wrote: > Hi, > > Can anyone tell where can i find the SQR documentation or suggest some books > on SQR bcz i couldn't find any books over internet search. > > Thanks > Srik ===== ************************************************************ "In the beginning, there was something...which exploded yet, they find nothing." __________________________________________________ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/ From owner-sqr-users@list.iex.net Mon Apr 1 16:32:03 2002 Date: Mon, 1 Apr 2002 13:29:21 -0800 From: Rachael Beatty Subject: Re: SQR's documentation --0__=p8m8i4HuK6jskPE6mYkqRT5zyVNrxd6irLNq3KoxmDYgPPuwubTQbLaY Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: 7bit If you need the users guide and/or reference guide, you can get it at www.brio.com Rachael > -----Original Message----- > From: srik @INTERNET > Sent: Monday, April 01, 2002 1:00 PM > To: SQR-USERS@list.iex.net > Subject: Re: SQR's documentation > > > Hi, > > Can anyone tell where can i find the SQR documentation or suggest some > books > on SQR bcz i couldn't find any books over internet search. > > Thanks > Srik > (See attached file: C.DTF) --0__=p8m8i4HuK6jskPE6mYkqRT5zyVNrxd6irLNq3KoxmDYgPPuwubTQbLaY Content-Type: application/octet-stream; name=C.DTF Content-Disposition: attachment; filename=C.DTF Content-Transfer-Encoding: base64 eJ8+IhUVAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQWAAwAOAAAA0gcEAAEADQAdABUAAQAeAQEggAMADgAAANIHBAAB AA0ADAAUAAEADAEBCYABACEAAABEOUU5NTk1NjkxNDVENjExQUM0QjAwMDBFODY3QzBFRgAlBwEE gAEAGAAAAFJFOiBTUVIncyBkb2N1bWVudGF0aW9uABsIAQ2ABAACAAAAAgACAAEDkAYAEAoAADcA AAADAACACCAGAAAAAADAAAAAAAAARgAAAABShQAA8BMAAB4AAYAIIAYAAAAAAMAAAAAAAABGAAAA AFSFAAABAAAABAAAADguNQALAAKACCAGAAAAAADAAAAAAAAARgAAAAAGhQAAAAAAAAMAA4AIIAYA AAAAAMAAAAAAAABGAAAAAAGFAAAAAAAACwAEgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAAL AAWACCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAAMABoAIIAYAAAAAAMAAAAAAAABGAAAAABCF AAAAAAAAAwAHgAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAALAA+ACCAGAAAAAADAAAAAAAAA RgAAAAAUhQAAAAAAAAMACIAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAAHgAJgAggBgAAAAAA wAAAAAAAAEYAAAAANoUAAAEAAAABAAAAAAAAAB4ACoAIIAYAAAAAAMAAAAAAAABGAAAAADeFAAAB AAAAAQAAAAAAAAAeAAuACCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAACwARgAgg BgAAAAAAwAAAAAAAAEYAAAAAgoUAAAEAAAALAAyACyAGAAAAAADAAAAAAAAARgAAAAAAiAAAAAAA AAsADYALIAYAAAAAAMAAAAAAAABGAAAAAAWIAAAAAAAAAgEJEAEAAACvAgAAqwIAAM4DAABMWkZ1 qeKwfQMACgByY3BnMTI1PjIA9AH3AqQE9AIAY2hBCsBzZXQwIAhQbX8N4AYEBeACgwBQA9QCAHDw cnEyIAcTAoMOUANVRFRtBCBSbW4CgzM3BEcIVQKAfQqACMggO3sJYg4wNQm6FyEW0w4gOL8JuhiR FtMJrAKACoF2CJCkd2sLgGQ0DGBjAFAtCwNjAEELYG4OEDAzAxTBC8M0IElmIHkJCGAgbgngZCB0 aBhlIHUQcBBgIGd1ymkBACAAcGQvBbEZ0LZmBJAJ8GMekB8TLB3TSmMDkWcQgCBpBUBhJQVAdyIQ LmIFEG8u3QWgbQqiCoQKgFIA0BBAPmUJUCLpHFEBQBKAb3SHBZAQARHiMTYgLSYSek8FEGcLgAdA BdAHkHP+YSFwJhMi1iUkJPELEyUmIGktMTQ0AUBsaUcpswzQKbNiIEYDYToVDINiEKBzBRBrIDwB K9JAQ0FQSVRPQExTWVNURQXgLoBDT00+QElOLSDwUk5FVArjCoEq4AZgiwIwK0dNAiBkYXkg0GZB EoADETAxINAB0DCJErAxOjDgIFBNLlcEVG8rR1NRUi1VElMt8FNAKgBzdC45CJB4Lh4gEAAuZ3Vi RmolUStHUmU6MsIn4QQgZG9jdQeAAjAh4M8icAuQJ88o2XNsHYABQPE5AG11bCiBHGATcR1EDSLV bzTgIeB0cGhc/icMASTSE2EkdhTBFMEl0KA4IEhpLCLaQwORvwBwHeAeIB5gI+ADIHcegPMZ0CEj aSApgBuQHmMy0cU2XCAFsXN1ZyFwM5DPK8ADcB6QBuBvaxJQIuPjQZFAomJjej/hBaA5kPhkbicF QEATPpFCtEGw/nYEkCGgAjAEkSGBEHAKwFUQMC4i2lQQQG5C9lMXK+Ei2hXxAEnQAB4AcAABAAAA GAAAAFJlOiBTUVIncyBkb2N1bWVudGF0aW9uAAIBcQABAAAAGwAAAAHB2cOPfSy2dy06dEDDrIYV /y6shoUAAEGYAAADAC4AAAAAAAsAKwAAAAAACwACAAEAAAACATEAAQAAABwBAABQQ0RGRUIwOQAB AAIAcwAAAAAAAAA4obsQBeUQGqG7CAArKlbCAABFTVNNREIuRExMAAAAAAAAAAAbVfogqmYRzZvI AKoAL8RaDAAAAExBWEhITVhTMDEAL289SGlsdG9uL291PUxBWEhIL2NuPVJlY2lwaWVudHMvY249 cmJlYXR0eQAuAAAAAAAAALZm2BZNXNURrEIAAOhnwO8BAO1n/XAKNdQRrCQABKxMleMAAAMylJwA AAAAAAAuAAAAAAAAALZm2BZNXNURrEIAAOhnwO8BAO1n/XAKNdQRrCQABKxMleMAAAMylJ0AABAA AADZ6VlWkUXWEaxLAADoZ8DvGAAAAFJFOiBTUVIncyBkb2N1bWVudGF0aW9uAB4AQhABAAAASwAA ADwxNjNFQzNFMDY0QUU0MDQxOTI0MDVENUYwNDlENkY1MzE4NUY3RkM0QGhoY2RjbXhzMDIuaG90 ZWxzLmFkLmhpbHRvbi5jb20+AAADAN4/r28AAEAAOQCw1KJJxNnBAQMA8T8JBAAAHgAxQAEAAAAI AAAAUkJFQVRUWQADABpAAAAAAB4AMEABAAAACAAAAFJCRUFUVFkAAwAZQAAAAAADACYAAAAAAAMA NgAAAAAAAwD9P+QEAAADAIAQ/////wIBRwABAAAAMwAAAGM9VVM7YT0gO3A9SGlsdG9uO2w9TEFY SEhNWFMwMS0wMjA0MDEyMTI5MjFaLTE1MDM4AAACAfk/AQAAAEgAAAAAAAAA3KdAyMBCEBq0uQgA Ky/hggEAAAAAAAAAL089SElMVE9OL09VPUxBWEhIL0NOPVJFQ0lQSUVOVFMvQ049UkJFQVRUWQAe APg/AQAAAA8AAABSYWNoYWVsIEJlYXR0eQAAHgA4QAEAAAAIAAAAUkJFQVRUWQACAfs/AQAAAEgA AAAAAAAA3KdAyMBCEBq0uQgAKy/hggEAAAAAAAAAL089SElMVE9OL09VPUxBWEhIL0NOPVJFQ0lQ SUVOVFMvQ049UkJFQVRUWQAeAPo/AQAAAA8AAABSYWNoYWVsIEJlYXR0eQAAHgA5QAEAAAAIAAAA UkJFQVRUWQBAAAcwunSVSMTZwQFAAAgwdkLS6MHZwQEeAD0AAQAAAAUAAABSRTogAAAAAB4AHQ4B AAAAFAAAAFNRUidzIGRvY3VtZW50YXRpb24AHgA1EAEAAABBAAAAPEVENjdGRDcwMEEzNUQ0MTFB QzI0MDAwNEFDNEM5NUUzMDUzQzI5RDdAbGF4aGhteHMwMS5oaWx0b24uY29tPgAAAAALACkAAQAA AAsAIwABAAAAAwAGEJ8wvokDAAcQVgEAAAMAEBAAAAAAAwAREAEAAAAeAAgQAQAAAGUAAABJRllP VU5FRURUSEVVU0VSU0dVSURFQU5EL09SUkVGRVJFTkNFR1VJREUsWU9VQ0FOR0VUSVRBVFdXV0JS SU9DT01SQUNIQUVMLS0tLS1PUklHSU5BTE1FU1NBR0UtLS0tLUZSAAAAAAIBfwABAAAAQQAAADxF RDY3RkQ3MDBBMzVENDExQUMyNDAwMDRBQzRDOTVFMzA1M0MyOUQ3QGxheGhobXhzMDEuaGlsdG9u LmNvbT4AAAAAwDkCApAGAA4AAAACABMBAAD/////AAAAABIEAhCAAQAUAAAAVW50aXRsZWQgQXR0 YWNobWVudAByBwISgAMADgAAANIHBAABAA0AHQAUAAEAHQECE4ADAA4AAADSBwQAAQANAB0AFAAB AB0BAgWQBgDMDgAADQAAAAMAIQ4AAAAAAwALNxMBAAADACAOTg4AAAMA9w8AAAAAAgEQaAEAAAAO AAAAAAAAAAAAAAAAAAAAAAAAAEAABzAgiAxJxNnBAUAACDAgiAxJxNnBAQMABTcGAAAAAgECNwEA AAAAAAAAHgABMAEAAAABAAAAAAAAAAIBCjcBAAAACwAAACqGSIb3FAMKAwIBAAIB+Q8BAAAAEAAA AL6NimKyRdYRuq0ABKxMpXcNAAE3AQAAABAOAAALAAAAAAAAAMAAAAAAAABG0M8R4KGxGuEAAAAA AAAAAAAAAAAAAAAAPgADAP7/CQAGAAAAAAAAAAAAAAABAAAAAQAAAAAAAAAAEAAAAgAAAAEAAAD+ ////AAAAAAAAAAD///////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////9////BAAAAP7///8F AAAA/v////7///////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////1IAbwBvAHQAIABFAG4A dAByAHkAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWAAUA//// //////8CAAAAFgMAAAAAAADAAAAAAAAARgAAAAAAAAAAAAAAABDR46bE2cEBAwAAAEACAAAAAAAA AQBPAGwAZQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAoAAgH///////////////8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAFAAAAAAAAAACAE8AbABlAFAAcgBlAHMAMAAwADAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAGAACAQEAAAADAAAA/////wAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAEAAACAAQAAAAAAAAMATQBhAGkAbABTAHQAcgBlAGEAbQAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAYAAIB/////wQAAAD/////AAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABwAAAAwAAAAAAAAA/v///wIAAAADAAAABAAA AAUAAAAGAAAA/v////7////+//////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////8BAAACAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA/////wgAAAAE AAAAAQAAAP////8CAAAAAAAAAMw6AABpAAAAUAEAACgAAAA5AgAABAAAAAEAAQAAAAAAIAEAAMQO AADEDgAAAAAAAAAAAAAAAAAA////AP////////////////////////////////////////////// ////////////////////////////////////////////////gAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABgAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAABgP////////////////////////////////////////////////////////////// ////////////////////////////////gE5BTkkAAAAAAQAAAM86AABqAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAFIAaQBjAGgARQBkAGkAdABG AGwAYQBnAHMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAcAAIA//////// ////////AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACAAAAAwAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAD///////////////8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAP///////////////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA////////////////AAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAQAAAAAABAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACQuw== --0__=p8m8i4HuK6jskPE6mYkqRT5zyVNrxd6irLNq3KoxmDYgPPuwubTQbLaY-- From owner-sqr-users@list.iex.net Mon Apr 1 17:14:19 2002 Date: Mon, 1 Apr 2002 15:30:35 -0700 From: srik Subject: Re: SQR's documentation Thanks Rachael -----Original Message----- From: Discussion of SQR, Brio Software's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Rachael Beatty Sent: Monday, April 01, 2002 2:29 PM To: SQR-USERS@list.iex.net Subject: Re: SQR's documentation If you need the users guide and/or reference guide, you can get it at www.brio.com Rachael > -----Original Message----- > From: srik @INTERNET > Sent: Monday, April 01, 2002 1:00 PM > To: SQR-USERS@list.iex.net > Subject: Re: SQR's documentation > > > Hi, > > Can anyone tell where can i find the SQR documentation or suggest some > books > on SQR bcz i couldn't find any books over internet search. > > Thanks > Srik > (See attached file: C.DTF) From owner-sqr-users@list.iex.net Mon Apr 1 17:01:36 2002 Date: Mon, 1 Apr 2002 13:57:30 -0800 From: Ken Boettger Subject: Re: New SQR'r Thanks. It was the parenthesis. They were not explained well in the manuals I have here. I just needed that empty set of parens. Thanks. -Ken >>> spatel@ADMIN1.UMARYLAND.EDU 04/01/02 12:05PM >>> Ken, Try this... begin-select T.field1 () ON-BREAK PRINT=NEVER AFTER= T.field2 let f1 = &T.field1 let f2 = &T.field2 print f1 (+1,5) print f2 (,20) from table1 T end select -----Original Message----- From: Ken Boettger [mailto:BoettgeK@CWU.EDU] Sent: Monday, April 01, 2002 2:33 PM To: SQR-USERS@list.iex.net Subject: New SQR'r begin-select T.field1 T.field2 let f1 = &T.field1 let f2 = &T.field2 print f1 (+1,5) print f2 (,20) from table1 T end select Everything works fine until I put an ON-BREAK on field1: begin-select T.field1 on-break t.field2 let f1 = &T.field1 let f2 = &T.field2 print f1 (+1,5) print f2 (,20) from table1 T end select With this, I get errors that read: "Columns names and expressions must be unique or be given unique pseudonyms (&name)." "Referenced variables not defined" Can someone help explain to me the problem here? It seems the code is valid as it runs fine until I insert the ON-BREAK. Thanks. -Ken From owner-sqr-users@list.iex.net Tue Apr 2 09:01:04 2002 Date: Tue, 2 Apr 2002 08:50:05 -0500 From: Denise White Subject: Re: New SQR'r Hi Ken, There are a few more problems with your code, but maybe you just didn't reproduce it exactly in your message, since you seem to be saying that it is working fine now. Anyway: You need a hyphen in 'end-select', instead of 'end select'. Also, the variables that you are assigning the selected columns to need prefixes to show the data type. Assuming they are character fields, your variables should be '$f1' and '$f2', not 'f1' and 'f2'. If they are numeric, use a '#' instead of '$'. HTH, Denise White Sr. Programmer/Analyst Vicor ------------------------------ Date: Mon, 1 Apr 2002 13:57:30 -0800 From: Ken Boettger Subject: Re: New SQR'r Thanks. It was the parenthesis. They were not explained well in the manuals I have here. I just needed that empty set of parens. Thanks. -Ken >>> spatel@ADMIN1.UMARYLAND.EDU 04/01/02 12:05PM >>> Ken, Try this... begin-select T.field1 () ON-BREAK PRINT=NEVER AFTER= T.field2 let f1 = &T.field1 let f2 = &T.field2 print f1 (+1,5) print f2 (,20) from table1 T end select -----Original Message----- From: Ken Boettger [mailto:BoettgeK@CWU.EDU] Sent: Monday, April 01, 2002 2:33 PM To: SQR-USERS@list.iex.net Subject: New SQR'r begin-select T.field1 T.field2 let f1 = &T.field1 let f2 = &T.field2 print f1 (+1,5) print f2 (,20) from table1 T end select Everything works fine until I put an ON-BREAK on field1: begin-select T.field1 on-break t.field2 let f1 = &T.field1 let f2 = &T.field2 print f1 (+1,5) print f2 (,20) from table1 T end select With this, I get errors that read: "Columns names and expressions must be unique or be given unique pseudonyms (&name)." "Referenced variables not defined" Can someone help explain to me the problem here? It seems the code is valid as it runs fine until I insert the ON-BREAK. Thanks. -Ken From owner-sqr-users@list.iex.net Tue Apr 2 11:17:13 2002 Date: Tue, 2 Apr 2002 08:11:59 -0800 From: Ken Boettger Subject: Re: New SQR'r Thanks Denise, I did 'emulate' the actual code I was working on. So you can tell I am new to SQR. But thanks anyway. I am 3 months into the job here (former web developer and PowerHouse guru) and need all the help I can get. -Ken >>> dewhite@VICR.COM 04/02/02 05:50AM >>> Hi Ken, There are a few more problems with your code, but maybe you just didn't reproduce it exactly in your message, since you seem to be saying that it is working fine now. Anyway: You need a hyphen in 'end-select', instead of 'end select'. Also, the variables that you are assigning the selected columns to need prefixes to show the data type. Assuming they are character fields, your variables should be '$f1' and '$f2', not 'f1' and 'f2'. If they are numeric, use a '#' instead of '$'. HTH, Denise White Sr. Programmer/Analyst Vicor ------------------------------ Date: Mon, 1 Apr 2002 13:57:30 -0800 From: Ken Boettger Subject: Re: New SQR'r Thanks. It was the parenthesis. They were not explained well in the manuals I have here. I just needed that empty set of parens. Thanks. -Ken >>> spatel@ADMIN1.UMARYLAND.EDU 04/01/02 12:05PM >>> Ken, Try this... begin-select T.field1 () ON-BREAK PRINT=NEVER AFTER= T.field2 let f1 = &T.field1 let f2 = &T.field2 print f1 (+1,5) print f2 (,20) from table1 T end select -----Original Message----- From: Ken Boettger [mailto:BoettgeK@CWU.EDU] Sent: Monday, April 01, 2002 2:33 PM To: SQR-USERS@list.iex.net Subject: New SQR'r begin-select T.field1 T.field2 let f1 = &T.field1 let f2 = &T.field2 print f1 (+1,5) print f2 (,20) from table1 T end select Everything works fine until I put an ON-BREAK on field1: begin-select T.field1 on-break t.field2 let f1 = &T.field1 let f2 = &T.field2 print f1 (+1,5) print f2 (,20) from table1 T end select With this, I get errors that read: "Columns names and expressions must be unique or be given unique pseudonyms (&name)." "Referenced variables not defined" Can someone help explain to me the problem here? It seems the code is valid as it runs fine until I insert the ON-BREAK. Thanks. -Ken From owner-sqr-users@list.iex.net Mon Apr 1 15:50:29 2002 Date: Mon, 1 Apr 2002 15:48:16 -0500 From: Tom Cormier Subject: Re: SQR's documentation Hi, Go to www.manning.com and look up the book "SQR in PeopleSoft and Other Applications". They publish it and offer it for sale on their web site. Cost is $60 + shipping. Good book. From owner-sqr-users@list.iex.net Tue Apr 2 09:36:18 2002 Date: Tue, 2 Apr 2002 09:34:39 -0500 From: Jason Rupp Subject: Decimal Problem Hi All, I am converting a number to a string. I do not want the decimal to be in this string. Here is the code that I tried: Let $Annual_Pledge = edit(#Annual_Pledge, '999999999') I am not sure if it is possible to use an edit function on a number. Anyway, my result looks like this 000045.98 and I am looking for this 000004598. Any suggestions? Thanks! From owner-sqr-users@list.iex.net Tue Apr 2 09:58:09 2002 Date: Tue, 2 Apr 2002 09:52:25 -0500 From: Rod Wright Subject: Re: Decimal Problem Jason, I'm not sure why you're getting the decimal with that edit mask. Anyway, multiply your number by 100 before this Let statement. Rod Jason Rupp @list.iex.net> on 04/02/2002 09:34:39 AM Please respond to sqr-users@list.iex.net Sent by: "Discussion of SQR, Brio Software's database reporting language" To: SQR-USERS@list.iex.net cc: Subject: Decimal Problem Hi All, I am converting a number to a string. I do not want the decimal to be in this string. Here is the code that I tried: Let $Annual_Pledge = edit(#Annual_Pledge, '999999999') I am not sure if it is possible to use an edit function on a number. Anyway, my result looks like this 000045.98 and I am looking for this 000004598. Any suggestions? Thanks! From owner-sqr-users@list.iex.net Tue Apr 2 10:32:21 2002 Date: Tue, 2 Apr 2002 09:32:24 -0600 From: "Brickl, Maria" Subject: Pathnames in SQR I wonder if it is possible to use the UNC path where a file is located (\\pathname\directory\item.bmp) instead of the drive letters when writing SQR. WE have a number of users who have things specified in different directories and not always the same directory as one specifies. What would be easier if we could use the UNC path when we are calling images, etc. Is this possible and how do you write this in SQR? *~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~ Maria K Brickl Information Systems Programmer/Analyst University of Wisconsin Colleges 780 Regent St, PO Box 8680, Madison, WI 53708-8680 Phone: 608.265.2677 / Fax: 608.265.5770 *~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~* From owner-sqr-users@list.iex.net Tue Apr 2 12:37:00 2002 Date: Tue, 2 Apr 2002 11:31:26 -0600 From: "Mueller, Daniel" Subject: Re: Pathnames in SQR I do this, and it works just fine. here is an SQC we have: !******************************************************* ! NMHLOGO.SQC !******************************************************* ! Description: Declares the Northwestern Memorial Hospital (NMH) logo. ! Notes: This file must be included in the BEGIN-SETUP section ! Usage: PRINT-IMAGE NMH_Logo (line,col) - allows relative positioning !*************************************************************************** **** declare-image NMHLogo type = BMP-FILE !BMP-FILE | EPS-FILE | HPGL-FILE | JPEG-FILE | GIF-FILE source = '\\nmh-peoplesoft\apps\psoft\pt8batch\sqr\custom\nmhlogo.bmp' ! !must be in SQRDIR directory or fully qualified image-size = (40,4) !(width,height based on grid) - BMP is stretched or shrunk end-declare > -----Original Message----- > From: Brickl, Maria [SMTP:mbrickl@UWC.EDU] > Sent: Tuesday, April 02, 2002 9:32 AM > To: SQR-USERS@list.iex.net > Subject: Pathnames in SQR > > I wonder if it is possible to use the UNC path where a file is located > (\\pathname\directory\item.bmp) instead of the drive letters when writing > SQR. WE have a number of users who have things specified in different > directories and not always the same directory as one specifies. What would > be easier if we could use the UNC path when we are calling images, etc. Is > this possible and how do you write this in SQR? > > *~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~ > Maria K Brickl > Information Systems Programmer/Analyst > University of Wisconsin Colleges > 780 Regent St, PO Box 8680, Madison, WI 53708-8680 > Phone: 608.265.2677 / Fax: 608.265.5770 > *~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~* From owner-sqr-users@list.iex.net Tue Apr 2 13:55:30 2002 Date: Tue, 2 Apr 2002 13:41:28 -0500 From: "Chitty, David" Subject: Problem Using CALL to DOS Copy using Wildcards I am issuing a CALL in an SQR to copy multiple files into one file. The command works fine from the DOS prompt. It also works from the SQR if I provide the full name for one of the files. However, when I use the wildcard (WO*.POS)to reference all of the files, I receive an error. The program code is as follows: let $InputFile = 'c:\temp\hsnabchs.POS' let $copy_command = getenv('COMSPEC') || ' /c copy ' || 'c:\temp\WO*.POS ' || $InputFile call system using $copy_command #copy_status WAIT I also tried replacing copy with xcopy (the rest of the command line was left as is). It accepted the command but prompted me with a pop-up window (which I don't want) requesting an F or D to indicate whether a file or directory was being created. Any ideas? Dave Chitty This message may contain confidential information. We provide customer information to others only under certain circumstances, and based on representations that each applicable customer has authorized the disclosure. If any person makes a false or misleading representation to obtain customer information, that person may have committed a federal crime, and we may report any such incidence to the proper authorities. If you receive this in error, please notify the sender by reply fax or email and delete this message. If you properly received this message, you may use and distribute it only in accordance with our instructions and applicable law. HomeSide and it's affiliates do not represent, warrant or guarantee that the integrity of this communication has been maintained nor that the communication is free of errors, viruses or interference. From owner-sqr-users@list.iex.net Tue Apr 2 14:10:08 2002 Date: Tue, 2 Apr 2002 11:05:57 -0800 From: "Lynds,Rick" Subject: Re: Problem Using CALL to DOS Copy using Wildcards Your $copy_command does not include the $InputFile anywhere. Could that be the problem? HTH Rick -----Original Message----- From: Chitty, David [mailto:DPChitty@HOMESIDE.COM] Sent: Tuesday, April 02, 2002 10:41 AM To: SQR-USERS@list.iex.net Subject: Problem Using CALL to DOS Copy using Wildcards I am issuing a CALL in an SQR to copy multiple files into one file. The command works fine from the DOS prompt. It also works from the SQR if I provide the full name for one of the files. However, when I use the wildcard (WO*.POS)to reference all of the files, I receive an error. The program code is as follows: let $InputFile = 'c:\temp\hsnabchs.POS' let $copy_command = getenv('COMSPEC') || ' /c copy ' || 'c:\temp\WO*.POS ' || $InputFile call system using $copy_command #copy_status WAIT I also tried replacing copy with xcopy (the rest of the command line was left as is). It accepted the command but prompted me with a pop-up window (which I don't want) requesting an F or D to indicate whether a file or directory was being created. Any ideas? Dave Chitty This message may contain confidential information. We provide customer information to others only under certain circumstances, and based on representations that each applicable customer has authorized the disclosure. If any person makes a false or misleading representation to obtain customer information, that person may have committed a federal crime, and we may report any such incidence to the proper authorities. If you receive this in error, please notify the sender by reply fax or email and delete this message. If you properly received this message, you may use and distribute it only in accordance with our instructions and applicable law. HomeSide and it's affiliates do not represent, warrant or guarantee that the integrity of this communication has been maintained nor that the communication is free of errors, viruses or interference. From owner-sqr-users@list.iex.net Tue Apr 2 14:25:01 2002 Date: Tue, 2 Apr 2002 14:24:26 -0500 From: Prasanna Menta Subject: Re: Problem Using CALL to DOS Copy using Wildcards Hello David, This is an example of call system code to merge two files, you are missing the quotes, see if this is of use to you let $merge = getenv('COMSPEC') || ' /C copy ' || '""C:\TEMP\FILE1"" + ""C:\TEMP\file2"" ""C:\TEMP\FILE3""' call system using $merge #status Thanks Prasanna "Chitty, David" wrote: > > I am issuing a CALL in an SQR to copy multiple files into one file. The > command works fine from the DOS prompt. It also works from the SQR if I > provide the full name for one of the files. However, when I use the > wildcard (WO*.POS)to reference all of the files, I receive an error. > > The program code is as follows: > > let $InputFile = 'c:\temp\hsnabchs.POS' > let $copy_command = getenv('COMSPEC') || ' /c copy ' || 'c:\temp\WO*.POS ' > || $InputFile > > call system using $copy_command #copy_status WAIT > > I also tried replacing copy with xcopy (the rest of the command line was > left as is). It accepted the command but prompted me with a pop-up window > (which I don't want) requesting an F or D to indicate whether a file or > directory was being created. > > Any ideas? > > Dave Chitty > > This message may contain confidential information. We provide customer > information to others only under certain circumstances, and based on > representations that each applicable customer has authorized the disclosure. > If any person makes a false or misleading representation to obtain customer > information, that person may have committed a federal crime, and we may > report any such incidence to the proper authorities. If you receive this in > error, please notify the sender by reply fax or email and delete this > message. If you properly received this message, you may use and distribute > it only in accordance with our instructions and applicable law. HomeSide > and it's affiliates do not represent, warrant or guarantee that the > integrity of this communication has been maintained nor that the > communication is free of errors, viruses or interference. From owner-sqr-users@list.iex.net Tue Apr 2 14:31:51 2002 Date: Tue, 2 Apr 2002 13:30:50 -0600 From: "Mueller, Daniel" Subject: Re: Problem Using CALL to DOS Copy using Wildcards You receive an error? What does the error say? My guess is that when you wildcard the filename, it is probably PROMPTing you with an "are you sure you want to do this?" type of message. It may work when you do the DOS command because PROMPTING might be turned off when you open a MS-DOS window. Most command languanges have a command that turns off the interactive mode when you want to run something via batch and you want it to work no matter what In DOS, the parameter is /Y In a DOS window, do a COPY /? to receive help on the copy command. Microsoft(R) Windows 95 (C)Copyright Microsoft Corp 1981-1995. C:\WINDOWS>copy /? Copies one or more files to another location. COPY [/A | /B] source [/A | /B] [+ source [/A | /B] [+ ...]] [destination [/A | /B]] [/V] [/Y | /-Y] source Specifies the file or files to be copied. /A Indicates an ASCII text file. /B Indicates a binary file. destination Specifies the directory and/or filename for the new file(s). /V Verifies that new files are written correctly. /Y Suppresses prompting to confirm you want to overwrite an existing destination file. /-Y Causes prompting to confirm you want to overwrite an existing destination file. The switch /Y may be preset in the COPYCMD environment variable. This may be overridden with /-Y on the command line To append files, specify a single file for destination, but multiple files for source (using wildcards or file1+file2+file3 format). C:\WINDOWS> > -----Original Message----- > From: Chitty, David [SMTP:DPChitty@HOMESIDE.COM] > Sent: Tuesday, April 02, 2002 12:41 PM > To: SQR-USERS@list.iex.net > Subject: Problem Using CALL to DOS Copy using Wildcards > > I am issuing a CALL in an SQR to copy multiple files into one file. The > command works fine from the DOS prompt. It also works from the SQR if I > provide the full name for one of the files. However, when I use the > wildcard (WO*.POS)to reference all of the files, I receive an error. > > The program code is as follows: > > let $InputFile = 'c:\temp\hsnabchs.POS' > let $copy_command = getenv('COMSPEC') || ' /c copy ' || 'c:\temp\WO*.POS > ' > || $InputFile > > call system using $copy_command #copy_status WAIT > > I also tried replacing copy with xcopy (the rest of the command line was > left as is). It accepted the command but prompted me with a pop-up window > (which I don't want) requesting an F or D to indicate whether a file or > directory was being created. > > Any ideas? > > > Dave Chitty > > > This message may contain confidential information. We provide customer > information to others only under certain circumstances, and based on > representations that each applicable customer has authorized the > disclosure. > If any person makes a false or misleading representation to obtain > customer > information, that person may have committed a federal crime, and we may > report any such incidence to the proper authorities. If you receive this > in > error, please notify the sender by reply fax or email and delete this > message. If you properly received this message, you may use and distribute > it only in accordance with our instructions and applicable law. HomeSide > and it's affiliates do not represent, warrant or guarantee that the > integrity of this communication has been maintained nor that the > communication is free of errors, viruses or interference. From owner-sqr-users@list.iex.net Tue Apr 2 14:54:52 2002 Date: Tue, 2 Apr 2002 14:51:09 -0500 From: "Chitty, David" Subject: Re: Problem Using CALL to DOS Copy using Wildcards The copy works if I code the full file name as in Prasanna's example. However, when I use the wildcard because I could have one to many files (number and names unknown except for extension), the copy will not work. For example, the following will work: let $copy_command = 'copy ' || 'c:\temp\WO196808.POS ' || $InputFile call system using $copy_command #copy_status WAIT but the following will not work: let $copy_command = 'copy ' || 'c:\temp\*.POS ' || $InputFile call system using $copy_command #copy_status WAIT I tried Prasanna's idea of double-quotes (below is a sample) but without success. I believe the key is getting the system to accept the wildcard. let $copy_command = getenv('COMSPEC') || ' /c copy ' || '""c:\temp\*.POS"" ""c:\temp\hlnabchs.pos""' I also tried Daniel Mueller's suggestion of using the /Y (and even /-Y) parameter of the cmd.exe. Neither worked. The error I am receiving is as follows (you can see the expanded command as well): Copy Command: C:\WINNT\system32\cmd.exe /c /y copy c:\temp\*.POS c:\temp\hlnabchs.pos Copy Status: 255.000000 Dave Chitty -----Original Message----- From: Prasanna Menta [SMTP:pmenta@umuc.edu] Sent: Tuesday, April 02, 2002 2:24 PM To: sqr-users@list.iex.net Subject: Re: Problem Using CALL to DOS Copy using Wildcards Hello David, This is an example of call system code to merge two files, you are missing the quotes, see if this is of use to you let $merge = getenv('COMSPEC') || ' /C copy ' || '""C:\TEMP\FILE1"" + ""C:\TEMP\file2"" ""C:\TEMP\FILE3""' call system using $merge #status Thanks Prasanna "Chitty, David" wrote: > > I am issuing a CALL in an SQR to copy multiple files into one file. The > command works fine from the DOS prompt. It also works from the SQR if I > provide the full name for one of the files. However, when I use the > wildcard (WO*.POS)to reference all of the files, I receive an error. > > The program code is as follows: > > let $InputFile = 'c:\temp\hsnabchs.POS' > let $copy_command = getenv('COMSPEC') || ' /c copy ' || 'c:\temp\WO*.POS ' > || $InputFile > > call system using $copy_command #copy_status WAIT > > I also tried replacing copy with xcopy (the rest of the command line was > left as is). It accepted the command but prompted me with a pop-up window > (which I don't want) requesting an F or D to indicate whether a file or > directory was being created. > > Any ideas? > > Dave Chitty This message may contain confidential information. We provide customer information to others only under certain circumstances, and based on representations that each applicable customer has authorized the disclosure. If any person makes a false or misleading representation to obtain customer information, that person may have committed a federal crime, and we may report any such incidence to the proper authorities. If you receive this in error, please notify the sender by reply fax or email and delete this message. If you properly received this message, you may use and distribute it only in accordance with our instructions and applicable law. HomeSide and it's affiliates do not represent, warrant or guarantee that the integrity of this communication has been maintained nor that the communication is free of errors, viruses or interference. From owner-sqr-users@list.iex.net Tue Apr 2 16:05:04 2002 Date: Tue, 2 Apr 2002 14:59:16 -0600 From: "Mueller, Daniel" Subject: Re: Problem Using CALL to DOS Copy using Wildcards I just tried it in a DOS window, and I get the following error: "Content of destination lost before copy" I think you have a recursive error. Call the target file something that does not match the source wildcard name and it may work. > -----Original Message----- > From: Chitty, David [SMTP:DPChitty@HOMESIDE.COM] > Sent: Tuesday, April 02, 2002 1:51 PM > To: SQR-USERS@list.iex.net > Subject: Re: Problem Using CALL to DOS Copy using Wildcards > > The copy works if I code the full file name as in Prasanna's example. > However, when I use the wildcard because I could have one to many files > (number and names unknown except for extension), the copy will not work. > > For example, the following will work: > > let $copy_command = 'copy ' || 'c:\temp\WO196808.POS ' || $InputFile > call system using $copy_command #copy_status WAIT > > but the following will not work: > > let $copy_command = 'copy ' || 'c:\temp\*.POS ' || $InputFile > call system using $copy_command #copy_status WAIT > > I tried Prasanna's idea of double-quotes (below is a sample) but without > success. I believe the key is getting the system to accept the wildcard. > > let $copy_command = getenv('COMSPEC') || ' /c copy ' || > '""c:\temp\*.POS"" > ""c:\temp\hlnabchs.pos""' > > I also tried Daniel Mueller's suggestion of using the /Y (and even /-Y) > parameter of the cmd.exe. Neither worked. The error I am receiving is as > follows (you can see the expanded command as well): > > Copy Command: C:\WINNT\system32\cmd.exe /c /y copy c:\temp\*.POS > c:\temp\hlnabchs.pos > Copy Status: 255.000000 > > > Dave Chitty > > > -----Original Message----- > From: Prasanna Menta [SMTP:pmenta@umuc.edu] > Sent: Tuesday, April 02, 2002 2:24 PM > To: sqr-users@list.iex.net > Subject: Re: Problem Using CALL to DOS Copy using Wildcards > > Hello David, > This is an example of call system code to merge two files, you are > missing the quotes, see if this is of use to you > let $merge = getenv('COMSPEC') || ' /C copy ' || > '""C:\TEMP\FILE1"" > + > ""C:\TEMP\file2"" ""C:\TEMP\FILE3""' > call system using $merge #status > Thanks > Prasanna > "Chitty, David" wrote: > > > > I am issuing a CALL in an SQR to copy multiple files > into > one file. The > > command works fine from the DOS prompt. It also works > from the SQR if I > > provide the full name for one of the files. However, > when > I use the > > wildcard (WO*.POS)to reference all of the files, I > receive > an error. > > > > The program code is as follows: > > > > let $InputFile = 'c:\temp\hsnabchs.POS' > > let $copy_command = getenv('COMSPEC') || ' /c copy ' > || > 'c:\temp\WO*.POS ' > > || $InputFile > > > > call system using $copy_command #copy_status WAIT > > > > I also tried replacing copy with xcopy (the rest of the > command line was > > left as is). It accepted the command but prompted me > with > a pop-up window > > (which I don't want) requesting an F or D to indicate > whether a file or > > directory was being created. > > > > Any ideas? > > > > Dave Chitty > > > This message may contain confidential information. We provide customer > information to others only under certain circumstances, and based on > representations that each applicable customer has authorized the > disclosure. > If any person makes a false or misleading representation to obtain > customer > information, that person may have committed a federal crime, and we may > report any such incidence to the proper authorities. If you receive this > in > error, please notify the sender by reply fax or email and delete this > message. If you properly received this message, you may use and distribute > it only in accordance with our instructions and applicable law. HomeSide > and it's affiliates do not represent, warrant or guarantee that the > integrity of this communication has been maintained nor that the > communication is free of errors, viruses or interference. From owner-sqr-users@list.iex.net Tue Apr 2 17:00:11 2002 Date: Tue, 2 Apr 2002 21:55:32 +0000 From: Elvis Pressly Subject: Re: Problem Using CALL to DOS Copy using Wildcards Try the following: let $path = 'c:\temp' then with the rest of your original code: let $InputFile = 'c:\temp\hsnabchs.POS' let $copy_command = getenv('COMSPEC') || ' /c copy ' || $path ||'\WO*.POS*'|| ' '||$InputFile This one works for me. >From: "Chitty, David" >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Problem Using CALL to DOS Copy using Wildcards >Date: Tue, 2 Apr 2002 13:41:28 -0500 > >I am issuing a CALL in an SQR to copy multiple files into one file. The >command works fine from the DOS prompt. It also works from the SQR if I >provide the full name for one of the files. However, when I use the >wildcard (WO*.POS)to reference all of the files, I receive an error. > >The program code is as follows: > > let $InputFile = 'c:\temp\hsnabchs.POS' > let $copy_command = getenv('COMSPEC') || ' /c copy ' || 'c:\temp\WO*.POS >' >|| $InputFile > > call system using $copy_command #copy_status WAIT > >I also tried replacing copy with xcopy (the rest of the command line was >left as is). It accepted the command but prompted me with a pop-up window >(which I don't want) requesting an F or D to indicate whether a file or >directory was being created. > >Any ideas? > > >Dave Chitty > > >This message may contain confidential information. We provide customer >information to others only under certain circumstances, and based on >representations that each applicable customer has authorized the >disclosure. >If any person makes a false or misleading representation to obtain customer >information, that person may have committed a federal crime, and we may >report any such incidence to the proper authorities. If you receive this in >error, please notify the sender by reply fax or email and delete this >message. If you properly received this message, you may use and distribute >it only in accordance with our instructions and applicable law. HomeSide >and it's affiliates do not represent, warrant or guarantee that the >integrity of this communication has been maintained nor that the >communication is free of errors, viruses or interference. _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx From owner-sqr-users@list.iex.net Tue Apr 2 18:19:42 2002 Date: Tue, 2 Apr 2002 16:02:24 -0700 From: Raj Amoli Subject: Re: Problem Using CALL to DOS Copy using Wildcards David: Just try it without using 'WAIT' in the command. It might work. Raj >From: "Chitty, David" >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Re: Problem Using CALL to DOS Copy using Wildcards >Date: Tue, 2 Apr 2002 14:51:09 -0500 >MIME-Version: 1.0 >Received: from [66.179.72.105] by hotmail.com (3.2) with ESMTP id >MHotMailBE73596900C34004311142B34869F6A30; Tue, 02 Apr 2002 12:03:08 -0800 >Received: from list.iex.net (list.iex.net [66.179.72.105])by list.iex.net >(8.11.1/8.11.1) with ESMTP id g32Jd1H19558;Tue, 2 Apr 2002 12:39:01 -0700 >(MST) >Received: from LIST.IEX.NET by LIST.IEX.NET (LISTSERV-TCP/IP release 1.8d) >with spool id 833995 for SQR-USERS@LIST.IEX.NET; Tue, 2 Apr 2002 >12:38:59 -0700 >Received: from smtp2.homeside.com ([12.27.152.125]) by list.iex.net > (8.11.1/8.11.1) with ESMTP id g32JcuH19546 for >; Tue, 2 Apr 2002 12:38:57 -0700 (MST) >Received: by hslnt98jax.homeside.com with Internet Mail Service >(5.5.2653.19) id ; Tue, 2 Apr 2002 14:51:10 -0500 >From owner-sqr-users@list.iex.net Tue, 02 Apr 2002 12:05:09 -0800 >X-Mailer: Internet Mail Service (5.5.2653.19) >Message-ID: ><4A2CA05A2E84D511A2ED0008C791FB3A37CD7F@hslnt94jax.homeside.com> >Sender: "Discussion of SQR, Brio Software's database reporting language" > > >The copy works if I code the full file name as in Prasanna's example. >However, when I use the wildcard because I could have one to many files >(number and names unknown except for extension), the copy will not work. > >For example, the following will work: > > let $copy_command = 'copy ' || 'c:\temp\WO196808.POS ' || $InputFile > call system using $copy_command #copy_status WAIT > >but the following will not work: > > let $copy_command = 'copy ' || 'c:\temp\*.POS ' || $InputFile > call system using $copy_command #copy_status WAIT > >I tried Prasanna's idea of double-quotes (below is a sample) but without >success. I believe the key is getting the system to accept the wildcard. > > let $copy_command = getenv('COMSPEC') || ' /c copy ' || >'""c:\temp\*.POS"" >""c:\temp\hlnabchs.pos""' > >I also tried Daniel Mueller's suggestion of using the /Y (and even /-Y) >parameter of the cmd.exe. Neither worked. The error I am receiving is as >follows (you can see the expanded command as well): > > Copy Command: C:\WINNT\system32\cmd.exe /c /y copy c:\temp\*.POS >c:\temp\hlnabchs.pos > Copy Status: 255.000000 > > >Dave Chitty > > > -----Original Message----- > From: Prasanna Menta [SMTP:pmenta@umuc.edu] > Sent: Tuesday, April 02, 2002 2:24 PM > To: sqr-users@list.iex.net > Subject: Re: Problem Using CALL to DOS Copy using Wildcards > > Hello David, > This is an example of call system code to merge two files, you are > missing the quotes, see if this is of use to you > let $merge = getenv('COMSPEC') || ' /C copy ' || >'""C:\TEMP\FILE1"" >+ > ""C:\TEMP\file2"" ""C:\TEMP\FILE3""' > call system using $merge #status > Thanks > Prasanna > "Chitty, David" wrote: > > > > I am issuing a CALL in an SQR to copy multiple files >into >one file. The > > command works fine from the DOS prompt. It also works >from the SQR if I > > provide the full name for one of the files. However, >when >I use the > > wildcard (WO*.POS)to reference all of the files, I >receive >an error. > > > > The program code is as follows: > > > > let $InputFile = 'c:\temp\hsnabchs.POS' > > let $copy_command = getenv('COMSPEC') || ' /c copy ' >|| >'c:\temp\WO*.POS ' > > || $InputFile > > > > call system using $copy_command #copy_status WAIT > > > > I also tried replacing copy with xcopy (the rest of the >command line was > > left as is). It accepted the command but prompted me >with >a pop-up window > > (which I don't want) requesting an F or D to indicate >whether a file or > > directory was being created. > > > > Any ideas? > > > > Dave Chitty > > >This message may contain confidential information. We provide customer >information to others only under certain circumstances, and based on >representations that each applicable customer has authorized the >disclosure. >If any person makes a false or misleading representation to obtain customer >information, that person may have committed a federal crime, and we may >report any such incidence to the proper authorities. If you receive this in >error, please notify the sender by reply fax or email and delete this >message. If you properly received this message, you may use and distribute >it only in accordance with our instructions and applicable law. HomeSide >and it's affiliates do not represent, warrant or guarantee that the >integrity of this communication has been maintained nor that the >communication is free of errors, viruses or interference. _________________________________________________________________ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Apr 3 09:24:19 2002 Date: Wed, 3 Apr 2002 09:20:59 -0500 From: "Chitty, David" Subject: Re: Problem Using CALL to DOS Copy using Wildcards Removing the WAIT parameter on the CALL command worked. To complete the effort, I had to add a 'bogus' WHILE loop after the CALL to give the copy enough time to finish before attempting to open the new file in the program. let #x = 0 while #x < 100000 add 1 to #x end-while Thanks you to everyone that offered ideas. This was my first time using the SQR Users Group for soliciting ideas and it proved to be a beneficial experience. Dave Chitty -----Original Message----- From: Raj Amoli [SMTP:rajkamoli@HOTMAIL.COM] Sent: Tuesday, April 02, 2002 6:02 PM To: SQR-USERS@list.iex.net Subject: Re: Problem Using CALL to DOS Copy using Wildcards David: Just try it without using 'WAIT' in the command. It might work. Raj This message may contain confidential information. We provide customer information to others only under certain circumstances, and based on representations that each applicable customer has authorized the disclosure. If any person makes a false or misleading representation to obtain customer information, that person may have committed a federal crime, and we may report any such incidence to the proper authorities. If you receive this in error, please notify the sender by reply fax or email and delete this message. If you properly received this message, you may use and distribute it only in accordance with our instructions and applicable law. HomeSide and it's affiliates do not represent, warrant or guarantee that the integrity of this communication has been maintained nor that the communication is free of errors, viruses or interference. From owner-sqr-users@list.iex.net Tue Apr 2 15:44:03 2002 Date: Tue, 2 Apr 2002 13:41:13 -0700 From: "Merritt, Bruce" Subject: XML Procesing with SQR Hi All, We are currently using SQR version 6.1.3, and in the near future will have to receive and send data between our system and a third party using XML. Has anyone done any XML processing with SQR? Thanks Bruce Merritt University of Southern Colorado From owner-sqr-users@list.iex.net Tue Apr 2 16:26:39 2002 Date: Tue, 2 Apr 2002 15:26:46 -0600 From: Tom Whipple Subject: Re: XML Procesing with SQR Hello, We too are about to produce XML output with v6.2. I have seen the code for XML generated by report builder. Not suprisingly, it's ugly. I intend to begin the XML project in a week or two. -tom -----Original Message----- From: Merritt, Bruce [mailto:Merritt@USCOLO.EDU] Sent: Tuesday, April 02, 2002 2:41 PM To: SQR-USERS@list.iex.net Subject: XML Procesing with SQR Hi All, We are currently using SQR version 6.1.3, and in the near future will have to receive and send data between our system and a third party using XML. Has anyone done any XML processing with SQR? Thanks Bruce Merritt University of Southern Colorado From owner-sqr-users@list.iex.net Thu Apr 4 18:47:53 2002 Date: Thu, 4 Apr 2002 18:42:40 -0500 From: Ray Ontko Subject: Re: XML Procesing with SQR Tom, Bruce, Writing XML is fairly easy to do with SQR using WRITE or PRINT. If you're writing your own code (instead of using Brio ReportBuilder generated code), you have more control over the structure of the output. Reading XML is the challenging part. This can be done with SQR/DDO (Direct Data Objects), or you can write your own XML parser in SQR. Brio ReportBuilder doesn't support DDO access to XML, so this would need to be written as a regular SQR/DDO program. Writing an XML parser from scratch is fairly complex, even if it's a non-validating parser, but it can certainly be done in SQR. It's the kind of program I'd like to write. If you need read XML with SQR, I'd strongly recommend that you look at SQR/DDO. Ray [Charset iso-8859-1 unsupported, filtering to ASCII...] > Hello, > > We too are about to produce XML output with v6.2. I have seen the code for > XML generated by report builder. Not suprisingly, it's ugly. I intend to > begin the XML project in a week or two. > > -tom > > -----Original Message----- > From: Merritt, Bruce [mailto:Merritt@USCOLO.EDU] > Sent: Tuesday, April 02, 2002 2:41 PM > To: SQR-USERS@list.iex.net > Subject: XML Procesing with SQR > > > Hi All, > > We are currently using SQR version 6.1.3, and in the near future will have > to receive and send data between our system and a third party using XML. Has > anyone done any XML processing with SQR? > > Thanks > > Bruce Merritt > University of Southern Colorado > ---------------------------------------------------------------------- Ray Ontko rayo@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ From owner-sqr-users@list.iex.net Fri Apr 5 11:16:51 2002 Date: Fri, 5 Apr 2002 09:06:07 -0700 From: "Merritt, Bruce" Subject: Re: XML Procesing with SQR Thanks Ray, That what I thought, writing would be easy, but reading would be difficult, and yes we will have to read the XML file. Where do I find documentation and SQR/DDO? Do you know if SQR support OLE on the windows platform. The reason I am asking is because if it does, then I could write an SQR program that could manipulate Microsoft's XML parser object and use it for validation? Thanks Bruce -----Original Message----- From: Ray Ontko [mailto:rayo@ONTKO.COM] Sent: Thursday, April 04, 2002 4:43 PM To: SQR-USERS@list.iex.net Subject: Re: XML Procesing with SQR Tom, Bruce, Writing XML is fairly easy to do with SQR using WRITE or PRINT. If you're writing your own code (instead of using Brio ReportBuilder generated code), you have more control over the structure of the output. Reading XML is the challenging part. This can be done with SQR/DDO (Direct Data Objects), or you can write your own XML parser in SQR. Brio ReportBuilder doesn't support DDO access to XML, so this would need to be written as a regular SQR/DDO program. Writing an XML parser from scratch is fairly complex, even if it's a non-validating parser, but it can certainly be done in SQR. It's the kind of program I'd like to write. If you need read XML with SQR, I'd strongly recommend that you look at SQR/DDO. Ray [Charset iso-8859-1 unsupported, filtering to ASCII...] > Hello, > > We too are about to produce XML output with v6.2. I have seen the code for > XML generated by report builder. Not suprisingly, it's ugly. I intend to > begin the XML project in a week or two. > > -tom > > -----Original Message----- > From: Merritt, Bruce [mailto:Merritt@USCOLO.EDU] > Sent: Tuesday, April 02, 2002 2:41 PM > To: SQR-USERS@list.iex.net > Subject: XML Procesing with SQR > > > Hi All, > > We are currently using SQR version 6.1.3, and in the near future will have > to receive and send data between our system and a third party using XML. Has > anyone done any XML processing with SQR? > > Thanks > > Bruce Merritt > University of Southern Colorado > ---------------------------------------------------------------------- Ray Ontko rayo@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ From owner-sqr-users@list.iex.net Fri Apr 5 12:31:14 2002 Date: Fri, 5 Apr 2002 12:23:57 -0500 From: Ray Ontko Subject: Re: XML Procesing with SQR Bruce, Information on DDO-specific features of the SQR language are included in the SQR documentation set starting with version 5.1, I think. Take a look at the commands ALTER-CONNECTION, BEGIN-EXECUTE (which has its own flavor of BEGIN-SELECT), CONNECTION, DECLARE-CONNECTION, and LOAD-LOOKUP. Also, take a look at command line option -ZRF. DDO is Brio's "Direct Data Objects" technology. It provides access to a wide variety of data sources, not just relational. You can use it to access JDBC, SAP/BAPI, XML, CSV, Essbase OLAP cubes, DCOM, and CORBA. What's more, it's extensible. You can write your own drivers to access data in custom data sources and applications. When you purchase SQR, you can purchase SQR with the DDO data source drivers (instead of SQR/Oracle, for example). Brio ReportBuilder also provides support for DDO, but you need PersonalSQR/DDO. Also it can only build JDBC and SAP/BAPI reports using the report creation wizards and templates. The other data source types don't (currently) provide enough catalog information to be able to work with the report creation wizards. You can get a copy of SQR/DDO from Brio or any authorized Brio Reseller. Ray Ontko & Co is a reseller. Give me a call 765-935-4283, or call your Brio sales person. You should be able to use the UFUNC mechanism of SQR under Windows to access any Microsoft DLL. If you want to use OLE directly from SQR, you'll probably have to take this path. Ray [Charset iso-8859-1 unsupported, filtering to ASCII...] > Thanks Ray, > > That what I thought, writing would be easy, but reading would be difficult, > and yes we will have to read the XML file. > > Where do I find documentation and SQR/DDO? > > Do you know if SQR support OLE on the windows platform. The reason I am > asking is because if it does, then I could write an SQR program that could > manipulate Microsoft's XML parser object and use it for validation? > > Thanks > > Bruce > > -----Original Message----- > From: Ray Ontko [mailto:rayo@ONTKO.COM] > Sent: Thursday, April 04, 2002 4:43 PM > To: SQR-USERS@list.iex.net > Subject: Re: XML Procesing with SQR > > Tom, Bruce, > > Writing XML is fairly easy to do with SQR using WRITE or PRINT. > If you're writing your own code (instead of using Brio ReportBuilder > generated code), you have more control over the structure of the output. > > Reading XML is the challenging part. This can be done with > SQR/DDO (Direct Data Objects), or you can write your own XML > parser in SQR. Brio ReportBuilder doesn't support DDO access > to XML, so this would need to be written as a regular SQR/DDO > program. > > Writing an XML parser from scratch is fairly complex, even if it's > a non-validating parser, but it can certainly be done in SQR. It's > the kind of program I'd like to write. > > If you need read XML with SQR, I'd strongly recommend that you > look at SQR/DDO. > > Ray > > [Charset iso-8859-1 unsupported, filtering to ASCII...] > > Hello, > > > > We too are about to produce XML output with v6.2. I have seen the code > for > > XML generated by report builder. Not suprisingly, it's ugly. I intend to > > begin the XML project in a week or two. > > > > -tom > > > > -----Original Message----- > > From: Merritt, Bruce [mailto:Merritt@USCOLO.EDU] > > Sent: Tuesday, April 02, 2002 2:41 PM > > To: SQR-USERS@list.iex.net > > Subject: XML Procesing with SQR > > > > > > Hi All, > > > > We are currently using SQR version 6.1.3, and in the near future will have > > to receive and send data between our system and a third party using XML. > Has > > anyone done any XML processing with SQR? > > > > Thanks > > > > Bruce Merritt > > University of Southern Colorado > > > > ---------------------------------------------------------------------- > Ray Ontko rayo@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 > Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > ---------------------------------------------------------------------- Ray Ontko rayo@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ From owner-sqr-users@list.iex.net Tue Apr 2 17:04:30 2002 Date: Tue, 2 Apr 2002 16:55:43 -0500 From: Denise White Subject: End-of-file on SELECT Hi, I am trying to write a report that has several ON-BREAK levels. I need to be able to detect when I am at the end of the select (the equivalent of an end-of-file condition on a flat file). I will try to explain what I am trying to do and hopefully it will not be too confusing! On the top two levels (region_cd & support_team_mbr), I need to page break. On the major level, region_cd, I want to do the page break every time - no problem. However, on the support_team_mbr, if it is the last in the region_cd, I only want to skip a line and then print the region_cd totals; the page break will come after the region_cd totals. If the support_team_mbr is not the last in the region_cd, I do want to do a page break. Something like this: [detail lines] support_team_mbr 1 totals region_cd 1 totals [page break] [detail lines] support_team_mbr 2 totals [page break] [detail lines] support_team_mbr 3 totals region_cd 2 totals (includes support_team_mbr 2 + 3) So, here are my on-break clauses: v.region_cd () on-break print=never after=Region-Brk save=$hold_region level=1 m.support_team_mbr () on-break print=never after=Team-Mbr-Brk save=$hold_team_mbr level=2 In my Team-Mbr-Brk procedure, I have the following: if &v.region_cd = $hold_region and not isnull(&v.region_cd) new-page else position (+1) end-if This works fine, until I hit the end of the select. There, it prints the last support_team_mbr totals, does a page break, and prints the region_cd totals! I added the not isnull() condition, thinking that at the end, null values would have been returned to signal the program that it was finished, but apparently it does not return a null row, but retains the last values. So, at the end, &v.region_cd does equal $hold_region. Is there anything I can add to the condition so that at the end of the select, it falls into the 'else'? It would also help me in my header, so I could blank out some values I am printing in the header when I print the grand totals on a final page, and would prefer to not see the last values still printing. TIA! Denise White Sr. Software Engineer Vicor From owner-sqr-users@list.iex.net Tue Apr 2 17:23:04 2002 Date: Tue, 2 Apr 2002 17:22:37 -0500 From: Prasanna Menta Subject: Re: End-of-file on SELECT Just add skip lines=1 at the respective procedure where the break is taking place, alternatively you could move the region_Cd to a variable and check if this variable is not the same if this is different have a line skipped. Example move $region_cd to $oldregion_cd If $region_cd <> $oldregion_cd skiplines =1 end-if Thanks Denise White wrote: > > Hi, > > I am trying to write a report that has several ON-BREAK levels. I need to be > able to detect when I am at the end of the select (the equivalent of an > end-of-file condition on a flat file). I will try to explain what I am trying > to do and hopefully it will not be too confusing! > > On the top two levels (region_cd & support_team_mbr), I need to page break. On > the major level, region_cd, I want to do the page break every time - no problem. > However, on the support_team_mbr, if it is the last in the region_cd, I only > want to skip a line and then print the region_cd totals; the page break will > come after the region_cd totals. If the support_team_mbr is not the last in the > region_cd, I do want to do a page break. Something like this: > > [detail lines] > support_team_mbr 1 totals > > region_cd 1 totals > > [page break] > > [detail lines] > support_team_mbr 2 totals > > [page break] > > [detail lines] > support_team_mbr 3 totals > > region_cd 2 totals (includes support_team_mbr 2 + 3) > > So, here are my on-break clauses: > > v.region_cd () on-break print=never after=Region-Brk > save=$hold_region level=1 > m.support_team_mbr () on-break print=never after=Team-Mbr-Brk > save=$hold_team_mbr level=2 > > In my Team-Mbr-Brk procedure, I have the following: > > if &v.region_cd = $hold_region and not isnull(&v.region_cd) > new-page > else > position (+1) > end-if > > This works fine, until I hit the end of the select. There, it prints the last > support_team_mbr totals, does a page break, and prints the region_cd totals! I > added the not isnull() condition, thinking that at the end, null values would > have been returned to signal the program that it was finished, but apparently it > does not return a null row, but retains the last values. So, at the end, > &v.region_cd does equal $hold_region. Is there anything I can add to the > condition so that at the end of the select, it falls into the 'else'? It would > also help me in my header, so I could blank out some values I am printing in the > header when I print the grand totals on a final page, and would prefer to not > see the last values still printing. > > TIA! > > Denise White > Sr. Software Engineer > Vicor From owner-sqr-users@list.iex.net Wed Apr 3 09:23:07 2002 Date: Wed, 3 Apr 2002 07:18:44 -0600 From: Kristy Engelkes Subject: Re: End-of-file on SELECT I think you should be able to use a before procedure for printing the page break on support_team_mbr. You would need a flag to know not to page break initially. But otherwise, it would close-out the previous support_team_mbr. Denise White @list.iex.net> on 04/02/2002 04:55:43 PM Please respond to sqr-users@list.iex.net Sent by: "Discussion of SQR, Brio Software's database reporting language" To: SQR-USERS@list.iex.net cc: Subject: End-of-file on SELECT Hi, I am trying to write a report that has several ON-BREAK levels. I need to be able to detect when I am at the end of the select (the equivalent of an end-of-file condition on a flat file). I will try to explain what I am trying to do and hopefully it will not be too confusing! On the top two levels (region_cd & support_team_mbr), I need to page break. On the major level, region_cd, I want to do the page break every time - no problem. However, on the support_team_mbr, if it is the last in the region_cd, I only want to skip a line and then print the region_cd totals; the page break will come after the region_cd totals. If the support_team_mbr is not the last in the region_cd, I do want to do a page break. Something like this: [detail lines] support_team_mbr 1 totals region_cd 1 totals [page break] [detail lines] support_team_mbr 2 totals [page break] [detail lines] support_team_mbr 3 totals region_cd 2 totals (includes support_team_mbr 2 + 3) So, here are my on-break clauses: v.region_cd () on-break print=never after=Region-Brk save=$hold_region level=1 m.support_team_mbr () on-break print=never after=Team-Mbr-Brk save=$hold_team_mbr level=2 In my Team-Mbr-Brk procedure, I have the following: if &v.region_cd = $hold_region and not isnull(&v.region_cd) new-page else position (+1) end-if This works fine, until I hit the end of the select. There, it prints the last support_team_mbr totals, does a page break, and prints the region_cd totals! I added the not isnull() condition, thinking that at the end, null values would have been returned to signal the program that it was finished, but apparently it does not return a null row, but retains the last values. So, at the end, &v.region_cd does equal $hold_region. Is there anything I can add to the condition so that at the end of the select, it falls into the 'else'? It would also help me in my header, so I could blank out some values I am printing in the header when I print the grand totals on a final page, and would prefer to not see the last values still printing. TIA! Denise White Sr. Software Engineer Vicor From owner-sqr-users@list.iex.net Wed Apr 3 11:15:04 2002 Date: Wed, 3 Apr 2002 11:13:44 -0500 From: Nathan Stratton Treadway Subject: Re: End-of-file on SELECT On Tue, Apr 02, 2002 at 04:55:43PM -0500, Denise White wrote: > On the top two levels (region_cd & support_team_mbr), I need to page > break. On the major level, region_cd, I want to do the page break > every time - no problem. > However, on the support_team_mbr, if it is the last in the region_cd, I only > want to skip a line and then print the region_cd totals; the page break will > come after the region_cd totals. If the support_team_mbr is not the last in the > region_cd, I do want to do a page break. Something like this: > > [detail lines] > support_team_mbr 1 totals > > region_cd 1 totals > > [page break] > > [detail lines] > support_team_mbr 2 totals > > [page break] > > [detail lines] > support_team_mbr 3 totals > > region_cd 2 totals (includes support_team_mbr 2 + 3) > > So, here are my on-break clauses: > > v.region_cd () on-break print=never after=Region-Brk > save=$hold_region level=1 > m.support_team_mbr () on-break print=never after=Team-Mbr-Brk > save=$hold_team_mbr level=2 > > In my Team-Mbr-Brk procedure, I have the following: > > if &v.region_cd = $hold_region and not isnull(&v.region_cd) > new-page > else > position (+1) > end-if > > This works fine, until I hit the end of the select. There, it prints the last > support_team_mbr totals, does a page break, and prints the region_cd totals! I > added the not isnull() condition, thinking that at the end, null values would > have been returned to signal the program that it was finished, but apparently it > does not return a null row, but retains the last values. So, at the end, > &v.region_cd does equal $hold_region. Is there anything I can add to the > condition so that at the end of the select, it falls into the 'else'? It would > also help me in my header, so I could blank out some values I am printing in the > header when I print the grand totals on a final page, and would prefer to not > see the last values still printing. A few thoughts: As an aside: SQR leaves the value of the last row selected in the & variables so that you can use those values later on in your program. Normally, the easy way to tell that you have finished processing all the rows from a select is that program execution drops past the END-SELECT. This should be good enough to fix the headers on the grand total page: right after the END-SELECT, but before you actually print the grand totals, just blank out the variables that you want to surpress from the header. That way, when the grand total page is "ejected" and the BEGIN-HEADING section is printed, those values will be blank. (Alternatively, you could set a "done-with-select" flag variable, and then check that variable in the BEGIN-HEADING to decide whether or not to print certain lines of the heading.) Controlling when to do the page breaks within the select is more difficult. Essentially, you need to know when you print the support_team_mbr totals if you are going to also be printing the region totals right afterwards. A more general way to phrase this question is "At which break level was this break triggered?" In other words, what you want to know in the support_team_mbr AFTER procedure (which is level=2) is whether it is being executed because of a level 2 break (in which case the level 1 procedure will not be executed, and the page break should be generated by this procedure) or because of a level 1 break (in which case this procedure should allow the the page break to be generated by the level 1 procedure). This is a common situation, but unfortunately SQR does not currently have a way to give your program this information. (You'll find this topic on our Suggested Enhancements page, http://www.ontko.com/sqr/enhancements.html ; currently it's Enhancement #5). I don't know of a good way to tell, from within an AFTER procedure, if the row of data just processed was the last row or not. What I do in this situation is use a flag set in the AFTER procedures to indicate to the BEFORE procedures that they need to do do the page breaking before they do the processing they'd normally do. (Normally I'd call the "check" procedure from the very top of my existing BEFORE procedures, but since you don't have any BEFORE procedures you can probably use the "check" procedure itself as the BEFORE procedures, as I've shown below.) So, your program would look something like this: begin-procedure main move 0 to #need_page_break begin-select v.region_cd () on-break print=never level=1 before=check_need_page_break after=after_region save=$hold_region m.support_team_mbr () on-break print=never level=2 before=check_need_page_break after=after_support_team_mbr save=$hold_team_mbr ETC... end-select do check_need_page_break move '' to $hold_region move '' to $hold_team_mbr do print_grand_totals ETC... end-procedure ! main begin-procedure after_region ! print region totals ETC.... move 1 to #need_page_break end-procedure ! after_region begin-procedure after_support_team_mbr ! print support team mbr totals ETC.... move 1 to #need_page_break end-procedure ! after_support_team_mbr begin-procedure check_need_page_break if #need_page_break new-page move 0 to #need_page_break end-if end-procedure ! after_support_team_mbr Note that you need a final "check" call after the END-SELECT to be sure that the final page break is generated before the grant total page is printed. Also, you need to make sure the "check" call is invoked before anything is printed in any BEFORE procedure at any level, or things will start showing up on the wrong page. This approach works because one of the BEFORE procedures is always the first thing to execute after the last AFTER procedure executes in a particular cycle of the BREAK processing (*). We can't tell from within the AFTER if another AFTER procedure is just about to be executed, but once we start processing the BEFOREs, we know all the AFTERs have completed. If the first thing the BEFORE procedure does is check to see if the page break is needed, then the page break will always happen immediately following of the last AFTER procedure that got executed on this cycle. (*) except when the AFTER is from the last row of data -- that's why we need another "check" after the END_SELECT Hope this makes sense.... Let me know if I can explain any aspect further. Nathan ---------------------------------------------------------------------------- Nathan Stratton Treadway | Ray Ontko & Co. | Software consulting services nathant@ontko.com | Richmond, IN | http://www.ontko.com/ From owner-sqr-users@list.iex.net Wed Apr 3 11:35:09 2002 Date: Wed, 3 Apr 2002 11:34:10 -0500 From: Don Mellen Subject: Re: End-of-file on SELECT Denise, This is a different way of approaching it so that you don't need to know when the select is done. What I often do when I need a single page-break after multiple possible "after/total" breaks is to use a numeric as a logical flag and the before= option. Something like... move 0 to #need_new_page begin-select xxx &x () on-break print=never before=pre_x after=post_x level=1 yyy &y () on-break print=never before=pre_y after=post_y level=2 ... yadda yadda yadda end-select And then have sections in the before and after procs like.... begin-procedure pre_x if #need_new_page new-page move 0 to #need_new_page end-if ! Store "heading" values ........ yadda yadda yadda end-procedure begin-procedure pre_y if #need_new_page new-page move 0 to #need_new_page end-if ! Store "heading" values ........ yadda yadda yadda end-procedure begin-procedure post_y move 1 to #need_new_page ........ yadda yadda yadda end-procedure begin-procedure post_x move 1 to #need_new_page ........ yadda yadda yadda end-procedure Notice the comments about storing heading values. Because this fires off the new-page in the "before=", you need to specifically save the heading values into variables since the "save=" option will have already reset. Using this, you could have 7 different break levels, all with totals, and all the totals needed would print on the same page, then 1 single new-page would fire off, but only if there were more returns from the select. HTH, ----------------------------------------------------------------------- Donald Mellen | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/ donm@ontko.com | "In the beginning, there was nothing, which exploded" From owner-sqr-users@list.iex.net Thu Apr 4 09:30:10 2002 Date: Thu, 4 Apr 2002 09:21:20 -0500 From: Denise White Subject: Re: End-of-file on SELECT Hi, Thanks to all who responded to my problem! In the interest of going with the most simple solution (all that juggling of before & after procedures does not qualify, even if it might work - LOL!), the following is how I resolved the two issues I had: Per a suggestion from Joy Hoyte, I was able to get the page break to work correctly by adding a condition checking that the team member was not equal, while the region was: if &v.region_cd = $hold_region and &m.support_team_mbr <> $hold_team_mbr new-page else position (+1) end-if Per Nathan's answer, I moved null values to my header variables just before printing the grand totals. I knew there had to be simple solutions that I just couldn't see. That's what's great about this forum - sometimes you just need another pair of eyes to take a look and see the obvious. Everything's working fine now! Thanks again, Denise White Sr. Software Engineer Vicor From owner-sqr-users@list.iex.net Tue Apr 2 19:12:30 2002 Date: Tue, 2 Apr 2002 19:08:12 -0500 From: Andrew Lin Subject: sending esc codes to printer Hi all, I've got several questions regarding esc sequences with HP printers. First off, is it possible to toggle that cover sheet that prints on a unix printer using an sqr? Or is that strictly controlled at a hardware level? Is there some esc sequence that could turn off that sheet? Secondly, I'm trying to choose which tray to print to. First I tried using the esc sequence to choose 'legal' size in the hopes that the printer would be intelligent enough to automatically choose the correct tray. ENCODE '<27>&l3A' INTO $legal_code print $legal_code (,) code that didn't work. Secondly, I tried to designate the actual tray (3). encode '<27>&l5H' into $tray3 print $tray3 (,) code that didn't work. In either case, the printer tries to print to tray1. The user must then manually tell the printer (HP4050N) to use tray 3. (printer reports that tray 1 is empty, blinks in protest, user presses go, and printer offers option to use tray 3 instead) Does it matter where I print the encoded statement? I print it early on in my sqr (before any other print statements). (this is the PS check print program) Any tips are greatly appreciated. Thanks. -Andrew From owner-sqr-users@list.iex.net Tue Apr 2 19:32:49 2002 Date: Tue, 2 Apr 2002 19:30:55 EST From: NEDOLPH@AOL.COM Subject: Re: sending esc codes to printer It is possible that a New Page command is outputting an escape E or printer reset at the start of each physical page. you might try forcing your select tray 3 command both before and after any new page command. (belt and suspenders) the new page or print header may be flushing your set up string. If your environment is shared, especially if the system prints a separator page between jobs, the network system may be generating the Escape E as part of the separator page sequence. I don't think you can select that tray too often. I have had the same problem with fonts set up at the top of the job being scrubbed away after the delivery of the first page hope this helps ps I assume you are printing on legal paper in tray 3 because if you are calling for a "mixed" combination where for example (in Ms word) you are calling for a 14 inch document and are sending the output to a tray holding letter size paper. the system will hang. asking you to change paper trays. maybe something like that is afoot. all best, Norman dolph From owner-sqr-users@list.iex.net Wed Apr 3 11:11:29 2002 Date: Wed, 3 Apr 2002 11:07:29 -0500 From: "Hood Louise (app1lxh)" Subject: text editor Hi everyone! I was wondering if anyone knows of a "text editor" (similar to Wordpad and Notepad), but the window shows line number and character position you are positioned at in the info bar at the bottom. This is really helpful for examining input/output data files when you are concerned with character position. I had a program like this where I used to work but can't remember the name of it. Any suggestions? Thanks From owner-sqr-users@list.iex.net Wed Apr 3 11:16:54 2002 Date: Wed, 3 Apr 2002 11:12:55 -0500 From: "Beller, Jay" Subject: Re: text editor CodeWright by Premia is an excellent ed