From owner-sqr-users@list.iex.net Sun Oct 1 00:10:20 2000 Date: Sun, 1 Oct 2000 00:00:02 -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.5 $ $Date: 1999-08-31 18:59:00-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 1999/04/30: o Reflected the takeover of SQRIBE Technologies by Brio Technology and the resulting new product names (throughout document). o Added additional hints to the "Posting to the sqr-users List" section. 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 Brio website has more information on the merger. 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 (C)Copyright 1999 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 psusers : PeopleSoft Users For questions related to any aspect of PeopleSoft (including PeopleSoft-specific SQR issues). To join, follow the link above, or send any message to "psusers-subscribe@egroups.com" . 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 SQR-related job announcements are currently allowed on the list, subject to the following restrictions: o The subject line must begin with the words "JOB ANNOUNCEMENT:". o The message should be very short (fewer than 20 lines), giving brief details of the job and a way for those interested to get more information directly (i.e. web page or phone number). o The message should specifically remind people interested in the job to respond directly to the message author (and not to use their mailer's "reply" function, since that would send the reply out on the list). o Post job announcements as infrequently as possible. From owner-sqr-users@list.iex.net Mon Oct 2 13:05:18 2000 Date: Mon, 2 Oct 2000 13:49:20 EDT From: Manoj Gurjar Subject: Re: Dynamic SQL with the FROM clause use [ ] as : FROM [$tablename] ! this is possible!!! >From: Jim Ebert >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Dynamic SQL with the FROM clause >Date: Fri, 29 Sep 2000 12:12:38 -0500 > >I have a program that has a procedure that repeats itself many times with >only one difference - the tablename in the FROM clause. I know that SQR >provides dynamic activity for the WHERE clause, but I couldn't figure out >if the same is possible for the FROM clause. Here is a chunk of code. > >!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! >begin-procedure Delete ! Main report processing >if #print=1 >begin-select >COUNT(IA_ACCOUNT_ID) &count >FROM $tablename ! Is this possible??? >WHERE BUSINESS_UNIT = $SQR_BU >AND IA_ACCOUNT_ID = $SQR_POLICY >end-select >show 'Deleted ' &count ' rows from ' $tablename >end-if > >begin-sql >DELETE FROM $tablename ! Is this possible??? >WHERE BUSINESS_UNIT = $SQR_BU >AND IA_ACCOUNT_ID = $SQR_POLICY >end-sql > >end-procedure !End Delete >!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! > >earlier in the program I set the $tablename to the correct table name, but >if this procedure doesnt work, I have to write this procedure N number of >times with a different tablename each time. I already tried it, and it >seems to crash on compile, not during run-time. Please Let me know if >there is any way to approach this. Thank you. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. From owner-sqr-users@list.iex.net Wed Oct 4 10:14:52 2000 Date: Wed, 4 Oct 2000 10:04:40 -0500 From: "Cadenas, Maria (MT)" Subject: date format If my date is formatted as: (YYYYMMDDHHMMSS) do Format-DateTime($Term_Dt, $Term_Date, {DEFCMP}, '', '') how can I change to : DD-MMM-YYYY From owner-sqr-users@list.iex.net Wed Oct 4 11:13:09 2000 Date: Wed, 4 Oct 2000 10:05:56 -0600 From: Troy Steele Subject: Re: date format sorry for this email, but I do not have the original email documenting how to join this group and some co-workers want in. Anyone know how to join up? "Cadenas, Maria (MT)" on 10/04/2000 09:04:40 AM Please respond to sqr-users@list.iex.net To: SQR-USERS@list.iex.net cc: (bcc: Troy Steele/IPL) Subject: date format If my date is formatted as: (YYYYMMDDHHMMSS) do Format-DateTime($Term_Dt, $Term_Date, {DEFCMP}, '', '') how can I change to : DD-MMM-YYYY From owner-sqr-users@list.iex.net Wed Oct 4 11:15:03 2000 Date: Wed, 4 Oct 2000 12:08:32 -0400 From: John Milardovic Subject: Re: date format let $date = edit($date,'DD-MMM-YYYY'). But note that MMM is not a valid format ... I assume you mean MON. HTH John Milardovic > -----Original Message----- > From: Cadenas, Maria (MT) [SMTP:MCadenas@DOW.COM] > Sent: Wednesday, October 04, 2000 11:05 AM > To: SQR-USERS@list.iex.net > Subject: date format > > If my date is formatted as: (YYYYMMDDHHMMSS) > > do Format-DateTime($Term_Dt, $Term_Date, > {DEFCMP}, '', '') > > > how can I change to : DD-MMM-YYYY From owner-sqr-users@list.iex.net Wed Oct 4 12:20:14 2000 Date: Wed, 4 Oct 2000 10:12:30 -0700 From: George Mansoor Subject: Connect to Oracle & ODBC datasource in one SQR Is this possible w/ SQR 4.3.4? We have setup a DB connect string as specified in the documentation but we get an "invalid connect string" error. Any ideas? From owner-sqr-users@list.iex.net Wed Oct 4 13:03:05 2000 Date: Wed, 4 Oct 2000 12:55:59 -0500 From: Joe Johnson Subject: Re: Connect to Oracle & ODBC datasource in one SQR George, I tried doing just that - I needed to connect to a SQL Server table via ODBC and write to an Oracle table. What I have pieced together is this (based on input from various gurus and PS Customer Support): The SQRW application is set to one database type: Oracle, ODBC, whatever. If you try to access a non-Oracle db with the Oracle-based SQRW, the app freaks out trying to apply Oracle parameters to a non-Oracle db. I was told that I need to one of the following: 1) create a flat file (using Excel or any method to get a csv or similar file) from the SQL Server table, and then use an SQR to take that data into Oracle tables or 2) install a separate SQRW application that is ODBC-based, use 1 SQR to extract the data, and then use the Oracle-based SQRW to run an SQR that puts the data into Oracle. or 3) create the flat file and use Data Mover to populate the PS records. I opted for door number 1. If I am wrong about this interpretation maybe someone in this group can clarify the issues for me and you. HTH, Joe Johnson PeopleSoft Systems Analyst joejo@snellingcorp.com 972-776-1332 ----- Original Message ----- From: "George Mansoor" To: Sent: Wednesday, October 04, 2000 12:12 PM Subject: Connect to Oracle & ODBC datasource in one SQR > Is this possible w/ SQR 4.3.4? We have setup a DB connect string as specified in the documentation but we get an "invalid connect string" error. Any ideas? > From owner-sqr-users@list.iex.net Wed Oct 4 13:47:34 2000 Date: Wed, 4 Oct 2000 15:30:29 -0300 From: Juliano Moschen Subject: SQR Referring the functions 'DECLARE-PRINTER' and 'ALTER-PRINTER'. Exists the possibility to change the clauses 'BEFOR-BOLD' and 'AFTER-BOLD' dynamically inside the section 'BEGIN-PROGRAM' of a program SQR ? If exists, what is the way ? JULIANO MOSCHEN From owner-sqr-users@list.iex.net Wed Oct 4 14:06:53 2000 Date: Wed, 4 Oct 2000 14:59:29 -0400 From: "Cadenas, Maria (MT)" Subject: date I formatted a date to do the following: do Format-DateTime($Term_Dt, $Term_Date,{DEFCMP}, '', 'native') however if the $Term_Dt is blank '' I $Term_Date field gets the following value: -Bug- why??? From owner-sqr-users@list.iex.net Thu Oct 5 01:47:41 2000 Date: Thu, 5 Oct 2000 08:40:04 +0200 From: Thorsten Lau Subject: Re: date "Cadenas, Maria (MT)" wrote: > > I formatted a date to do the following: > > do Format-DateTime($Term_Dt, $Term_Date,{DEFCMP}, '', > 'native') > > however if the $Term_Dt is blank '' I $Term_Date field gets the > following value: -Bug- > > why??? Hello Maria, what types are $Term_Dt, and $Term_Date, respectively what are the types of the variables you use to call the procedure ? Regrads, Thorsten -- Thorsten Lau | mailto:lau@eurowings.de Eurowings AG | IT Datawarehouse / Entwicklung Telefon | +49 231 9245 7624 From owner-sqr-users@list.iex.net Wed Oct 4 14:26:57 2000 Date: Wed, 4 Oct 2000 13:07:21 -0600 From: "Bowman, Rick" Subject: SQR Version Does anyone know what version of sqr is compatible with Oracle 8.1.6? Rick Bowman > ProLogis Trust - El Paso > PeopleSoft Senior Financials Analyst Ph. 915.877.6302 Pager: 1.800.217.6983 From owner-sqr-users@list.iex.net Wed Oct 4 14:34:50 2000 Date: Wed, 4 Oct 2000 15:23:33 -0400 From: Mario Mendoza Subject: Re: SQR Version We are in the process of phasing in Oracle 8.1.6 with SQR V6.0.0 > -----Original Message----- > From: Bowman, Rick [SMTP:RBOWMAN@PROLOGIS.COM] > Sent: October 04, 2000 3:07 PM > To: SQR-USERS@list.iex.net > Subject: SQR Version > > Does anyone know what version of sqr is compatible with Oracle 8.1.6? > > Rick Bowman > > ProLogis Trust - El Paso > > PeopleSoft Senior Financials Analyst > Ph. 915.877.6302 > Pager: 1.800.217.6983 From owner-sqr-users@list.iex.net Wed Oct 4 14:33:46 2000 Date: Wed, 4 Oct 2000 15:26:56 -0400 From: "Smith, James O." Subject: Re: SQR Version I am successfully using SQR 4.3.4 with Oracle 8.1.6 Jim -----Original Message----- From: Bowman, Rick [mailto:RBOWMAN@PROLOGIS.COM] Sent: Wednesday, October 04, 2000 3:07 PM To: SQR-USERS@list.iex.net Subject: SQR Version Does anyone know what version of sqr is compatible with Oracle 8.1.6? Rick Bowman > ProLogis Trust - El Paso > PeopleSoft Senior Financials Analyst Ph. 915.877.6302 Pager: 1.800.217.6983 From owner-sqr-users@list.iex.net Wed Oct 4 14:46:49 2000 Date: Wed, 4 Oct 2000 15:40:39 -0400 From: Allan Geetter Subject: Re: SQR Version VMS with SQR 4.3.4 and Oracle 8.1.6 only at this point in time. Allan "Smith, James O." wrote: > I am successfully using SQR 4.3.4 with Oracle 8.1.6 > > Jim > -----Original Message----- > From: Bowman, Rick [mailto:RBOWMAN@PROLOGIS.COM] > Sent: Wednesday, October 04, 2000 3:07 PM > To: SQR-USERS@list.iex.net > Subject: SQR Version > > Does anyone know what version of sqr is compatible with Oracle 8.1.6? > > Rick Bowman > > ProLogis Trust - El Paso > > PeopleSoft Senior Financials Analyst > Ph. 915.877.6302 > Pager: 1.800.217.6983 -- Allan Geetter Phone: (860) 768-4889 Data Security Administrator FAX: (860) 768-4907 University of Hartford E-Mail:geetter@mail.hartford.edu Information Technology Services - CC125 200 Bloomfield Avenue West Hartford, CT 06117 From owner-sqr-users@list.iex.net Fri Oct 6 17:49:57 2000 Date: Fri, 6 Oct 2000 16:26:32 -0600 From: "Bowman, Rick" Subject: Re: SQR Version I talked with Brio Tech Support and they said that the certified version for Oracle 8.1.6 was ver 6.0, but version 4.3.4 would still work. Thanks for the help. Rick Bowman > ProLogis Trust - El Paso > PeopleSoft Senior Financials Analyst Ph. 915.877.6302 Pager: 1.800.217.6983 > -----Original Message----- > From: Bowman, Rick [SMTP:RBOWMAN@PROLOGIS.COM] > Sent: Wednesday, October 04, 2000 1:07 PM > To: SQR-USERS@list.iex.net > Subject: SQR Version > > Does anyone know what version of sqr is compatible with Oracle 8.1.6? > > Rick Bowman > > ProLogis Trust - El Paso > > PeopleSoft Senior Financials Analyst > Ph. 915.877.6302 > Pager: 1.800.217.6983 From owner-sqr-users@list.iex.net Wed Oct 4 15:15:14 2000 Date: Wed, 4 Oct 2000 14:56:39 -0500 From: "Manning, Shinta" Subject: edit mask for monetary presentation Can anyone please tell me how to print "CR" or "DB" as a postfix to a monetary value? For example: If someone overpays me $450.00, then the presentation on the report that I would like to see is $450.00CR. Thanks From owner-sqr-users@list.iex.net Wed Oct 4 15:31:56 2000 Date: Thu, 5 Oct 2000 09:11:33 +1300 From: Peter Morris Subject: SQRTools.com (Tony DeLia program) help Does anyone have a copy of the program by Tony DeLia that produces a flow of an SQR program with file inpouts and outputs (td75proj?). I got a copy, DAMAGED it beyond repair and not his web site (www.sqrtools.com) has gone (404 - URL Not Found). OR Does anyone know if there's a history in Netscape that I can go back to because it will have saved the page in some directory (like IE4) Peter ________________________________________________________ Peter Morris Analyst Programmer/Applications Analyst Information Technology Services Office: B738 P.O. Box 94 Lincoln University Canterbury New Zealand Phone: +64 (03) 325 2811 x8065 Mail : MorrisP@Lincoln.ac.nz Web : http://www.lincoln.ac.nz/its/profiles/morrisp.htm ________________________________________________________ From owner-sqr-users@list.iex.net Wed Oct 4 15:36:42 2000 Date: Wed, 4 Oct 2000 16:25:07 -0400 From: Mario Mendoza Subject: Re: SQRTools.com (Tony DeLia program) help Search for SQR on your browser and it will come up, I saw it within the last 2 weeks. > -----Original Message----- > From: Peter Morris [SMTP:morrisp@KEA.LINCOLN.AC.NZ] > Sent: October 04, 2000 4:12 PM > To: SQR-USERS@list.iex.net > Subject: SQRTools.com (Tony DeLia program) help > > Does anyone have a copy of the program by Tony DeLia that produces a flow > of an > SQR program with file inpouts and outputs (td75proj?). I got a copy, > DAMAGED it > beyond repair and not his web site (www.sqrtools.com) has gone (404 - URL > Not > Found). > > OR > > Does anyone know if there's a history in Netscape that I can go back to > because > it will have saved the page in some directory (like IE4) > > Peter > > ________________________________________________________ > Peter Morris > Analyst Programmer/Applications Analyst > Information Technology Services > Office: B738 > P.O. Box 94 > Lincoln University > Canterbury > New Zealand > > Phone: +64 (03) 325 2811 x8065 > Mail : MorrisP@Lincoln.ac.nz > Web : http://www.lincoln.ac.nz/its/profiles/morrisp.htm > ________________________________________________________ From owner-sqr-users@list.iex.net Wed Oct 4 18:03:22 2000 Date: Wed, 4 Oct 2000 16:58:20 -0400 From: "David A. Beck" Subject: Bar Codes, Graphics, Legal Paper - straight to LPT1 Hi All, I'm using PeopleSoft and SQR to create a report for an HP Laserjet printer that has the following characteristics: 1. Prints directly to LPT1 2. Prints on Legal Paper 3. Prints Graphics I'm having the following problems with the various iterations that I've tried: 1. SPF file is produced on printer instead of LIS File 2. SQR viewer app reformats page to 8 1/2 x 11 ( I don't want to use the Viewer anyway) 3. Using -printer:wp produces an 8 1/2 x 11 print 4. Graphics don't show I'm not sure of the following: 1. What is the best way to print a legal size output? I'm currently sending the printer codes manually to the printer using print-direct 2. Why do the graphics not show for the LIS file when sent to the printer? 3. Why does SPF reformat the layout to 8 1/2 x 11? Thanks in advance for your help. Dave ______________________________________________________________________ The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. Cap Gemini Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. From owner-sqr-users@list.iex.net Thu Oct 5 09:44:20 2000 Date: Thu, 5 Oct 2000 14:35:30 GMT From: Elvis Pressly Subject: Re: Bar Codes, Graphics, Legal Paper - straight to LPT1 David, I'm sorry if I did'nt quite satisfy your query from my previous reply. However, I'm puzzled by your problem because the things you mentioned in your printing works perfectly well with us. I need some more info from you like: 1. Are you using encode statement to print in legal size with your escape sequences? 2. When you say graphic, does it meant like images? or boxes? 3. Is your LPT1 really a network printer? 4. Are you printing directly to the printer or you use -keep parameters? All of the above could be the reason why you are not getting what you want. Elvis >From: "David A. Beck" >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Bar Codes, Graphics, Legal Paper - straight to LPT1 >Date: Wed, 4 Oct 2000 16:58:20 -0400 > >Hi All, > >I'm using PeopleSoft and SQR to create a report for an HP Laserjet printer >that has the following characteristics: > >1. Prints directly to LPT1 >2. Prints on Legal Paper >3. Prints Graphics > >I'm having the following problems with the various iterations that I've >tried: > >1. SPF file is produced on printer instead of LIS File >2. SQR viewer app reformats page to 8 1/2 x 11 ( I don't want to use the >Viewer anyway) >3. Using -printer:wp produces an 8 1/2 x 11 print >4. Graphics don't show > >I'm not sure of the following: > >1. What is the best way to print a legal size output? I'm currently >sending the printer codes manually to the printer using print-direct > >2. Why do the graphics not show for the LIS file when sent to the printer? >3. Why does SPF reformat the layout to 8 1/2 x 11? > > >Thanks in advance for your help. > >Dave > > > >______________________________________________________________________ >The information contained in this communication is intended solely for the >use of the individual or entity to whom it is addressed and others >authorized to receive it. It may contain confidential or legally privileged >information. If you are not the intended recipient you are hereby notified >that any disclosure, copying, distribution or taking any action in reliance >on the contents of this information is strictly prohibited and may be >unlawful. If you have received this communication in error, please notify >us immediately by responding to this email and then delete it from your >system. Cap Gemini Ernst & Young is neither liable for the proper and >complete transmission of the information contained in this communication >nor for any delay in its receipt. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. From owner-sqr-users@list.iex.net Wed Oct 4 17:12:33 2000 Date: Thu, 5 Oct 2000 11:03:18 +1300 From: Peter Morris Subject: SQRTools.com (Tony DeLia program) help - Take two Sorry. Wrong program. Does anyone have a copy of the program by Tony DeLia that produces a list of details and changes within a project (td75proj?). I got a copy, DAMAGED it beyond repair and now his web site (www.sqrtools.com) has gone (404 - URL Not Found). OR Does anyone know if there's a history in Netscape that I can go back to because it will have saved the page in some directory (like IE4) Peter ________________________________________________________ Peter Morris Analyst Programmer/Applications Analyst Information Technology Services Office: B738 P.O. Box 94 Lincoln University Canterbury New Zealand Phone: +64 (03) 325 2811 x8065 Mail : MorrisP@Lincoln.ac.nz Web : http://www.lincoln.ac.nz/its/profiles/morrisp.htm ________________________________________________________ From owner-sqr-users@list.iex.net Thu Oct 5 01:17:58 2000 Date: Thu, 5 Oct 2000 02:07:21 -0400 From: "John W. Gagne" Subject: John W Gagne/OR1/AEPIN is out of the office. I will be out of the office from 10/05/2000 until 10/10/2000. If you need to speak to someone before then please contact Alex Hellstrom at X3178 or Dave Rettig at X3514. If it is not an emergency and you can hang tight till next week I will respond to your message when I return. Thanks, John From owner-sqr-users@list.iex.net Thu Oct 5 09:50:07 2000 Date: Thu, 5 Oct 2000 09:23:55 -0500 From: "Cadenas, Maria (MT)" Subject: Postscript I need help on this one. I ran my program against two different servers and receive the following error: (SQR 5404) Cannot open the Postscript startup file: dummy\postscri.str (2): No such file or directory However, postscri.str IS in my C: my print command looks the following: declare-printer ABC for-reports = (ENROLLMENT, PREMIUM) type=PS point-size=7 end-declare am I missing a command in the SQR itself? Has anyone faced this problem before.. Maria Cadenas Lead People Payroll Team Southfield Alliance Center phone: 248.368.1037 email: MCadenas@dow.com From owner-sqr-users@list.iex.net Thu Oct 5 09:49:34 2000 Date: Thu, 5 Oct 2000 10:31:22 -0400 From: Ray Brunner Subject: Duplex Printing Problem I have been able to successfully print a report on both sides of a sheet of paper but I have 1 problem. The heading and the data print the on the front side of sheet 1 but only the data prints on the back side of sheet 1. The heading prints by itself on the front side of the sheet 2. Any suggestions would be appreciated. Thanks, Ray Brunner Skytop Office Building Syracuse University 315/443-9262 From owner-sqr-users@list.iex.net Thu Oct 5 14:32:12 2000 Date: Thu, 5 Oct 2000 19:25:06 GMT From: Elvis Pressly Subject: Re: Duplex Printing Problem Ray, Did you turn off duplexing after it was printing at the back of the first sheet? I believe you have to turn it on when it is supposed to print in odd pages and off in even pages. >From: Ray Brunner >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Duplex Printing Problem >Date: Thu, 5 Oct 2000 10:31:22 -0400 > >I have been able to successfully print a report on both sides of a sheet of >paper but I have 1 problem. The heading and the data print the on the front >side of sheet 1 but only the data prints on the back side of sheet 1. The >heading prints by itself on the front side of the sheet 2. > >Any suggestions would be appreciated. > >Thanks, > >Ray Brunner >Skytop Office Building >Syracuse University >315/443-9262 _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. From owner-sqr-users@list.iex.net Thu Oct 5 10:02:40 2000 Date: Thu, 5 Oct 2000 08:06:00 -0700 From: Bruce Butterfield We started getting an SQR error ( out of expressionspace ) I created the SQRMAXes.dat file changed the value and reran the program using the -m option successfully. I would like to put the file in a place so it would change the default values of SQR without having to use the -m option. Does anyone know what the file name should be and where it should reside ? thanks bruce From owner-sqr-users@list.iex.net Thu Oct 5 10:29:32 2000 Date: Thu, 5 Oct 2000 11:29:12 -0400 From: Tony DeLia Subject: www.sqrtools.com Hi everyone, I noticed a message about my site being down... my ISP screwed up the domain link... they "assured" me it will be up within 24-36 hours... starting from "when" I don't know! You can access the site at its' static address: http://www.erols.com/sqrtools Thanks and Cheers, Tony DeLia -- Tony DeLia AnswerThink Consulting Group PeopleSoft Solutions Practice - Delphi Partners tdelia@erols.com http://www.sqrtools.com From owner-sqr-users@list.iex.net Thu Oct 5 11:58:33 2000 Date: Thu, 5 Oct 2000 09:49:13 -0700 From: Bryan deSilva Subject: Re: www.sqrtools.com Tony: I hope you don't mind that I'm posting this in PeopleSoft-Fans@egroups.com also. Several questions there Bryan deSilva Chief Evangelist of Really Neat Stuff Improvisations.net - "innovation by design" 480/367-8761 voice 970/396-7529 cell To join one of our helpful mailing lists click on the appropriate link below. Click here to join the PeopleSoft-Fans mailing list. Click here to join the Arev-fans mailing list -----Original Message----- From: owner-sqr-users@LIST.IEX.NET [mailto:owner-sqr-users@LIST.IEX.NET]On Behalf Of Tony DeLia Sent: Thursday, October 05, 2000 8:29 AM To: SQR-USERS@LIST.IEX.NET Subject: www.sqrtools.com Hi everyone, I noticed a message about my site being down... my ISP screwed up the domain link... they "assured" me it will be up within 24-36 hours... starting from "when" I don't know! You can access the site at its' static address: http://www.erols.com/sqrtools Thanks and Cheers, Tony DeLia -- Tony DeLia AnswerThink Consulting Group PeopleSoft Solutions Practice - Delphi Partners tdelia@erols.com http://www.sqrtools.com From owner-sqr-users@list.iex.net Thu Oct 5 13:37:32 2000 Date: Thu, 5 Oct 2000 14:29:19 -0400 From: Ray Brunner Subject: Printing 2 and 4 up I am trying to print some of my larger reports 2 and 4 up. Does anyone know what the pcl commands are to do this. Thanks, Ray Brunner Skytop Office Building Syracuse University 315/443-9262 From owner-sqr-users@list.iex.net Fri Oct 6 12:00:32 2000 Date: Fri, 6 Oct 2000 16:43:42 GMT From: Elvis Pressly Subject: Re: Printing 2 and 4 up Ray, Does 2 and 4 up means printing on a label type thing? If so there is a good example in the SQR server/user guide book regarding printing labels. Just a thought. Elvis >From: Ray Brunner >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Printing 2 and 4 up >Date: Thu, 5 Oct 2000 14:29:19 -0400 > >I am trying to print some of my larger reports 2 and 4 up. Does anyone know >what the pcl commands are to do this. > >Thanks, > >Ray Brunner >Skytop Office Building >Syracuse University >315/443-9262 _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. From owner-sqr-users@list.iex.net Thu Oct 5 14:14:25 2000 Date: Thu, 5 Oct 2000 13:58:50 -0500 From: "Elenich, Dennis" Subject: horizontal 100%-bar chart This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_01C02EFE.4CAFC072 Content-Type: text/plain All, I need to print a 100%-bar chart horizontally. To my knowledge, this can only be printed vertically. The closest thing I know of is a histogram, but it doesn't give the 100% effect I need. Do any of you know if this graph is possible? And if so, what is it and how?? Attached is an image of the end result I'm looking for. Thanks, -Dennis ------_=_NextPart_000_01C02EFE.4CAFC072 Content-Type: application/octet-stream; name="Horizontal 100%-bar chart.doc" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="Horizontal 100%-bar chart.doc" 0M8R4KGxGuEAAAAAAAAAAAAAAAAAAAAAPgADAP7/CQAGAAAAAAAAAAAAAAABAAAAEQAAAAAAAAAA EAAAEwAAAAEAAAD+////AAAAABAAAAD///////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////s pcEANyAJBAAA+BK/AAAAAAAAEAAAAAAABAAAGAQAAA4AYmpialUWVRYAAAAAAAAAAAAAAAAAAAAA AAAJBBYAIgwAADd8AAA3fAAAGAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD//w8AAAAA AAAAAAD//w8AAAAAAAAAAAD//w8AAAAAAAAAAAAAAAAAAAAAAGwAAAAAAKgAAAAAAAAAqAAAAKgA AAAAAAAAqAAAAAAAAACoAAAAAAAAAKgAAAAAAAAAqAAAABQAAAAAAAAAAAAAALwAAAAAAAAA1gAA AAAAAADWAAAAAAAAANYAAAAAAAAA1gAAAAwAAADiAAAADAAAALwAAAAAAAAAGwIAALYAAAD6AAAA FgAAABABAAAAAAAAEAEAAAAAAAAQAQAAAAAAABABAAAAAAAAEAEAAAAAAAAQAQAAAAAAABABAAAA AAAAmgEAAAIAAACcAQAAAAAAAJwBAAAAAAAAnAEAAAAAAACcAQAAAAAAAJwBAAAAAAAAnAEAACQA AADRAgAAIAIAAPEEAABkAAAAwAEAABUAAAAAAAAAAAAAAAAAAAAAAAAAqAAAAAAAAAAQAQAAAAAA AAAAAAAAAAAAAAAAAAAAAAAQAQAAAAAAABABAAAAAAAAEAEAAAAAAAAQAQAAAAAAAMABAAAAAAAA JAEAAAAAAACoAAAAAAAAAKgAAAAAAAAAEAEAAAAAAAAAAAAAAAAAABABAAAAAAAA1QEAABYAAAAk AQAAAAAAACQBAAAAAAAAJAEAAAAAAAAQAQAACgAAAKgAAAAAAAAAEAEAAAAAAACoAAAAAAAAABAB AAAAAAAAmgEAAAAAAAAAAAAAAAAAACQBAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAEAEAAAAAAACaAQAAAAAAACQBAAB2AAAAJAEAAAAAAAAAAAAA AAAAAJoBAAAAAAAAqAAAAAAAAACoAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAmgEAAAAAAAAQAQAAAAAAAO4AAAAMAAAAMCO1tfsu wAG8AAAAGgAAANYAAAAAAAAAGgEAAAoAAACaAQAAAAAAAAAAAAAAAAAAmgEAAAAAAADrAQAAMAAA ABsCAAAAAAAAmgEAAAAAAABVBQAAAAAAACQBAAAAAAAAVQUAAAAAAACaAQAAAAAAACQBAAAAAAAA vAAAAAAAAAC8AAAAAAAAAKgAAAAAAAAAqAAAAAAAAACoAAAAAAAAAKgAAAAAAAAAAgDZAAAAE0VN QkVEIEV4Y2VsLkNoYXJ0LjgUARUNAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAA AQQAABQEAAAVBAAAFwQAABgEAADw5dPwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAACMDahoRhz0KCAFDShQAT0oCAFFKAgBVCAFWCAFeSgIAYUoUABRD ShQAT0oCAFFKAgBeSgIAYUoUAAAdA2oAAAAAQ0oUAE9KAgBRSgIAVQgBXkoCAGFKFAAABQAEAAAY BAAA/QAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAABAAQAABgE AAD+AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAIBAQEgADGQaAEf sNAvILDgPSGwCAcisAgHI5CgBSSQoAUlsAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAeAgAAEQAZAAA AAAAAAACAAAAAAAAAAEAAAAAAHMjDhDoA+gDAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAPAATwMAAAALIECvAIAAAAAQQAAAAKAAAjAAvwDAAAAARBAQAAAP8BAAAIAAAAEPAEAAAAAAAA gDIAB/D0BwAAAwSDfHrcERUReEzpG4JnzoBV/wDQBwAAAQAAAEQAAAAAAH8BYCEb8MgHAACDfHrc ERUReEzpG4JnzoBVkyEAAAAAAAAAAAAAXQIAABIBAADY7VcAUNMnAJYHAAAA/njavVp9aBRXEJ+3 t7fJbS41aJWiJQRpqv0CNba1/iMRUxQqiLGtra1wCZd4NF/koiK2GK39UGIRC0WLYCMtRan/SNVa U+IfpUG00AYOCvp/oUVqEcvRBq4z83bfvv24y90l8cLLzsfbmTfzfjN3b+8EJABiNxoA6mEH0CuO I2G4lDAKhQJTpqh3ZIYwHCppzBdvGzGkGsHE/8tEoeDnaFYdW5Nyv03px39n1IwaHItM8kVcLY5/ jTgIkC+6/zkhZ03hDLrXlQrHimtPqMiC8dDdS8x54g20HHd8gHpJa0akj1hE7OTZXZffr1yLPyLX +kzt1YvtvHp3lcPDw8q6ydd7ATsJg+aU3ulHcDwRi8MRmIRP4SaOtUi3Mu96un79upZz6cl0PJDO W7Nu7YGYhIK4yVaJd3XEk7wg1rI34snTQvMqbDOGYbERvT/S46PGJFrzx2QI4cS0wCB/klrrUHTH BaW9orRXlHZSae8o7R2l/UdpQbhaSZF2iXC1zUrbrLTrlHaT0m5S2k6l7VXaXqX9WGlPKO0Jpf1G aS8r7WWl/VVpbyvtbaV9oLQFpS2ISnBqhiqZcBCFU38dxxVOg52oWOV6qPFw6eLUxQn5IKQHEepH VbXYLCcvcV9H0uvX63BuXvRVQ0QFu1WXzY6HOh3JpAeXKpavERiDURxfwVU4joN41/KpU15/swI7 Qjpvbz1rE2htgi2O8JhQ1vQo3NxbRaK0fHvDUT65OVDhGCXKnCiRctfA0YgxOCeuclSjekQtXcpK TaBDkS4cEUXzlZhgi6Ocq4lADDXT7JSlvI+Pn9IilF5JJr0S5Xolb3kcUxgDxyHGtHedW6EYLPUu cCsiBlp/nofMDPHBGLx3i67QGkkmrRLlWp0SPyqrtE7iozNRE95NDbNmIAY/dj1knYG4OAMJcRpx epr5Ujg1p8HpebR2ni2SJeLLQ6YZypiOTKskMslbHscUxkBxEF8KmVZJZNL68zxkZogvtqubF7eE 1kgyaZUob1e/VlZpncRPt6vBzEVhyZwGS+V6tVRswS5ebhWWv18jcAgaxSFYKg4g5g4wX/1+jcAx tHaMLZIl4svrJOFuqHcSs2QnIW95HFMYA8VBfKlOYpbsJLT+PA+ZGeLL6STT7f5RZZXWSXxpzFmR nSRY+8U6SRqu4RiHDtzVDuajOkmwLxXrJANobYAtjvAYqBCZ1XQS8nZDpOFn0cFxXNNjqBiZtP4b YoAtXuPsDDwEZJK3PI4pjIHiIL56ZNL68zxkZoifDWT2Kqu0TuLnEpkb4SKOy9CGyGxjfibIbEdr 7WxxhEf7Q0AmeVsvNsLLoo3juKjHUDEyaf3rRTtbvMjZaX8IyCRveRxTGAPFQXz1yKT153nIzBA/ G8jcoqzSOokP7q5+ItE/0VRzXnZPg968BUbOofSTc86h9PNyzqH0U3LOofSzcc6h9BNxzqH0c3DO ofTTb86h9DNvzqH0k27OofTzbQ6px5H6z3hQkJk57oKpqXUwk+pBYrlpr5t89+7e2zh+6f5rL/EA dqAm6BYbxyr7NzgIxK5otlCSdGRn+QnYyhXNeIcun2D5qpD8T5a3hOQNguSrQ/LVLH8+JN/O8hdC 8vdY/mJIPsryNSH5Tyx/ScnrHfnv/FRg5QqKVmpkPu87+Rwzgvn8oNZ+Ss8n8V4+a4pcDcduA1eM a1cYxtL2fdmhdC+AfIp3VJAtS6Pl/bWRp/Kaok8rvFO5EMPiD/g7dJYmoCzjLNyF+7AQqbbegZ7+ fel004ZMdmgw07F7KNPfh7WXBPJeC9SxiErgoC4VZylJ3Ks/4pmu3H2e4K/eYAyyElq1ij6iKv9D R3ZJyS4p2UklO6lk+5Vsv5LtVLKdStaqZK0ocytpIWfzB3iNnkrD5tTgO+mhTF83ZkZmy8KaMBhl 83jmF5BhK+2pnnQWY7YcbSNr34dneN7G3b2pvqat6Wz/7sHOdPY4zavleTG+R/6ZznUB39sFr3LP xLvSqcHOXcF5i3jWJniFa35bunNXX39Pf/c+C7w/Q91RGtcz3eUv4Wnow3VH7a1Xi4djh2NOLTZ4 tfhsjd2k1yLxXs0koI7jPIvxUjY2ZPZksghp/3tgYs5wO1v23OfsMhv3inam1bYt9GwQr2cj+lp6 fYky1rcMLMOG1yN3cAfvwDx4E9YgtWWwvyudpT1I9TStT+9K7cn0DzZtTVGZZH1tp6kLFe6GZeu4 M8exrhLcfWz8S3DfSeLVVlLLkcS1OUnuWHHW2WxFXiki9w7Z03TLs5uh6G9KZm5PIuJu8L0fXES8 ZduP6Ygg3kOEHfl9UF2F3zl97zx9jnqKXCxGW/nyxxr1rdB30G4chCWG/um4XD9WFX6iP5UnQ5/K o841dZHnmuK5+wSajY+g0fB/VyArZ77zLrDcoLlbU33d6aaVWiePQXW5MFVExfHlz7kNM8l9Jf6i c1/nZDcZeR5LFnkaHp3xUcz45yUz/pkv46tmIeNJX2XNfcYr8Vf6HF0XeXr09sN/eozO+LeY8Qsl M37Ol/GWWch4XRk9NDrjM+tf5ff+ubIv1M75z9Cm7zcN+i8fSv2modLfP+DrfxrCQ1gAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAACAAAAAwAAAAQAAAAF AAAABgAAAAcAAAD+////CQAAAAoAAAALAAAADAAAAA0AAAAOAAAADwAAAP7////9////EgAAABUA AAD+////LQAAAC4AAAAXAAAAGAAAABkAAAAaAAAAGwAAABwAAAAdAAAAHgAAAB8AAAAgAAAAIQAA ACIAAAAjAAAAJAAAACUAAAAmAAAAJwAAACgAAAApAAAAKgAAACsAAAAsAAAA/v///y8AAAA0AAAA MAAAADEAAAAyAAAAMwAAAP7////+//////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////UgBvAG8AdAAgAEUAbgB0AHIA eQAAABQAYABAALAAsABgALAAsAAgACAAQABAAFAAYACgAGAAoABQAEAAoACwABYABQH///////// /w4AAAAGCQIAAAAAAMAAAAAAAABGAAAAAFAAgABQAFAA0Km2tfsuwAEUAAAAwAwAALAAsABEAGEA dABhAAAAcABwAHAAoABwAGAAYABgAGAAQABAAEAAQACAAHAAgACAAIAAgACAAIAAgABwAHAAcABw AGAACgACAf///////////////6AAUABgAGAAYABgACAAIAAgACAAYABgAGAAYABgAGAAYACAAAgA AAAAEAAAYABgAFcAbwByAGQARABvAGMAdQBtAGUAbgB0AAAAYABgAGAA+xeFAAAQAAC4ABQAuAAU AP///wAA//8AwMDAAAD//wAaAAIBDQAAAP//////////wMDAAAD//wDAwMAAgICAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAATwBiAGoAZQBjAHQAUABvAG8AbAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAgICAAP///wD///8A////ABYAAQEQAAAA/////wQAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAJCcs7X7LsAB0Km2tfsuwAEAAAAAAAAAAAAAAABfADEAMAAzADIAMgA2ADEAOQAx ADQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGAABAf////////// CAAAACEIAgAAAAAAwAAAAAAAAEYAAAAAkJyztfsuwAEwI7W1+y7AAQAAAAAAAAAAAAAAAAEATwBs AGUAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAKAAIB////////////////AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA ABQAAAAAAAAAAQBDAG8AbQBwAE8AYgBqAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAABIAAgAFAAAABwAAAP////8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAABAAAAYgAAAAAAAAADAE8AYgBqAEkAbgBmAG8AAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEgACAf///////////////wAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAMAAAAEAAAAAAAAAP7///8CAAAA/v////7////+//// /v///wcAAAAIAAAACQAAAP7///8LAAAADAAAAA0AAAAOAAAA/v///xAAAAARAAAAEgAAABMAAAAU AAAAFQAAAP7///8XAAAAGAAAABkAAAAaAAAA/v///xwAAAAdAAAAHgAAAB8AAAAgAAAAIQAAACIA AAAjAAAAJAAAACUAAAAmAAAAJwAAACgAAAApAAAAKgAAACsAAAAsAAAALQAAAC4AAAAvAAAAMAAA AP7///8yAAAA/v////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////AQAAAgAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEA/v8DCgAA/////yEI AgAAAAAAwAAAAAAAAEYWAAAATWljcm9zb2Z0IEV4Y2VsIENoYXJ0AAYAAABCaWZmOAAOAAAARXhj ZWwuQ2hhcnQuOAD0ObJxAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAIDAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAEAAACHPgAAUhwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAABAAAIAAAAAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAA/v8AAAQAAgAAAAAAAAAAAAAAAAAAAAAAAQAAAOCFn/L5T2gQ q5EIACsns9kwAAAAsAAAAAcAAAABAAAAQAAAAAQAAABIAAAACAAAAGAAAAASAAAAeAAAAAwAAACQ AAAADQAAAJwAAAATAAAAqAAAAAIAAADkBAAAHgAAAA4AAABXAG8AcgBrAGIAbwBvAGsAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEgACAQYAAAAKAAAA//// /wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABYAAAAyLQAAAAAAAAMATQBhAGkA bABTAHQAcgBlAGEAbQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAY AAIB////////////////AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAAwA AAAAAAAAUgBpAGMAaABFAGQAaQB0AEYAbABhAGcAcwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAABwAAgAJAAAACwAAAP////8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAFAAAADAAAAAAAAAAFAFMAdQBtAG0AYQByAHkASQBuAGYAbwByAG0AYQB0AGkAbwBu AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAKAACAf////8MAAAA/////wAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAYAAADgAAAAAAAAAAkIEAAABgUArxjNB8FAAAAGAQAA4QAC ALAEwQACAAAA4gAAAFwAcAANAABDaHJpc3RpbmEgUnllICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgQgACALAEYQECAAAAwAEAAD0BCAAEAAEAAgADAJwAAgAOAN4ACAAMAAUA HAACDBkAAgAAABIAAgAAABMAAgAAAK8BAgAAALwBAgAAAD0AEgCm/4n+JyTAEjwAAAAAAAEAWAJA AAIAAACNAAIAAAAiAAIAAAAOAAIAAQC3AQIAAADaAAIAAAAxABoAyAAAAP9/kAEAAAAAAAAFAUEA cgBpAGEAbAAxABoAyAAAAP9/kAEAAAAAAAAFAUEAcgBpAGEAbAAxABoAyAAAAP9/kAEAAAAAAAAF AUEAcgBpAGEAbAAxABoAyAAAAP9/kAEAAAAAAAAFAUEAcgBpAGEAbAAxABoA8AAAAP9/kAEAAAAC AAAFAUEAcgBpAGEAbAAxABoAGAEBAP9/vAIAAAACAAAFAUEAcgBpAGEAbAAxABoAXgEAAP9/kAEA AAAAAAAFAUEAcgBpAGEAbAAxABoA8AAAAP9/kAEAAAACAAAFAUEAcgBpAGEAbAAxABoAXgEAAP9/ kAEAAAAAAAAFAUEAcgBpAGEAbAAxABoAHQEAAP9/kAEAAAAAAAAFAUEAcgBpAGEAbAAxABoAwwAB AP9/vAIAAAACAAAFAUEAcgBpAGEAbAAxABoAHQEAAP9/kAEAAAAAAAAFAUEAcgBpAGEAbAAxABoA pQAAAP9/kAEAAAACAAAFAUEAcgBpAGEAbAAxABoApQAAAP9/kAEAAAACAAAFAUEAcgBpAGEAbAAx ABoA8AABAP9/vAIAAAACAAAFAUEAcgBpAGEAbAAeBBwABQAXAAAiJCIjLCMjMF8pO1woIiQiIywj IzBcKR4EIQAGABwAACIkIiMsIyMwXyk7W1JlZF1cKCIkIiMsIyMwXCkeBCIABwAdAAAiJCIjLCMj MC4wMF8pO1woIiQiIywjIzAuMDBcKR4EJwAIACIAACIkIiMsIyMwLjAwXyk7W1JlZF1cKCIkIiMs IyMwLjAwXCkeBDcAKgAyAABfKCIkIiogIywjIzBfKTtfKCIkIiogXCgjLCMjMFwpO18oIiQiKiAi LSJfKTtfKEBfKR4ELgApACkAAF8oKiAjLCMjMF8pO18oKiBcKCMsIyMwXCk7XygqICItIl8pO18o QF8pHgQ/ACwAOgAAXygiJCIqICMsIyMwLjAwXyk7XygiJCIqIFwoIywjIzAuMDBcKTtfKCIkIiog Ii0iPz9fKTtfKEBfKR4ENgArADEAAF8oKiAjLCMjMC4wMF8pO18oKiBcKCMsIyMwLjAwXCk7Xygq ICItIj8/Xyk7XyhAXyngABQAAAAAAPX/IAAAAAAAAAAAAAAAwCDgABQAAQAAAPX/IAAA9AAAAAAA AAAAwCDgABQAAQAAAPX/IAAA9AAAAAAAAAAAwCDgABQAAgAAAPX/IAAA9AAAAAAAAAAAwCDgABQA AgAAAPX/IAAA9AAAAAAAAAAAwCDgABQAAAAAAPX/IAAA9AAAAAAAAAAAwCDgABQAAAAAAPX/IAAA 9AAAAAAAAAAAwCDgABQAAAAAAPX/IAAA9AAAAAAAAAAAwCDgABQAAAAAAPX/IAAA9AAAAAAAAAAA wCDgABQAAAAAAPX/IAAA9AAAAAAAAAAAwCDgABQAAAAAAPX/IAAA9AAAAAAAAAAAwCDgABQAAAAA APX/IAAA9AAAAAAAAAAAwCDgABQAAAAAAPX/IAAA9AAAAAAAAAAAwCDgABQAAAAAAPX/IAAA9AAA AAAAAAAAwCDgABQAAAAAAPX/IAAA9AAAAAAAAAAAwCDgABQAAAAAAAEAIAAAAAAAAAAAAAAAwCDg ABQAAQArAPX/IAAA+AAAAAAAAAAAwCDgABQAAQApAPX/IAAA+AAAAAAAAAAAwCDgABQAAQAsAPX/ IAAA+AAAAAAAAAAAwCDgABQAAQAqAPX/IAAA+AAAAAAAAAAAwCDgABQAAQAJAPX/IAAA+AAAAAAA AAAAwCCTAgQAEIAD/5MCBAARgAb/kwIEABKABP+TAgQAE4AH/5MCBAAAgAD/kwIEABSABf9gAQIA AACFAA4A1gcAAAACBgBDaGFydDGFAA4ArhcAAAAABgBTaGVldDGFAA4ApikAAAAABgBTaGVldDKF AA4AmSoAAAAABgBTaGVldDOMAAQAAQABAK4BBAAEAAEEFwAIAAEAAAABAAEAwQEIAMEBAABgaQEA 6wBaAA8AAPBSAAAAAAAG8BgAAAABCAAAAgAAAAIAAAABAAAAAQAAAAIAAAAzAAvwEgAAAL8ACAAI AIEBCQAACMABQAAACEAAHvEQAAAADQAACAwAAAgXAAAI9wAAEPwAZAAIAAAACAAAAAkAAE1hcmtl dGluZwUAAFNhbGVzDwAASHVtYW4gUmVzb3VyY2VzCAAAUmVzZWFyY2gKAABUZWNobm9sb2d5BwAA UmFuZ2UgMQcAAFJhbmdlIDIHAABSYW5nZSAz/wAKAAgAaAcAAAwAAAAKAAAACQgQAAAGIACvGM0H wUAAAAYBAAAUAAAAFQAAAIMAAgAAAIQAAgAAAE0AogMAAEwAZQB4AG0AYQByAGsAIABPAHAAdABy AGEAIABXADgAMQAwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABBGwm3ADEAgP3ABACAAEA AAAAAAAAAQAHAFgCAQACAFgCAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAABAAAAAQAAAAAAAAAAAAAAAAAAAAAAAADipJe8AAEBAAAAAv8CAgABAAAAAAAATGV4bWFyayBP cHRyYSBXODEwAAAAAAAAAAAAAAAAAAAAAJcBAABMZXhtYXJrIE9wdHJhIFc4MTAAAKgDAAB1AAAA AAAAAAgAyAD/f/9/AAABAAcADAAGAAUAAQAAAAYAAwADAAEAAAAAAAAAAAAAAA0AAwABAAAAAQAD AL8m5woBAAEAEAAKAAsAGgAAAOKkl7wCAAEA/wAIAFgCLAEsASwBAABYAgAAAAAAAQAAAAAAAwAA hwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAABwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACgAAAAoAAAAKAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAOKkl7yhACIAAQBk AAEAAQABAAAAWAJYAgAAAAAAAOA/AAAAAAAA4D8BADMAAgADAGAQCgCCFOYKyAAAAAoAYBAKABgk YhYYAQEACwBgEAoAghTmCsgAAQAMAGAQCgAYJGIW8AABAA0AYBAKABgkYhbwAAAADgBgEAoA3SJ4 D/AAAAAPABIAAgAAAAEQAgAAAAIQEAAAAAAAAAAAAOi/xQHQf80AMxAAAKAABAABAAEAZBAIAAAA AQAAAAEAMhAEAAAAAgAzEAAABxAMAAAAAAAFAP//CABNAAoQEAD///8AAAAAAAEAAQBOAE0ANBAA AAMQDAADAAEABQAFAAEAAAAzEAAAURAPAAACAAAAAAcAOgAAAQAAAA0QEgAAAAcBUgBhAG4AZwBl ACAAMQBREBMAAQIAAAAACwA7AAABAAEAAQAFAFEQEwACAgAAAAALADsAAAAAAAABAAUAURAIAAMB AAAAAAAABhAIAP//AAAAAAAAMxAAAF8QAgAAADQQAABFEAIAAABDEAQA//8CADMQAAAlECAAAgIB AAAAAADe////tP///wAAAAAAAAAAsQBNAAAqAAAzEAAATxAUAAIAAgAAAAAAAAAAAAAAAAAAAAAA JhACAA4AURAIAAABAAAAAAAANBAAADQQAAA0EAAAAxAMAAMAAQAFAAUAAQAAADMQAABREA8AAAIA AAAABwA6AAACAAAADRASAAAABwFSAGEAbgBnAGUAIAAyAFEQEwABAgAAAAALADsAAAIAAgABAAUA URATAAICAAAAAAsAOwAAAAAAAAEABQBREAgAAwEAAAAAAAAGEAgA//8BAAEAAAAzEAAAXxACAAAA NBAAAEUQAgAAAEMQBAD//wIAMxAAACUQIAACAgEAAAAAAN7///+0////AAAAAAAAAACxAE0AACoA ADMQAABPEBQAAgACAAAAAAAAAAAAAAAAAAAAAAAmEAIADgBREAgAAAEAAAAAAAA0EAAANBAAADQQ AAADEAwAAwABAAUABQABAAAAMxAAAFEQDwAAAgAAAAAHADoAAAMAAAANEBIAAAAHAVIAYQBuAGcA ZQAgADMAURATAAECAAAAAAsAOwAAAwADAAEABQBREBMAAgIAAAAACwA7AAAAAAAAAQAFAFEQCAAD AQAAAAAAAAYQCAD//wIAAgAAADMQAABfEAIAAAA0EAAARRACAAAAQxAEAP//AgAzEAAAJRAgAAIC AQAAAAAA3v///7T///8AAAAAAAAAALEATQAAKgAAMxAAAE8QFAACAAIAAAAAAAAAAAAAAAAAAAAA ACYQAgAOAFEQCAAAAQAAAAAAADQQAAA0EAAANBAAAEQQBAAaAAAAJBACAAIAJRAgAAICAQAAAAAA 3v///7T///8AAAAAAAAAALEATQCAIAAAMxAAAE8QFAACAAIAAAAAAAAAAAAAAAAAAAAAACYQAgAK AFEQCAAAAQAAAAAAADQQAAAkEAIAAwAlECAAAgIBAAAAAADe////tP///wAAAAAAAAAAsQBNAIAg AAAzEAAATxAUAAIAAgAAAAAAAAAAAAAAAAAAAAAAJhACAAwAURAIAAABAAAAAAAANBAAAEYQAgAB AEEQEgAAAEMAAAD2AgAAcg0AABMMAAAzEAAATxAUAAIAAgBDAAAA9QIAAHINAAAUDAAAHRASAAAA AAAAAAAAAAAAAAAAAAAAADMQAAAgEAgAAQABAAEAAQBiEBIAAAAAAAEAAAABAAAAAAAAAO8AHhAe AAIAAQEAAAAAAAAAAAAAAAAAAAAAAAAAACMATQAAACYQAgANACEQAgADAAcQDACAgIAAAAAAAAAA FwAKEBAAwMDAAAAAAAABAAAAFgBPADQQAAAdEBIAAQAAAAAAAAAAAAAAAAAAAAAAMxAAAB8QKgAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAHwEeEB4AAgADAQAAAAAAAAAA AAAAAAAAAAAAAAAAIwBNAAAAJhACAA0AIRACAAEABxAMAAAAAAAAAP//CQBNACEQAgADAAcQDAAA AAAAAAD//wkATQAKEBAA////AAAAAAABAAEATgBNADQQAAAlECAAAgIBAAAAAABeAAAANwYAAJsA AAAyAwAAgQJNAAAAWgAzEAAATxAUAAIAAgAAAAAAAAAAABcAAAA2AAAAJhACAAsAURAIAAABAAAA AAAADRAUAAAACAFEAGkAdgBpAHMAaQBvAG4AJxAGAAMAAAAAADQQAAAlECAAAgIBAAAAAAAzBgAA jg0AAMEDAABcAQAAgQBNAAoAAAAzEAAATxAUAAIAAgDR////0////48AAAAXAAAAJhACAAsAURAI AAABAAAAAAAADRAuAAAAFQFFAG0AcABsAG8AeQBlAGUAIABEAGkAcwB0AHIAaQBiAHUAdABpAG8A bgAnEAYAAgAAAAAANBAAABQQFAAAAAAAAAAAAAAAAAAAAAAAAAAAADMQAAAXEAYAnP+WAAcAIhAK AAAAAAAAAAAADwA6EA4AFAAPAB4AZABkAJYAFAAVEBQA/w0AAEgHAACGAQAAYAMAAAMBHwAzEAAA TxAUAAUAAgD/DQAARwcAAAAAAAAAAAAAJRAgAAICAQAAAAAA3v///7T///8AAAAAAAAAALEATQCw LAAAMxAAAE8QFAACAAIAAAAAAAAAAAAAAAAAAAAAAFEQCAAAAQAAAAAAADQQAAA0EAAANBAAADQQ AAAlECAAAgIBAAAAAAAnAgAATAAAAFELAAC3AQAAgQBNABATAAAzEAAATxAUAAIAAgAAAAAAAAAA AK8BAAAdAAAAJhACAA8AURAIAAABAAAAAAAADRB0AAAAOAFQAHIAbwBmAGUAcwBzAGkAbwBuAGEA bAAgAEIAZQBoAGEAdgBpAG8AcgAgAFIAYQB0AGkAbgBnAHMAIABEAGkAcwB0AHIAaQBiAHUAdABp AG8AbgAgAGYAbwByACAARABpAHYAaQBzAGkAbwBuAHMAJxAGAAEAAAAAADQQAAA0EAAAAAIOAAAA AAAFAAAAAAADAAAAZRACAAIABAIbAAAAAAAAAAkAAU0AYQByAGsAZQB0AGkAbgBnAAQCGwAAAAEA AAAJAAFNAGEAcgBrAGUAdABpAG4AZwAEAhsAAAACAAAACQABTQBhAHIAawBlAHQAaQBuAGcABAIT AAEAAAAAAAUAAVMAYQBsAGUAcwAEAhMAAQABAAAABQABUwBhAGwAZQBzAAQCEwABAAIAAAAFAAFT AGEAbABlAHMABAInAAIAAAAAAA8AAUgAdQBtAGEAbgAgAFIAZQBzAG8AdQByAGMAZQBzAAQCJwAC AAEAAAAPAAFIAHUAbQBhAG4AIABSAGUAcwBvAHUAcgBjAGUAcwAEAicAAgACAAAADwABSAB1AG0A YQBuACAAUgBlAHMAbwB1AHIAYwBlAHMABAIZAAMAAAAAAAgAAVIAZQBzAGUAYQByAGMAaAAEAhkA AwABAAAACAABUgBlAHMAZQBhAHIAYwBoAAQCGQADAAIAAAAIAAFSAGUAcwBlAGEAcgBjAGgABAId AAQAAAAAAAoAAVQAZQBjAGgAbgBvAGwAbwBnAHkABAIdAAQAAQAAAAoAAVQAZQBjAGgAbgBvAGwA bwBnAHkABAIdAAQAAgAAAAoAAVQAZQBjAGgAbgBvAGwAbwBnAHkAZRACAAEAAwIOAAAAAAAAAAAA AAAAAABAAwIOAAAAAQAAAAAAAAAAADlAAwIOAAAAAgAAAAAAAAAAACBAAwIOAAEAAAAAAAAAAAAA ABRAAwIOAAEAAQAAAAAAAAAAACRAAwIOAAEAAgAAAAAAAAAAAAAAAwIOAAIAAAAAAAAAAAAAAAAA AwIOAAIAAQAAAAAAAAAAABBAAwIOAAIAAgAAAAAAAAAAABhAAwIOAAMAAAAAAAAAAAAAAAhAAwIO AAMAAQAAAAAAAAAAADFAAwIOAAMAAgAAAAAAAAAAAAhAAwIOAAQAAAAAAAAAAAAAABBAAwIOAAQA AQAAAAAAAAAAAC5AAwIOAAQAAgAAAAAAAAAAADNAZRACAAMAPgIKAAQGAgAAAAAAAAAKAAAACQgQ AAAGEACvGM0HwUAAAAYBAAANAAIAAQAMAAIAZAAPAAIAAQARAAIAAAAQAAgA/Knx0k1iUD9fAAIA AQAqAAIAAAArAAIAAACCAAIAAQCAAAgAAAAAAAAAAAAlAgQAAAD/AIEAAgDBBBQAAAAVAAAAgwAC AAAAhAACAAAAoQAiAAAA/wABAAEAAQAEAAAAAAAAAAAAAADgPwAAAAAAAOA/AABVAAIACAAAAg4A AAAAAAQAAAAAAAYAAAAIAhAAAAAAAAYA/wAAAAAAAAEPAAgCEAABAAAABgD/AAAAAAAAAQ8ACAIQ AAIAAAAGAP8AAAAAAAABDwAIAhAAAwAAAAYA/wAAAAAAAAEPAAECBgAAAAAADwD9AAoAAAABAA8A AAAAAP0ACgAAAAIADwABAAAA/QAKAAAAAwAPAAIAAAD9AAoAAAAEAA8AAwAAAP0ACgAAAAUADwAE AAAA/QAKAAEAAAAPAAUAAAC9ACQAAQABAA8AAAAAQA8AAAAUQA8AAAAAAA8AAAAIQA8AAAAQQAUA /QAKAAIAAAAPAAYAAAC9ACQAAgABAA8AAAA5QA8AAAAkQA8AAAAQQA8AAAAxQA8AAAAuQAUA/QAK AAMAAAAPAAcAAAC9ACQAAwABAA8AAAAgQA8AAAAAAA8AAAAYQA8AAAAIQA8AAAAzQAUA1wAMAEIB AAA8AFAANgA2AOwAyAAPAALwwAAAABAACPAIAAAAAgAAAAEEAAAPAAPwqAAAAA8ABPAoAAAAAQAJ 8BAAAAAAAAAAAAAAAAAAAAAAAAAAAgAK8AgAAAAABAAABQAAAA8ABPBwAAAAkgwK8AgAAAABBAAA AAoAAJMAC/A2AAAAfwAEAQQBvwAIAAgAgQFOAAAIgwFNAAAIvwEQABEAwAFNAAAI/wEIAAgAPwIA AAIAvwMAAAgAAAAQ8BIAAAAAAAIAMAMFAFoADABAAhwAWgAAABHwAAAAAF0AGgAVABIABQABABFg AAAAANgDRwEAAAAAAAAAAAkIEAAABiAArxjNB8FAAAAGAQAAFAAAABUAAACDAAIAAACEAAIAAABN AKIDAABMAGUAeABtAGEAcgBrACAATwBwAHQAcgBhACAAVwA4ADEAMAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAQRsJtwAxAID9wAQAgABAAAAAAAAAAEABwBYAgEAAgBYAgIAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAEAAAAAAAAAAAAAAAAAAAAAAAAA4qSX vAABAQAAAAL/AgIAAQAAAAAAAExleG1hcmsgT3B0cmEgVzgxMAAAAAAAAAAAAAAAAAAAAACXAQAA TGV4bWFyayBPcHRyYSBXODEwAACoAwAAdQAAAAAAAAAIAMgA/3//fwAAAQAHAAwABgAFAAEAAAAG AAMAAwABAAAAAAAAAAAAAAANAAMAAQAAAAEAAwC/JucKAQABABAACgALABoAAADipJe8AgABAP8A CABYAiwBLAEsAQAAWAIAAAAAAAEAAAAAAAMAAIcAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEA AAcAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAoAAAAK AAAACgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAADipJe8oQAiAAEAZAABAAEAAQAAAFgCWAIAAAAAAADgPwAAAAAAAOA/ AQAzAAIAAwBgEAoAGCRiFvAAAQAFAGAQCgAYJGIWGAEBAAYAYBAKAIIU5grIAAAABwBgEAoAGCRi FvAAAAAIAGAQCgCCFOYKyAABAAkAEgACAAAAARACAAAAAhAQAAAAAAAAAAAA6H/VAej/JQEzEAAA oAAEAAEAAQBkEAgAAAABAAAAAQAyEAQAAAACADMQAAAHEAwAAAAAAAAA//8JAE0AChAQAP///wAA AAAAAQABAE4ATQA0EAAAAxAMAAMAAQAFAAUAAQAAADMQAABREA8AAAIAAAAABwA6AAABAAAADRAS AAAABwFSAGEAbgBnAGUAIAAxAFEQEwABAgAAAAALADsAAAEAAQABAAUAURATAAICAAAAAAsAOwAA AAAAAAEABQBREAgAAwEAAAAAAAAGEAgA//8AAAAAAAAzEAAAXxACAAAANBAAAEUQAgAAAEMQBAD/ /wIAMxAAACUQIAACAgEAAAAAAOD////M////AAAAAAAAAACxAE0AACoAADMQAABPEBQAAgACAAAA AAAAAAAAAAAAAAAAAAAmEAIACABREAgAAAEAAAAAAAA0EAAANBAAADQQAAADEAwAAwABAAUABQAB AAAAMxAAAFEQDwAAAgAAAAAHADoAAAIAAAANEBIAAAAHAVIAYQBuAGcAZQAgADIAURATAAECAAAA AAsAOwAAAgACAAEABQBREBMAAgIAAAAACwA7AAAAAAAAAQAFAFEQCAADAQAAAAAAAAYQCAD//wEA AQAAADMQAABfEAIAAAA0EAAARRACAAAAQxAEAP//AgAzEAAAJRAgAAICAQAAAAAA4P///8z///8A AAAAAAAAALEATQAAKgAAMxAAAE8QFAACAAIAAAAAAAAAAAAAAAAAAAAAACYQAgAIAFEQCAAAAQAA AAAAADQQAAA0EAAANBAAAAMQDAADAAEABQAFAAEAAAAzEAAAURAPAAACAAAAAAcAOgAAAwAAAA0Q EgAAAAcBUgBhAG4AZwBlACAAMwBREBMAAQIAAAAACwA7AAADAAMAAQAFAFEQEwACAgAAAAALADsA AAAAAAABAAUAURAIAAMBAAAAAAAABhAIAP//AgACAAAAMxAAAF8QAgAAADQQAABFEAIAAABDEAQA //8CADMQAAAlECAAAgIBAAAAAADg////zP///wAAAAAAAAAAsQBNAAAqAAAzEAAATxAUAAIAAgAA AAAAAAAAAAAAAAAAAAAAJhACAAgAURAIAAABAAAAAAAANBAAADQQAAA0EAAARBAEAAoAAAAkEAIA AgAlECAAAgIBAAAAAADg////zP///wAAAAAAAAAAsQBNAIAgAAAzEAAATxAUAAIAAgAAAAAAAAAA AAAAAAAAAAAAJhACAAcAURAIAAABAAAAAAAANBAAACQQAgADACUQIAACAgEAAAAAAOD////M//// AAAAAAAAAACxAE0AgCAAADMQAABPEBQAAgACAAAAAAAAAAAAAAAAAAAAAAAmEAIACQBREAgAAAEA AAAAAAA0EAAARhACAAEAQRASAAAADgIAAPEAAAAJCwAARQwAADMQAABPEBQAAgACABcBAABpAAAA /wsAAHUNAAAdEBIAAAAAAAAAAAAAAAAAAAAAAAAAMxAAACAQCAABAAEAAQABAGIQEgAAAAAAAQAA AAEAAAAAAAAA7wAeEB4AAgADAQAAAAAAAAAAAAAAAAAAAAAAAAAAIwBNAAAAJhACAAUANBAAAB0Q EgABAAAAAAAAAAAAAAAAAAAAAAAzEAAAHxAqAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAfAR4QHgACAAMBAAAAAAAAAAAAAAAAAAAAAAAAAAAjAE0AAAAmEAIABQAhEAIA AQAHEAwAAAAAAAAA//8JAE0ANBAAACUQIAACAgEAAAAAAIsGAADeDQAADgIAAE8BAACBAE0AAAAA ADMQAABPEBQAAgACAAAAAAAAAAAAUQAAACAAAAAmEAIABgBREAgAAAEAAAAAAAANEBQAAAAIAUQA aQB2AGkAcwBpAG8AbgAnEAYAAwAAAAAANBAAACUQIAACAgEAAAAAAEcAAADYAwAA0AAAAIEGAACB Ak0AAABaADMQAABPEBQAAgACAAAAAAAAAAAAIAAAAJ8AAAAmEAIABgBREAgAAAEAAAAAAAANECAA AAAOAUUAbQBwAGwAbwB5AGUAZQAgAEMAbwB1AG4AdAAnEAYAAgAAAAAANBAAADUQAAAyEAQAAAAD ADMQAAAHEAwAgICAAAAAAAAAABcAChAQAMDAwAAAAAAAAQAAABYATwA0EAAAFBAUAAAAAAAAAAAA AAAAAAAAAAAAAAAAMxAAABcQBgAAAJYAAAAiEAoAAAAAAAAAAAAPABUQFABeDQAAmwUAACgCAADy AgAAAwEfADMQAABPEBQABQACAF4NAACbBQAAAAAAAAAAAAAlECAAAgIBAAAAAADg////zP///wAA AAAAAAAAsQBNALAsAAAzEAAATxAUAAIAAgAAAAAAAAAAAAAAAAAAAAAAURAIAAABAAAAAAAANBAA ADQQAAAGEAgAAAAAAP3/AAAzEAAAXxACAAAABxAMAAAAAAAAAP//CQBNAAoQEAD///8AAAAAAAEA AQBOAE0ACxACAAAACRAUAAAAAAAAAAAAAgABAE0ATQA8AAAADBACAAEANBAAADQQAAA0EAAAJRAg AAICAQAAAAAA4P///8z///8AAAAAAAAAAJUATQDgIwAAMxAAAE8QFAACAAIAAAAAAAAAAAAAAAAA AAAAACYQAgAFAFEQCAAAAQAAAAAAACcQBgAEAAAA//80EAAAJRAgAAICAQAAAAAA4P///8z///8A AAAAAAAAAJUATQDgIwAAMxAAAE8QFAACAAIAAAAAAAAAAAAAAAAAAAAAACYQAgAFAFEQCAAAAQAA AAAAACcQBgAEAAEA//80EAAAJRAgAAICAQAAAAAALQUAABEMAABhAAAAEAEAAJUATQDgIwAAMxAA AE8QFAACAAIAAAAAAAAAAAAPAAAAGgAAACYQAgAFAFEQCAAAAQAAAAAAACcQBgAEAAEAAQA0EAAA JRAgAAICAQAAAAAA4P///8z///8AAAAAAAAAAJUATQDgIwAAMxAAAE8QFAACAAIAAAAAAAAAAAAA AAAAAAAAACYQAgAFAFEQCAAAAQAAAAAAACcQBgAEAAIA//80EAAANBAAAAACDgAAAAAABQAAAAAA AwAAAGUQAgACAGUQAgABAAMCDgAAAAAAAAAAAAAAAAAAAAMCDgAAAAEAAAAAAAAAAAAAAAMCDgAA AAIAAAAAAAAAAAAAAAMCDgABAAAAAAAAAAAAAAAAAAMCDgABAAEAAAAAAAAAAAAAAAMCDgABAAIA AAAAAAAAAAAAAAMCDgACAAAAAAAAAAAAAAAAAAMCDgACAAEAAAAAAAAAAAAAAAMCDgACAAIAAAAA AAAAAAAAAAMCDgADAAAAAAAAAAAAAAAAAAMCDgADAAEAAAAAAAAAAAAAAAMCDgADAAIAAAAAAAAA AAAAAAMCDgAEAAAAAAAAAAAAAAAAAAMCDgAEAAEAAAAAAAAAAAAAAAMCDgAEAAIAAAAAAAAAAAAA AGUQAgADAAoAAADtABgAAAAZ8RAAAAABAAAAAAAAAAEEAAABBAAAPgISALYAAAAAAEAAAAAAAAAA AAAAAB0ADwADFQAMAAAAAQAVABUADAzvAAYAAAA3AAAACgAAAAkIEAAABhAArxjNB8FAAAAGAQAA DQACAAEADAACAGQADwACAAEAEQACAAAAEAAIAPyp8dJNYlA/XwACAAEAKgACAAAAKwACAAAAggAC AAEAgAAIAAAAAAAAAAAAJQIEAAAA/wCBAAIAwQQUAAAAFQAAAIMAAgAAAIQAAgAAAKEAIgAAAP8A AQABAAEABAEADAwMAAAAAAAA4D8AAAAAAADgP24AVQACAAgAAAIOAAAAAAAAAAEAAAAAAAAAPgIS ALYAAAAAAEAAAAAAAAAAAAAAAB0ADwADAAAAAAAAAQAAAAAAAADvAAYAAAA3AAAACgAAAAkIEAAA BhAArxjNB8FAAAAGAQAADQACAAEADAACAGQADwACAAEAEQACAAAAEAAIAPyp8dJNYlA/XwACAAEA KgACAAAAKwACAAAAggACAAEAgAAIAAAAAAAAAAAAJQIEAAAA/wCBAAIAwQQUAAAAFQAAAIMAAgAA AIQAAgAAAKEAIgAAAP8AAQABAAEABAAAAAAAAAAAAAAA4D8AAAAAAADgP24AVQACAAgAAAIOAAAA AAAAAAEAAAAAAAAAPgISALYAAAAAAEAAAAAAAAAAAAAAAB0ADwADAAAAAAAAAQAAAAAAAADvAAYA AAA3AAAACgAAAAIAAAArAAIAAACCAAIAAQCAAAgAAAAAAAAAAAAlAgQAAAD/AIEAAgDBBBQAAAAV AAAAgwACAAAAhAACAAAAoQAiAAAA/wABAAEAAQAEAQAMDAwAAAAAAADgPwAAAAAAAOA/bgBVAAIA CAAAAg4AAAAAAAAAAQAAAAAAAAA+AhIAtgAAAAAAQAAAAAAAAAAAAAAAHQAPAAMAAAAAAAABAAAA AAAAAO8ABgAAADcAAAAKAAAACQgQAAAGEACvGM0HwUAAAAYBAAANAAIAAQAMAAIAZAAPAAIAAQAR AAIAAAAQAAgA/Knx0k1iUD9fAAIAAQAqAAIAAAArAAIAAACCAAIAAQCAAAgAAAAAAAAAAAAlAgQA AAD/AIEAAgDBBBQAAAAVAAAAgwACAAAAhAACAAAAoQAiAAAA/wABAAEAAQAEAAAAAAAAAAAAAADg PwAAAAAAAOA/bgBVAAIACAAAAg4AAAAAAAAAAQAAAAAAAAA+AhIAtgAAAAAAQAAAAAAAAAAAAAAA HQAPAAMAAAAAAAABAAAAAAAAAO8ABgAAADcAAAAKAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAABDaHJpc3RpbmEgUnllAHgAHgAAAA4AAABDaHJpc3RpbmEgUnllAHgAHgAAABAA AABNaWNyb3NvZnQgRXhjZWwAQAAAAIBWkz+fHcABQAAAAABlRa7aI8ABAwAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP7/AAAEAAIAAAAAAAAAAAAAAAAAAAAAAAEAAAAC1c3V nC4bEJOXCAArLPmuMAAAAAwBAAAJAAAAAQAAAFAAAAAPAAAAWAAAABcAAAB0AAAACwAAAHwAAAAQ AAAAhAAAABMAAACMAAAAFgAAAJQAAAANAAAAnAAAAAwAAADQAAAAAgAAAOQEAAAeAAAAFAAAAFBl cmZvcm1hd29ya3MsIEluYy4AAwAAAO0OCQALAAAAAAAAAAsAAAAAAAAACwAAAAAAAAALAAAAAAAA AB4QAAAEAAAABwAAAFNoZWV0MQAHAAAAU2hlZXQyAAcAAABTaGVldDMABwAAAENoYXJ0MQAMEAAA BAAAAB4AAAALAAAAV29ya3NoZWV0cwADAAAAAwAAAB4AAAAHAAAAQ2hhcnRzAAMAAAABAAAAAAAA AAAA/v8AAAQAAgAAAAAAAAAAAAAAAAAAAAAAAQAAAOCFn/L5T2gQq5EIACsns9kwAAAAeAEAABEA AAABAAAAkAAAAAUARABvAGMAdQBtAGUAbgB0AFMAdQBtAG0AYQByAHkASQBuAGYAbwByAG0AYQB0 AGkAbwBuAAAAAAAAAAAAAAA4AAIA////////////////AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAACgAAADwBAAAAAAAAMQBUAGEAYgBsAGUAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA4AAgABAAAAAwAAAP////8AAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAbAAAAVQUAAAAAAAAFAFMAdQBtAG0AYQByAHkASQBu AGYAbwByAG0AYQB0AGkAbwBuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAKAACAQIAAAAPAAAA /////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA8AAACoAQAAAAAAAAUARABv AGMAdQBtAGUAbgB0AFMAdQBtAG0AYQByAHkASQBuAGYAbwByAG0AYQB0AGkAbwBuAAAAAAAAAAAA AAA4AAIB////////////////AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAFgAA ACgBAAAAAAAAAgAAAJgAAAADAAAApAAAAAQAAACwAAAABQAAAMgAAAAGAAAA1AAAAAcAAADgAAAA CAAAAPQAAAAJAAAADAEAABIAAAAYAQAACgAAADQBAAAMAAAAQAEAAA0AAABMAQAADgAAAFgBAAAP AAAAYAEAABAAAABoAQAAEwAAAHABAAACAAAA5AQAAB4AAAACAAAAIABzAB4AAAABAAAAAABzAB4A AAAPAAAARGVubmlzIEVsZW5pY2gAAB4AAAABAAAAAGVubh4AAAABAAAAAGVubh4AAAALAAAATm9y bWFsLmRvdABpHgAAAA8AAABEZW5uaXMgRWxlbmljaAAAHgAAAAIAAAAxAG5uHgAAABMAAABNaWNy b3NvZnQgV29yZCA5LjAAAEAAAAAARsMjAAAAAEAAAAAAutKG+y7AAUAAAAAAAJaq+y7AAQMAAAAB AAAAAwAAAAMAAAADAAAAEwAAAAMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA/v8AAAQA AgAAAAAAAAAAAAAAAAAAAAAAAQAAAALVzdWcLhsQk5cIACss+a4wAAAA+AAAAAwAAAABAAAAaAAA AA8AAABwAAAABQAAAIwAAAAGAAAAlAAAABEAAACcAAAAFwAAAKQAAAALAAAArAAAABAAAAC0AAAA EwAAALwAAAAWAAAAxAAAAA0AAADMAAAADAAAANoAAAACAAAA5AQAAB4AAAAUAAAAUGVyZm9ybWF3 b3JrcywgSW5jLgADAAAAAQAAAAMAAAABAAAAAwAAABcAAAADAAAAoAoJAAsAAAAAAAAACwAAAAAA AAALAAAAAAAAAAsAAAAAAAAAHhAAAAEAAAACAAAAIAAMEAAAAgAAAB4AAAAGAAAAVGl0bGUAAwAA AAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAUAA8ACgABAGkADwADAAAAAAAAAAAAOAAAQPH/ AgA4AAwABgBOAG8AcgBtAGEAbAAAAAIAAAAYAENKGABfSAEEYUoYAG1ICQRzSAkEdEgJBAAAAAAA AAAAAAAAAAAAAAAAADwAQUDy/6EAPAAMABYARABlAGYAYQB1AGwAdAAgAFAAYQByAGEAZwByAGEA cABoACAARgBvAG4AdAAAAAAAAAAAAAAAAAAAAAAAGAAAAAUAAAwAAAAA/////wAAAAAaAAAAmAAA AAAwAAAAAAAAAIAAAACAAAQAABgEAAADAAAAAAQAABgEAAAEAAAAAAQAABgEAAAFAAAAAAAAABQA AAAWAAAAGAAAABM6lP+VgAAAAAAaAAAABwAAAAAAGgAAAAcA//8CAAAADgBEAGUAbgBuAGkAcwAg AEUAbABlAG4AaQBjAGgAKABDADoAXABFAGwAZQBuAGkAYwBoAFwASABvAHIAaQB6AG8AbgB0AGEA bAAgADEAMAAwACUALQBiAGEAcgAgAGMAaABhAHIAdAAuAGQAbwBjAP9AARABAAAAAAAXAAAABIN4 AAEAAQAAAAAAAQAAAAAAAAAAAAAAAhAAAAAAAAAAGAAAAFAAAAgAQAAA//8BAAAABwBVAG4AawBu AG8AdwBuAP//AQAIAAAAAAAAAAAAAAD//wEAAAAAAP//AAACAP//AAAAAP//AAACAP//AAAAAAMA AABHFpABAAACAgYDBQQFAgMEh3oAIAAAAIAIAAAAAAAAAP8BAAAAAAAAVABpAG0AZQBzACAATgBl AHcAIABSAG8AbQBhAG4AAAA1FpABAgAFBQECAQcGAgUHAAAAAAAAABAAAAAAAAAAAAAAAIAAAAAA UwB5AG0AYgBvAGwAAAAzJpABAAACCwYEAgICAgIEh3oAIAAAAIAIAAAAAAAAAP8BAAAAAAAAQQBy AGkAYQBsAAAAIgAEAPEIiBgA8NACAABoAQAAAACnK0qGqCtKhgAAAAABAAEAAAADAAAAEwAAAAEA AQAAAAQAAxABAAAAAAAAAAAAAAABAAEAAAABAAAAAAAAACQDAPAQAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAKUGwAe0ALQAgYFyMAAAAAAAAAAAAAAAAAAAFwAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACAAAAAAAAAAAA ADKDEQDwEAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP//EgAAAAAAAAABACAAAAAA AAAADgBEAGUAbgBuAGkAcwAgAEUAbABlAG4AaQBjAGgADgBEAGUAbgBuAGkAcwAgAEUAbABlAG4A aQBjAGgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAQD+/wMKAAD/////BgkCAAAAAADAAAAAAAAARhgAAABNaWNyb3NvZnQgV29y ZCBEb2N1bWVudAAKAAAATVNXb3JkRG9jABAAAABXb3JkLkRvY3VtZW50LjgA9DmycQAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAEAQwBvAG0AcABPAGIAagAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAASAAIA////////////////AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAMQAAAGoAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD///////////////8AAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP///////////////wAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA ////////////////AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAA ------_=_NextPart_000_01C02EFE.4CAFC072-- From owner-sqr-users@list.iex.net Thu Oct 5 17:49:42 2000 Date: Thu, 5 Oct 2000 22:42:14 GMT From: Ed Kelly Subject: Dates in local procedures How do you get SQR to treat a local variable as a date? It looks like dates passed to a local variable are converted to string. Here's a code fragments: Begin-Setup Declare-variable Date $Fromdate $Thrudate End-Declare End-Setup . . . . . . Begin-Procedure Main Let $FromDate = StrToDate('Jan 01 1995','Mon dd, YYYY') Let $ThruDate = StrToDate('Aug 01 1995','Mon dd, YYYY') If $FromDate > $ThruDate Show 'Test1: From date is greater than Thru date' ! Does not display End-if Do Test ($Fromdate, $ThruDate) End-Procedure Begin-Procedure Test($From, $Thru) If $FromDate > $ThruDate Show 'Test2: From date is greater than Thru date' ! Does display End-if End-Procedure _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. From owner-sqr-users@list.iex.net Thu Oct 5 17:58:49 2000 Date: Thu, 5 Oct 2000 15:52:11 -0700 From: John Doel Subject: Re: Dates in local procedures Declare a date to use within the local procedure: BEGIN-PROCEDURE Local($Date) Declare-Variable Date $Date End-Declare END-PROCEDURE John M. Doel Consultant PeopleSoft Consulting USA Phone: (877) 339-2982 "Ed Kelly" cc: Sent by: Subject: Dates in local procedures "Discussion of SQR, Brio Technology's database reporting language" 10/05/00 03:42 PM Please respond to sqr-users How do you get SQR to treat a local variable as a date? It looks like dates passed to a local variable are converted to string. Here's a code fragments: Begin-Setup Declare-variable Date $Fromdate $Thrudate End-Declare End-Setup . . . . . . Begin-Procedure Main Let $FromDate = StrToDate('Jan 01 1995','Mon dd, YYYY') Let $ThruDate = StrToDate('Aug 01 1995','Mon dd, YYYY') If $FromDate > $ThruDate Show 'Test1: From date is greater than Thru date' ! Does not display End-if Do Test ($Fromdate, $ThruDate) End-Procedure Begin-Procedure Test($From, $Thru) If $FromDate > $ThruDate Show 'Test2: From date is greater than Thru date' ! Does display End-if End-Procedure _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. From owner-sqr-users@list.iex.net Thu Oct 5 23:33:29 2000 Date: Thu, 5 Oct 2000 20:17:46 -0800 From: Gopal Krishan Subject: Re: Dates in local procedures use Declare-variable for local procedure also. like: Begin-Procedure Test($From, $Thru) Declare-variable Date $From $Thru End-Declare ... ... End-Procedure Hope it helps. Gopal "Ed Kelly" cc: Sent by: Subject: Dates in local procedures "Discussion of SQR, Brio Technology's database reporting language" 05/10/00 14:42 Please respond to sqr-users How do you get SQR to treat a local variable as a date? It looks like dates passed to a local variable are converted to string. Here's a code fragments: Begin-Setup Declare-variable Date $Fromdate $Thrudate End-Declare End-Setup . . . . . . Begin-Procedure Main Let $FromDate = StrToDate('Jan 01 1995','Mon dd, YYYY') Let $ThruDate = StrToDate('Aug 01 1995','Mon dd, YYYY') If $FromDate > $ThruDate Show 'Test1: From date is greater than Thru date' ! Does not display End-if Do Test ($Fromdate, $ThruDate) End-Procedure Begin-Procedure Test($From, $Thru) If $FromDate > $ThruDate Show 'Test2: From date is greater than Thru date' ! Does display End-if End-Procedure _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. From owner-sqr-users@list.iex.net Fri Oct 6 08:21:30 2000 Date: Fri, 6 Oct 2000 08:00:41 -0500 From: "Manning, Shinta" Subject: Re: Dates in local procedures One thing that I tried is to declare the variable within the procedure itself. For example: Begin-Procedure Test($From, $Thru) declare-variable DATE $from $thru end-declare If $FromDate > $ThruDate Show 'Test2: From date is greater than Thru date' ! Does display End-if End-Procedure > -----Original Message----- > From: Ed Kelly [SMTP:ed_kelly@HOTMAIL.COM] > Sent: Thursday, October 05, 2000 5:42 PM > To: SQR-USERS@list.iex.net > Subject: Dates in local procedures > > How do you get SQR to treat a local variable as a date? It looks like > dates > passed to a local variable are converted to string. Here's a code > fragments: > > Begin-Setup > Declare-variable > Date $Fromdate $Thrudate > End-Declare > End-Setup > > . . . . . . > > Begin-Procedure Main > Let $FromDate = StrToDate('Jan 01 1995','Mon dd, YYYY') > Let $ThruDate = StrToDate('Aug 01 1995','Mon dd, YYYY') > > If $FromDate > $ThruDate > Show 'Test1: From date is greater than Thru date' ! Does not display > End-if > > Do Test ($Fromdate, $ThruDate) > End-Procedure > > Begin-Procedure Test($From, $Thru) > If $FromDate > $ThruDate > Show 'Test2: From date is greater than Thru date' ! Does display > End-if > End-Procedure > > > _________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > Share information about yourself, create your own public profile at > http://profiles.msn.com. From owner-sqr-users@list.iex.net Fri Oct 6 08:55:37 2000 Date: Fri, 6 Oct 2000 09:32:01 -0400 From: "Turner, Ivan" Subject: Re: Dates in local procedures >From dates are logically LESS THAN Thru dates -----Original Message----- From: Manning, Shinta [mailto:ShintaManning@FINANCIAL.WELLSFARGO.COM] Sent: Friday, October 06, 2000 9:01 AM To: SQR-USERS@list.iex.net Subject: Re: Dates in local procedures One thing that I tried is to declare the variable within the procedure itself. For example: Begin-Procedure Test($From, $Thru) declare-variable DATE $from $thru end-declare If $FromDate > $ThruDate Show 'Test2: From date is greater than Thru date' ! Does display End-if End-Procedure > -----Original Message----- > From: Ed Kelly [SMTP:ed_kelly@HOTMAIL.COM] > Sent: Thursday, October 05, 2000 5:42 PM > To: SQR-USERS@list.iex.net > Subject: Dates in local procedures > > How do you get SQR to treat a local variable as a date? It looks like > dates > passed to a local variable are converted to string. Here's a code > fragments: > > Begin-Setup > Declare-variable > Date $Fromdate $Thrudate > End-Declare > End-Setup > > . . . . . . > > Begin-Procedure Main > Let $FromDate = StrToDate('Jan 01 1995','Mon dd, YYYY') > Let $ThruDate = StrToDate('Aug 01 1995','Mon dd, YYYY') > > If $FromDate > $ThruDate > Show 'Test1: From date is greater than Thru date' ! Does not display > End-if > > Do Test ($Fromdate, $ThruDate) > End-Procedure > > Begin-Procedure Test($From, $Thru) > If $FromDate > $ThruDate > Show 'Test2: From date is greater than Thru date' ! Does display > End-if > End-Procedure > > > _________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > Share information about yourself, create your own public profile at > http://profiles.msn.com. From owner-sqr-users@list.iex.net Fri Oct 6 08:54:02 2000 Date: Fri, 6 Oct 2000 15:42:23 +0200 From: "Kloprogge, F.J.M. (Frank)" Subject: Re: Dates in local procedures It might be simpler if you would convert dates to YYYYMMDD-format. In that case, you can compare dates as strings as well . i.e. in oracle: alter session set nls_date_format='YYYYMMDD' -----Oorspronkelijk bericht----- Van: Ed Kelly [mailto:ed_kelly@HOTMAIL.COM] Verzonden: vrijdag 6 oktober 2000 0:42 Aan: SQR-USERS@LIST.IEX.NET Onderwerp: Dates in local procedures How do you get SQR to treat a local variable as a date? It looks like dates passed to a local variable are converted to string. Here's a code fragments: Begin-Setup Declare-variable Date $Fromdate $Thrudate End-Declare End-Setup . . . . . . Begin-Procedure Main Let $FromDate = StrToDate('Jan 01 1995','Mon dd, YYYY') Let $ThruDate = StrToDate('Aug 01 1995','Mon dd, YYYY') If $FromDate > $ThruDate Show 'Test1: From date is greater than Thru date' ! Does not display End-if Do Test ($Fromdate, $ThruDate) End-Procedure Begin-Procedure Test($From, $Thru) If $FromDate > $ThruDate Show 'Test2: From date is greater than Thru date' ! Does display End-if End-Procedure _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. From owner-sqr-users@list.iex.net Fri Oct 6 14:43:49 2000 Date: Fri, 6 Oct 2000 15:31:18 -0400 From: Scott Barnes Subject: Re: Dates in local procedures All you have to do is declare the variables before any other line in the beginning of the local procedure. like this: >Begin-Procedure Test($From, $Thru) Declare-variable Date $From date $Thru End-Declare >If $FromDate > $ThruDate > Show 'Test2: From date is greater than Thru date' ! Does display >End-if >End-Procedure Scott At 06:42 PM 10/5/00, you wrote: >How do you get SQR to treat a local variable as a date? It looks like dates >passed to a local variable are converted to string. Here's a code >fragments: > >Begin-Setup >Declare-variable > Date $Fromdate $Thrudate >End-Declare >End-Setup > >. . . . . . > >Begin-Procedure Main >Let $FromDate = StrToDate('Jan 01 1995','Mon dd, YYYY') >Let $ThruDate = StrToDate('Aug 01 1995','Mon dd, YYYY') > >If $FromDate > $ThruDate > Show 'Test1: From date is greater than Thru date' ! Does not display >End-if > >Do Test ($Fromdate, $ThruDate) >End-Procedure > > > >_________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > >Share information about yourself, create your own public profile at >http://profiles.msn.com. From owner-sqr-users@list.iex.net Fri Oct 6 15:24:37 2000 Date: Fri, 6 Oct 2000 14:54:56 -0500 From: Joe Johnson This is a multi-part message in MIME format. ------=_NextPart_000_008B_01C02FA5.64470860 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Please excuse this lengthy post --=20 I am trying to write the contents of one field in a csv file to a txt = file ( I also need the other fields later on in the SQR). The problem: On unstring, the SQR assigns the text only from the first line to = $RESUME_TXT, and then everything following gets thrown off. If I comment = out this field, then everything else runs fine.=20 In trying to address that problem,=20 I tried using substr() and instr() to identify patterns of the fields = preceding and following the clunker resume field. The preceding field = always starts with 4 zeroes and the field following is always a date = field in the format DD/MM/YYYY. Now, I have a second problem as well - I get an error that 'Specified = file number not opened for writing." Is my substr() and/or instr() syntax right? Here is my code: !********************************************* Begin-Program !********************************************* Let $Input_File =3D 'H:\EmpACT_Work_Area\Empact_out.csv' Show '$Input_File =3D ' $Input_File Open $Input_File as 1 For-Reading Record=3D1000 Status=3D#OpenStat If #OpenStat !=3D 0 Show 'Error Opening ' $Input_File Else Show $Input_File ' has been opened for reading.' End-If Do Read-Input-File End-Program !********************************************* Begin-Procedure Read-Input-File !********************************************* Show 'Now reading ' $Input_File Move 0 To #Tot_Recs While Not #end-file Read 1 Into $Input:1000 If #end-file Break End-If Unstring $Input By ',' Into $EMPLID $RESUME_TXT !<----- this is the scanned resume field=20 $MOD_DTTM $MOD_USER $BRANCH_ID $SSN $FIRST_NAME $MIDDLE_NAME $LAST_NAME $ADDRESS1 $CITY $STATE $ZIP $COUNTY Add 1 to #Tot_Recs Display 'Total records exported: ' Noline Display #Tot_Recs 999,999,999 Let $RESUME_FILE_NAME =3D $EMPLID ||'.txt' Show '$RESUME_FILE_NAME =3D ' $RESUME_FILE_NAME Let $RESUME_TEXT_FILE =3D 'd:\temp\'||$RESUME_FILE_NAME =20 Show '$RESUME_TEXT_FILE =3D ' $RESUME_TEXT_FILE If substr($read,1,4) =3D '0000' Open $RESUME_TEXT_FILE as 2 For-Writing Record=3D1000 = Status=3D#OpenStat If #OpenStat !=3D 0 Show 'Error opening ' $RESUME_TEXT_FILE Else Show $RESUME_TEXT_FILE ' has been opened for writing.' End-If End-if Write 2 from $read If instr($read, '/', 4) =3D 3 and instr($read, '/', 4) =3D 6 Close 2 End-if End-While Display 'Total Records Inserted: ' Noline Display #Tot_Recs 999,999,999 End-Procedure *************************************************************************= **************** As always, thanks in advance! Joe Johnson PeopleSoft Systems Analyst joejo@snellingcorp.com 972-776-1332 ------=_NextPart_000_008B_01C02FA5.64470860 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Please excuse this lengthy post -- =
 
I am trying to write the contents of = one field in a=20 csv file to a txt file ( I also need the other fields later on  in = the=20 SQR).
 
The problem:
On unstring, the SQR assigns the text = only from the=20 first line to $RESUME_TXT, and then everything following gets thrown = off. If I=20 comment out this field, then everything else runs fine.
 
In trying to address that problem, =
I tried using substr() and instr() to = identify=20 patterns of the fields preceding and following the clunker resume field. = The=20 preceding field always starts with 4 zeroes and the field following is = always a=20 date field in the format DD/MM/YYYY.
 
Now, I have a second problem as well - I get an error that = 'Specified file=20 number not opened for writing."
 
Is my substr() and/or instr() syntax right?
 
Here is my code:
 
!*********************************************
Begin-Program<= BR>!*********************************************
 =20 Let $Input_File =3D 'H:\EmpACT_Work_Area\Empact_out.csv'
  Show=20 '$Input_File =3D ' $Input_File
 
  Open $Input_File as 1 = For-Reading=20 Record=3D1000 Status=3D#OpenStat
  If #OpenStat !=3D=20 0
        Show 'Error Opening '=20 $Input_File
  Else
        = Show  $Input_File ' has been opened for reading.'
 =20 End-If
 
Do Read-Input-File
 
End-Program
!*********************************************Begin-Procedure=20 Read-Input-File
!*********************************************
Show= 'Now=20 reading ' $Input_File
 Move 0 To #Tot_Recs
 
 While Not #end-file
  = Read 1 Into=20 $Input:1000
  If #end-file
    Break
  = End-If
 
  Unstring $Input By ',' = Into
 =20 $EMPLID
  $RESUME_TXT     !<----- this is = the=20 scanned resume field
  $MOD_DTTM
  $MOD_USER
 =20 $BRANCH_ID
  $SSN
  $FIRST_NAME
  = $MIDDLE_NAME
 =20 $LAST_NAME
  $ADDRESS1
  $CITY
  = $STATE
 =20 $ZIP
  $COUNTY
 
  Add 1 to  = #Tot_Recs
  Display=20 'Total records exported: ' Noline
  Display #Tot_Recs=20 999,999,999
 
  Let $RESUME_FILE_NAME =3D = $EMPLID=20 ||'.txt'
  Show '$RESUME_FILE_NAME =3D ' = $RESUME_FILE_NAME
 
  Let $RESUME_TEXT_FILE =3D=20 'd:\temp\'||$RESUME_FILE_NAME      <= /DIV>
  Show '$RESUME_TEXT_FILE =3D '=20 $RESUME_TEXT_FILE
 
  If substr($read,1,4) =3D=20 '0000'
   Open $RESUME_TEXT_FILE as 2 For-Writing = Record=3D1000=20 Status=3D#OpenStat
 
   If #OpenStat !=3D=20 0
      Show 'Error opening '=20 $RESUME_TEXT_FILE
   = Else
      =20 Show $RESUME_TEXT_FILE ' has been opened for writing.'
  =20 End-If
  End-if

  Write 2  from = $read
 
  If instr($read, '/', 4) =3D 3
   and = instr($read, '/', 4)=20 =3D 6
  Close 2
  End-if
 
  End-While

 Display 'Total Records Inserted: ' = Noline
 Display=20 #Tot_Recs 999,999,999

End-Procedure
********************************************************************= *********************
As always, thanks in advance!
Joe Johnson
PeopleSoft Systems = Analyst
joejo@snellingcorp.com
972-= 776-1332
------=_NextPart_000_008B_01C02FA5.64470860-- From owner-sqr-users@list.iex.net Fri Oct 6 15:19:38 2000 Date: Sat, 7 Oct 2000 01:33:38 +0530 From: Siva Prasad Juluri Subject: SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000) hi friends, I have a small problem, please can u look into and help me out. My goal is to take the current-date and printing on to the screen. Before printing on to the screen i am moving the current to some other temporary variable and 'Edit Mask'ing for purpose of showing year part as 4 digits(I mean showing the date as mm/dd/yyyy) Then I am getting "SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000)" warning message. how to get rid of this message other than changing Standard settings in SQR.INI file. Thanx, Siva _______________________________ *** Confidentiality Notice *** Proprietary/Confidential Information belonging to IMRglobal Corp. may be contained in this message. If you are not a recipient indicated or intended in this message (or responsible for delivery of this message to such person), or you think for any reason that this message may have been addressed to you in error, you may not use or copy or deliver this message to anyone else. In such case, you should destroy this message and kindly notify the sender by reply email. From owner-sqr-users@list.iex.net Fri Oct 6 15:33:37 2000 Date: Fri, 6 Oct 2000 16:09:35 -0400 From: Mario Mendoza Subject: Re: SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000) Just a thought, I have not actually done this, but try declaring two variable_names, one for each use. > -----Original Message----- > From: Siva Prasad Juluri [SMTP:jsiva@BANGALORE.IMRGLOBAL.COM] > Sent: October 06, 2000 4:04 PM > To: SQR-USERS@list.iex.net > Subject: SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000) > > hi friends, > I have a small problem, please can u look into and help me out. > > My goal is to take the current-date and printing on to the screen. > Before printing on to the screen i am moving the current to some other > temporary variable and 'Edit Mask'ing for purpose of showing year part as > 4 digits(I mean showing the date as mm/dd/yyyy) Then I am getting > > "SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000)" warning > message. > > how to get rid of this message other than changing Standard settings in > SQR.INI file. > > Thanx, > Siva > > _______________________________ > *** Confidentiality Notice *** > > Proprietary/Confidential > Information belonging to IMRglobal Corp. > may be contained in this message. > If you are not a recipient indicated or > intended in this message (or responsible > for delivery of this message to such > person), or you think for any reason that > this message may have been addressed to > you in error, you may not use or copy or > deliver this message to anyone else. > In such case, you should destroy this > message and kindly notify the sender > by reply email. From owner-sqr-users@list.iex.net Fri Oct 6 16:18:05 2000 Date: Fri, 6 Oct 2000 15:57:53 -0500 From: Joe Johnson Subject: Re: SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000) Siva, I think we had to do something like this: TO_CHAR(to_date('12/31/99','MM/DD/YY'),'MM/DD/YYYY') !for Oracle or TO_CHAR(&temp_date, 'MM/DD/YYYY') !for SQR HTH --- Y2K seems like so long ago! Joe Johnson PeopleSoft Systems Analyst joejo@snellingcorp.com 972-776-1332 ----- Original Message ----- From: "Siva Prasad Juluri" To: Sent: Friday, October 06, 2000 3:03 PM Subject: SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000) > hi friends, > I have a small problem, please can u look into and help me out. > > My goal is to take the current-date and printing on to the screen. Before printing on to the screen i am moving the current to some other temporary variable and 'Edit Mask'ing for purpose of showing year part as 4 digits(I mean showing the date as mm/dd/yyyy) Then I am getting > > "SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000)" warning message. > > how to get rid of this message other than changing Standard settings in SQR.INI file. > > Thanx, > Siva > > _______________________________ > *** Confidentiality Notice *** > > Proprietary/Confidential > Information belonging to IMRglobal Corp. > may be contained in this message. > If you are not a recipient indicated or > intended in this message (or responsible > for delivery of this message to such > person), or you think for any reason that > this message may have been addressed to > you in error, you may not use or copy or > deliver this message to anyone else. > In such case, you should destroy this > message and kindly notify the sender > by reply email. > From owner-sqr-users@list.iex.net Fri Oct 6 16:43:21 2000 Date: Fri, 6 Oct 2000 15:07:22 -0600 From: Jon Alsager Subject: Re: SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000) When you say 'other than changing Standard settings in SQR.INI file', are saying you don't want to change anything in the .ini file? The manual indicates you can stop the message by inserting the following in sqr.ini: OutputTwoDigitYearWarningMsg=False -----Original Message----- From: Siva Prasad Juluri [mailto:jsiva@BANGALORE.IMRGLOBAL.COM] Sent: Friday, October 06, 2000 2:04 PM To: SQR-USERS@list.iex.net Subject: SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000) hi friends, I have a small problem, please can u look into and help me out. My goal is to take the current-date and printing on to the screen. Before printing on to the screen i am moving the current to some other temporary variable and 'Edit Mask'ing for purpose of showing year part as 4 digits(I mean showing the date as mm/dd/yyyy) Then I am getting "SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000)" warning message. how to get rid of this message other than changing Standard settings in SQR.INI file. Thanx, Siva _______________________________ *** Confidentiality Notice *** Proprietary/Confidential Information belonging to IMRglobal Corp. may be contained in this message. If you are not a recipient indicated or intended in this message (or responsible for delivery of this message to such person), or you think for any reason that this message may have been addressed to you in error, you may not use or copy or deliver this message to anyone else. In such case, you should destroy this message and kindly notify the sender by reply email. From owner-sqr-users@list.iex.net Fri Oct 6 16:42:07 2000 Date: Fri, 6 Oct 2000 16:08:10 -0500 From: Joe Johnson Subject: using substr() and instr() to identify patterns of fields This is a multi-part message in MIME format. ------=_NextPart_000_00F1_01C02FAF.9F7EE650 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Please excuse this lengthy post --=20 I am trying to write the contents of one field in a csv file to a txt = file ( I also need the other fields later on in the SQR). The problem: On unstring, the SQR assigns the text only from the first line to = $RESUME_TXT, and then everything following gets thrown off. If I comment = out this field, then everything else runs fine.=20 In trying to address that problem,=20 I tried using substr() and instr() to identify patterns of the fields = preceding and following the clunker resume field. The preceding field = always starts with 4 zeroes and the field following is always a date = field in the format DD/MM/YYYY. Now, I have a second problem as well - I get an error that 'Specified = file number not opened for writing." Is my substr() and/or instr() syntax right? Here is my code: !********************************************* Begin-Program !********************************************* Let $Input_File =3D 'H:\EmpACT_Work_Area\Empact_out.csv' Show '$Input_File =3D ' $Input_File Open $Input_File as 1 For-Reading Record=3D1000 Status=3D#OpenStat If #OpenStat !=3D 0 Show 'Error Opening ' $Input_File Else Show $Input_File ' has been opened for reading.' End-If Do Read-Input-File End-Program !********************************************* Begin-Procedure Read-Input-File !********************************************* Show 'Now reading ' $Input_File Move 0 To #Tot_Recs While Not #end-file Read 1 Into $Input:1000 If #end-file Break End-If Unstring $Input By ',' Into $EMPLID $RESUME_TXT !<----- this is the scanned resume field=20 $MOD_DTTM $MOD_USER $BRANCH_ID $SSN $FIRST_NAME $MIDDLE_NAME $LAST_NAME $ADDRESS1 $CITY $STATE $ZIP $COUNTY Add 1 to #Tot_Recs Display 'Total records exported: ' Noline Display #Tot_Recs 999,999,999 Let $RESUME_FILE_NAME =3D $EMPLID ||'.txt' Show '$RESUME_FILE_NAME =3D ' $RESUME_FILE_NAME Let $RESUME_TEXT_FILE =3D 'd:\temp\'||$RESUME_FILE_NAME =20 Show '$RESUME_TEXT_FILE =3D ' $RESUME_TEXT_FILE If substr($read,1,4) =3D '0000' Open $RESUME_TEXT_FILE as 2 For-Writing Record=3D1000 = Status=3D#OpenStat If #OpenStat !=3D 0 Show 'Error opening ' $RESUME_TEXT_FILE Else Show $RESUME_TEXT_FILE ' has been opened for writing.' End-If End-if Write 2 from $read If instr($read, '/', 4) =3D 3 and instr($read, '/', 4) =3D 6 Close 2 End-if End-While Display 'Total Records Inserted: ' Noline Display #Tot_Recs 999,999,999 End-Procedure *************************************************************************= **************** As always, thanks in advance! Joe Johnson PeopleSoft Systems Analyst joejo@snellingcorp.com 972-776-1332 ------=_NextPart_000_00F1_01C02FAF.9F7EE650 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Please excuse this lengthy post -- =
 
I am trying to write the contents of = one field in a=20 csv file to a txt file ( I also need the other fields later on  in = the=20 SQR).
 
The problem:
On unstring, the SQR assigns the text = only from the=20 first line to $RESUME_TXT, and then everything following gets thrown = off. If I=20 comment out this field, then everything else runs fine.
 
In trying to address that problem, =
I tried using substr() and instr() to = identify=20 patterns of the fields preceding and following the clunker resume field. = The=20 preceding field always starts with 4 zeroes and the field following is = always a=20 date field in the format DD/MM/YYYY.
 
Now, I have a second problem as well - I get an error that = 'Specified file=20 number not opened for writing."
 
Is my substr() and/or instr() syntax right?
 
Here is my code:
 
!*********************************************
Begin-Program<= BR>!*********************************************
 =20 Let $Input_File =3D 'H:\EmpACT_Work_Area\Empact_out.csv'
  Show=20 '$Input_File =3D ' $Input_File
 
  Open $Input_File as 1 = For-Reading=20 Record=3D1000 Status=3D#OpenStat
  If #OpenStat !=3D=20 0
        Show 'Error Opening '=20 $Input_File
  Else
        = Show  $Input_File ' has been opened for reading.'
 =20 End-If
 
Do Read-Input-File
 
End-Program
!*********************************************Begin-Procedure=20 Read-Input-File
!*********************************************
Show= 'Now=20 reading ' $Input_File
 Move 0 To #Tot_Recs
 
 While Not #end-file
  = Read 1 Into=20 $Input:1000
  If #end-file
    Break
  = End-If
 
  Unstring $Input By ',' = Into
 =20 $EMPLID
  $RESUME_TXT     !<----- this is = the=20 scanned resume field
  $MOD_DTTM
  $MOD_USER
 =20 $BRANCH_ID
  $SSN
  $FIRST_NAME
  = $MIDDLE_NAME
 =20 $LAST_NAME
  $ADDRESS1
  $CITY
  = $STATE
 =20 $ZIP
  $COUNTY
 
  Add 1 to  = #Tot_Recs
  Display=20 'Total records exported: ' Noline
  Display #Tot_Recs=20 999,999,999
 
  Let $RESUME_FILE_NAME =3D = $EMPLID=20 ||'.txt'
  Show '$RESUME_FILE_NAME =3D ' = $RESUME_FILE_NAME
 
  Let $RESUME_TEXT_FILE =3D=20 'd:\temp\'||$RESUME_FILE_NAME      <= /DIV>
  Show '$RESUME_TEXT_FILE =3D '=20 $RESUME_TEXT_FILE
 
  If substr($read,1,4) =3D=20 '0000'
   Open $RESUME_TEXT_FILE as 2 For-Writing = Record=3D1000=20 Status=3D#OpenStat
 
   If #OpenStat !=3D=20 0
      Show 'Error opening '=20 $RESUME_TEXT_FILE
   = Else
      =20 Show $RESUME_TEXT_FILE ' has been opened for writing.'
  =20 End-If
  End-if

  Write 2  from = $read
 
  If instr($read, '/', 4) =3D 3
   and = instr($read, '/', 4)=20 =3D 6
  Close 2
  End-if
 
  End-While

 Display 'Total Records Inserted: ' = Noline
 Display=20 #Tot_Recs 999,999,999

End-Procedure
********************************************************************= *********************
As always, thanks in advance!
Joe Johnson
PeopleSoft Systems = Analyst
joejo@snellingcorp.com
972-= 776-1332
------=_NextPart_000_00F1_01C02FAF.9F7EE650-- From owner-sqr-users@list.iex.net Sun Oct 8 19:20:47 2000 Date: Sun, 8 Oct 2000 19:08:33 -0500 From: Don Mellen Subject: Re: using substr() and instr() to identify patterns of fields Just took a glance at your code, but I noticed in the section... If substr($read,1,4) = '0000' Open $RESUME_TEXT_FILE as 2 For-Writing Record=1000 Status=#OpenStat If #OpenStat != 0 Show 'Error opening ' $RESUME_TEXT_FILE Else Show $RESUME_TEXT_FILE ' has been opened for writing.' End-If End-if Write 2 from $read that $read never got defined, so it will never be '0000' in your "if" statement, so the "open" command won't be executed, thus, the "not opened" error. 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 Sat Oct 7 12:37:23 2000 Date: Sat, 7 Oct 2000 13:55:00 -0400 From: Yuriy Grigoryants Subject: SQR under MS-DOS or Windows Hi all, I need to execute SQR programs in batch mode under MS-DOS or Windows. Can anyone send me a sample of batch file to Run SQR ? Thanks for any help you can give. Regards, Yuriy Grigoryants From owner-sqr-users@list.iex.net Sun Oct 8 21:34:26 2000 Date: Mon, 9 Oct 2000 15:10:24 +1300 From: Chris Gin Subject: Equivalent products to SQR? Hi, We have been forced into looking at replacing SQR due to the change in the licencing structure by Brio. Currently we run SQR on Unix and we're looking at migrating to an NT environment. Are there any products out there that even come close to SQR in terms of functionality? The reason we're looking at using something else is because we're told that the cost of a user licence is now based on the power of the machine it's running on. For us, this means an increase of 1000% which is ridiculous. Thanks, Chris From owner-sqr-users@list.iex.net Mon Oct 9 08:57:31 2000 Date: Mon, 9 Oct 2000 07:47:24 -0600 From: Juan Alvarado Subject: Re: Equivalent products to SQR? That i know is that the license of sqr is base in the number of cpu's of the machine that run the SQR server. The range is 1-2 cpu's 3-4 " And so on... Know it's not important the O.S where the SQR SERVER run . That is important is the cpu's number. I hope this help you -----Original Message----- From: Chris Gin [mailto:Chris_Gin@CARDLINK.CO.NZ] Sent: Sunday, October 08, 2000 8:10 PM To: SQR-USERS@list.iex.net Subject: Equivalent products to SQR? Hi, We have been forced into looking at replacing SQR due to the change in the licencing structure by Brio. Currently we run SQR on Unix and we're looking at migrating to an NT environment. Are there any products out there that even come close to SQR in terms of functionality? The reason we're looking at using something else is because we're told that the cost of a user licence is now based on the power of the machine it's running on. For us, this means an increase of 1000% which is ridiculous. Thanks, Chris From owner-sqr-users@list.iex.net Mon Oct 9 09:07:23 2000 Date: Mon, 9 Oct 2000 08:56:29 -0500 From: "Manning, Shinta" Subject: Re: Equivalent products to SQR? hmmmm.... I use Visual SQRibe on NT, but run it on UNIX server... I agree with Juan... I don't think you need to change server, but SQRibe does run on NT also > -----Original Message----- > From: Juan Alvarado [SMTP:juan@GYSSA.COM.GT] > Sent: Monday, October 09, 2000 8:47 AM > To: SQR-USERS@list.iex.net > Subject: Re: Equivalent products to SQR? > > That i know is that the license of sqr is base in the number of cpu's of > the machine that run the SQR server. > > The range is 1-2 cpu's > 3-4 " > > And so on... > > Know it's not important the O.S where the SQR SERVER run . That is > important is the cpu's number. > > I hope this help you > > -----Original Message----- > From: Chris Gin [mailto:Chris_Gin@CARDLINK.CO.NZ] > Sent: Sunday, October 08, 2000 8:10 PM > To: SQR-USERS@list.iex.net > Subject: Equivalent products to SQR? > > > Hi, > > We have been forced into looking at replacing SQR due to the change in > the > licencing structure by Brio. Currently we run SQR on Unix and we're > looking > at migrating to an NT environment. > > Are there any products out there that even come close to SQR in terms of > functionality? > > The reason we're looking at using something else is because we're told > that > the cost of a user licence is now based on the power of the machine it's > running on. For us, this means an increase of 1000% which is ridiculous. > > Thanks, > Chris From owner-sqr-users@list.iex.net Mon Oct 9 09:47:29 2000 Date: Mon, 9 Oct 2000 09:33:43 -0500 From: cshelton Subject: Re: Equivalent products to SQR? I'd suggest looking at perl. I've been working with both sqr and perl for about 4 years now. Even though perl might have a slightly steeper learning curve than sqr, it can do everything that I know that sqr can do and a whole lot more. Try starting at www.perl.com and www.perl.org for researching perl. In my experience, support for perl is significantly better than with sqr, especially if you are able to search on the net for answers. The two biggest issues that I see in favor of perl over sqr are total cost of ownership and control of software. For the cost of one SQR license, you can buy quite a library of perl books, as well as attend training sessions or even bring in an on-site firm to train people in perl. Since perl is open source software, you don't have to pay any organization for the right to use it. Eric Scott Raymond described the control issue well, in his recent talks about this issue: "An executive who allows his company to becomes dependent on software he is not allowed to see inside, let alone change, has lost control of his business, and is on the wrong side of a monopoly relationship with a vendor who can thereby control his business. With open source, the executive is in control, and nobody can take that away. " - Eric Scott Raymond, "Meme Hacking for Fun and Profit" Chris Shelton On Mon, 9 Oct 2000, Chris Gin wrote: > Hi, > > We have been forced into looking at replacing SQR due to the change in the > licencing structure by Brio. Currently we run SQR on Unix and we're looking > at migrating to an NT environment. > > Are there any products out there that even come close to SQR in terms of > functionality? > > The reason we're looking at using something else is because we're told that > the cost of a user licence is now based on the power of the machine it's > running on. For us, this means an increase of 1000% which is ridiculous. > > Thanks, > Chris > > From owner-sqr-users@list.iex.net Tue Oct 10 09:29:13 2000 Date: Tue, 10 Oct 2000 10:13:20 -0400 From: John Milardovic Subject: Re: Equivalent products to SQR? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_01C032C4.3E71E050 Content-Type: text/plain I would second that suggestion. I recently created 5 operational reports in perl and it was a snap. I also benchmarked a perl report against an identical SQR report (see attachment). I found also that I could DRASTICALLY increase the time that perl reports took if I scrapped joins and instead joined the rows programmatically (one report went from 2-3 minutes to about 30 seconds - although perhaps better indexing of the tables and better use of existing indexes would have worked also). <> HTH John Milardovic > -----Original Message----- > From: cshelton [SMTP:cshelton@INDIANA.EDU] > Sent: Monday, October 09, 2000 10:34 AM > To: SQR-USERS@list.iex.net > Subject: Re: Equivalent products to SQR? > > I'd suggest looking at perl. I've been working with both sqr and perl for > about 4 years now. Even though perl might have a slightly steeper learning > curve than sqr, it can do everything that I know that sqr can do and a > whole lot more. > > Try starting at www.perl.com and www.perl.org for researching perl. In my > experience, support for perl is significantly better than with sqr, > especially if you are able to search on the net for answers. > > The two biggest issues that I see in favor of perl over sqr are total cost > of ownership and control of software. For the cost of one SQR license, > you can buy quite a library of perl books, as well as attend training > sessions or even bring in an on-site firm to train people in perl. Since > perl is open source software, you don't have to pay any organization for > the right to use it. > > Eric Scott Raymond described the control issue well, in his recent talks > about this issue: > > "An executive who allows his company to becomes dependent on software he > is not allowed to see inside, let alone change, has lost control of his > business, and is on the wrong side of a monopoly relationship with a > vendor who can thereby control his business. With open source, the > executive is in control, and nobody can take that away. " > - Eric Scott Raymond, "Meme Hacking for Fun and Profit" > > Chris Shelton > > On Mon, 9 Oct 2000, Chris Gin wrote: > > > Hi, > > > > We have been forced into looking at replacing SQR due to the change in > the > > licencing structure by Brio. Currently we run SQR on Unix and we're > looking > > at migrating to an NT environment. > > > > Are there any products out there that even come close to SQR in terms of > > functionality? > > > > The reason we're looking at using something else is because we're told > that > > the cost of a user licence is now based on the power of the machine it's > > running on. For us, this means an increase of 1000% which is ridiculous. > > > > Thanks, > > Chris > > > > ------_=_NextPart_000_01C032C4.3E71E050 Content-Type: application/msword; name="Perl vs SQR Benchmarking.doc" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="Perl vs SQR Benchmarking.doc" 0M8R4KGxGuEAAAAAAAAAAAAAAAAAAAAAPgADAP7/CQAGAAAAAAAAAAAAAAABAAAAMwAAAAAAAAAA EAAANQAAAAEAAAD+////AAAAADIAAAD///////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////s pcEAcQAJBAAAABK/AAAAAAAAEAAAAAAABAAALg0AAA4AYmpianQrdCsAAAAAAAAAAAAAAAAAAAAA AAAJBBYAHjIAABZBAQAWQQEALgkAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD//w8AAAAA AAAAAAD//w8AAAAAAAAAAAD//w8AAAAAAAAAAAAAAAAAAAAAAF0AAAAAAPoAAAAAAAAA+gAAAPoA AAAAAAAA+gAAAAAAAAD6AAAAAAAAAPoAAAAAAAAA+gAAABQAAAAAAAAAAAAAAA4BAAAAAAAADgEA AAAAAAAOAQAAAAAAAA4BAAAAAAAADgEAAAwAAAAaAQAARAAAAA4BAAAAAAAABAcAALYAAACSAQAA AAAAAJIBAAAAAAAAkgEAAAAAAACSAQAAAAAAAJIBAAAAAAAAkgEAAAAAAACSAQAAAAAAAJIBAAAA AAAAyQYAAAIAAADLBgAAAAAAAMsGAAAAAAAAywYAAAAAAADLBgAAAAAAAMsGAAAAAAAAywYAACQA AAC6BwAA9AEAAK4JAAB2AAAA7wYAABUAAAAAAAAAAAAAAAAAAAAAAAAA+gAAAAAAAACSAQAAAAAA AAAAAAAAAAAAAAAAAAAAAACSAQAAAAAAAJIBAAAAAAAAkgEAAAAAAACSAQAAAAAAAO8GAAAAAAAA ugIAAAAAAAD6AAAAAAAAAPoAAAAAAAAAkgEAAAAAAAAAAAAAAAAAAJIBAAAAAAAAkgEAAAAAAAC6 AgAAAAAAALoCAAAAAAAAugIAAAAAAACSAQAA7gAAAPoAAAAAAAAAkgEAAAAAAAD6AAAAAAAAAJIB AAAAAAAAyQYAAAAAAAAAAAAAAAAAAAAAAAAAAAAADgEAAAAAAAAOAQAAAAAAAPoAAAAAAAAA+gAA AAAAAAD6AAAAAAAAAPoAAAAAAAAAkgEAAAAAAADJBgAAAAAAALoCAACcAwAAugIAAAAAAABWBgAA HgAAAKkGAAAYAAAA+gAAAAAAAAD6AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAyQYAAAAAAACSAQAAAAAAAF4BAAA0AAAAYH+s4GDa vwEOAQAAAAAAAA4BAAAAAAAAgAIAADoAAADBBgAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADVBl cmwgdnMgU1FSIEJlbmNobWFya2luZw0NUGVybCB2ZXJzaW9uIDUuNi4wIJYgcnVuIG9uIJFvc2Nh cpIgQUlYIDQuMw1TUVIgdmVyc2lvbnMgNC4wLjIgYW5kIDQuMy40IJYgcnVuIG9uIJFyYWZmaXNo kiBBSVggNC4zDQ1FbnJvbGxtZW50IHJlcG9ydCCWIHJhbiBmb3IgRlROIG51bWJlciAyNDMwMiAo NjAwIHJvd3MgaW4gU0VfQVVESVQgb3V0IG9mIDI4LDAwMCspLiAgT3JkZXJlZCBvbiBjbGllbnRf aWQsIGdyb3VwX2lkLCByZWNvcmRfbm8uICBSZXRyaWV2ZSBjbGllbnRfbmFtZSwgZ3JvdXBfbmFt ZSBvbiBicmVhay4gIFJldHJpZXZlIGVycm9yX2NvZGVfZGVzYyBhcyBuZWVkZWQuIA0NUmVzdWx0 IChpbiBzZWNvbmRzKQ1UcmlhbAdQZXJsB1NRUjQwMgdTUVI0MzQHBzEHNgc5BzkHBzIHNgc5BzgH BzMHNgcxMAcxMAcHNAc2BzkHOQcHNQc2BzEwBzEwBwc2BzYHOQcxMAcHNwc3BzEwBzkHBzgHNgcx MAcxMAcHOQc2BzEwBzEwBwcxMAc2BzkHOQcHDQ1CZW5jaG1hcmsgcmVwb3J0IDIgliByZXRyaWV2 ZSBhbGwgcm93cyBmcm9tIFNFX0FVRElUICgyOCwwMTkgcm93cykuICBObyBwcm9jZXNzaW5nIHdh cyBkb25lIGV4Y2VwdCB0byBpbmNyZW1lbnQgYSBjb3VudGVyLg0NUmVzdWx0IChpbiBtaW51dGVz IGFuZCBzZWNvbmRzKQ1UcmlhbAdQZXJsB1NRUjQzNAcHMQcxOjQzBzozNAcHMgcxOjQ1BzozNwcH MwcxOjMwBzozNgcHNAcxOjQyBzozNgcHNQcxOjQyBzozNwcHDQ1CZW5jaG1hcmsgcmVwb3J0IDMg liByZXRyaWV2ZSBhbGwgcm93cyAob25seSA0IGNvbHVtbnMpIGZyb20gQUREUkVTUyAoMTA0LDcz MyByb3dzKS4gIE5vIHByb2Nlc3Npbmcgd2FzIGRvbmUgZXhjZXB0IHRvIGluY3JlbWVudCBhIGNv dW50ZXIuDQ1SZXN1bHQgKGluIG1pbnV0ZXMgYW5kIHNlY29uZHMpDVRyaWFsB1BlcmwHU1FSNDM0 BwcxBzQ6MjgHMToyOAcHMgc0OjE5BzE6MjQHBzMHNDoyNwcxOjIwBwc0BzQ6MjYHMToxMwcHNQc0 OjIyBzE6MjAHBw0NDQ0NQmVuY2htYXJrIHJlcG9ydCA0IJYgZmV0Y2ggMjAsMDAwIHJvd3MgKG9u bHkgNCBjb2x1bW5zKSBmcm9tIEFERFJFU1MuICBSdHJpbSBhZGRyZXNzX2xpbmVfMSBhbmQgYWRk cmVzc19saW5lXzIgYW5kIGNvbmNhdGVuYXRlIHRoZW0uICBQcmludCB0aGUgbmV3IHN0cmluZyB0 byBhIGZpbGUuDQ1SZXN1bHQgKGluIG1pbnV0ZXMgYW5kIHNlY29uZHMpDVRyaWFsB1BlcmwHU1FS NDM0BwcxBzE6NDcHMToxMwcHMgcxOjM3BzE6MTIHBzMHMjowMQcxOjMxBwc0BzE6MzIHMTozMAcH NQcxOjQ2BzE6MjAHBw0NQmVuY2htYXJrIHJlcG9ydCA1IJYgYXMgYWJvdmUgYnV0IHJldHJpZXZl IGFuZCBwcm9jZXNzIGFsbCAxMDQsNzMzIHJvd3MgZnJvbSBBRERSRVNTLg0NUmVzdWx0IChpbiBt aW51dGVzIGFuZCBzZWNvbmRzKQ1UcmlhbAdQZXJsB1NRUjQzNAcHMQc0OjQxBzQ6MTEHBzIHNToy Ngc0OjM4BwczBzU6MTAHNDo1NAcHNAc0OjQxBzQ6MTEHBzUHNDo0Nwc0OjIzBwcNDQ1Db21tZW50 cw1TUVIgc2VlbXMgbW9yZSBlZmZpY2llbnQgaW4gaW50ZXJmYWNpbmcgd2l0aCB0aGUgZGF0YWJh c2UuICBJbiBhIHN0cmFpZ2h0IHF1ZXJ5IHdpdGggbm8gcHJvY2Vzc2luZyBTUVIgdGFrZXMgb25s eSBhYm91dCAzNSUgb2YgdGhlIHRpbWUgdGhhdCB0aGUgcGVybCByZXBvcnQgdGFrZXMuICBBcyBl dmlkZW5jZWQgYnkgdGFibGVzIDQgYW5kIDUgdGhvdWdoIHRoZXJlIGlzIG11Y2ggbGVzcyBvdmVy aGVhZCBhc3NvY2lhdGVkIHdpdGggcHJvY2Vzc2luZyBvbmNlIHRoZSByb3dzIGFyZSByZXRyaWV2 ZWQgb24gUGVybJJzIHBhcnQgYW5kIHRoZSBhZHZhbnRhZ2UgdGhhdCBTUVIgZGlzcGxheWVkIGlu IHRhYmxlcyAyIGFuZCAzIGhhcyBiZWVuIG5hcnJvd2VkIHNpZ25pZmljYW50bHkuICBJIHdvdWxk IHRoaW5rIHRoYXQgYmFzZWQgb24gdGhlIHJlc3VsdHMgb2YgdGVzdJJzIDQgYW5kIDUgdGhhdCB0 aGUgbW9yZSBjb21wbGV4IChpLmUuIGluIHRlcm1zIG9mIGRhdGEgbWFuaXB1bGF0aW9uKSB0aGF0 IHRoZSByZXN1bHRzIHdvdWxkIHNrZXcgaW4gdGhlIGZhdm9yIG9mIFBlcmwuICANDVBsZWFzZSBu b3RlIHRoYXQgc29tZSBvZiB0aGUgd2lkZWx5IGRpdmVyZ2VudCB0aW1lcyBpbiBiZXR3ZWVuIHRy aWFscyBhcmUgZHVlIHRvIGhhdmluZyB0aGUgcmVwb3J0cyBvdmVybGFwIGFuZCBoaXR0aW5nIHRo ZSBzYW1lIGRhdGFiYXNlLiAgSSB0cmllZCB0byBjcmVhdGUgdHJpYWxzIHdoZXJlIHRoZSByZXBv cnRzIHdlcmUgZ2l2ZW4gc29sZSBhY2Nlc3MgdG8gdGhlIGRhdGFiYXNlLCByZXBvcnRzIHRoYXQg c3RhcnRlZCBhdCB0aGUgc2FtZSB0aW1lLCBhbmQgcmVwb3J0cyB0aGF0IG92ZXJsYXBwZWQgc3Rh cnQgdGltZXMuDQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAaBAAAGwQA AH8EAACABAAAUgUAAGcFAACBBQAAiQUAAIoFAACSBQAAkwUAAJ0FAACeBQAApgUAAKcFAACxBQAA sgUAALsFAAC8BQAAxQUAAMYFAADQBQAA0QUAANsFAADcBQAA5QUAAOgFAABjBgAAhAYAAJcGAADV BgAAYQcAAIIHAACVBwAA1gcAANcHAACBCAAAoggAALUIAAD2CAAA+AgAAE0JAABvCQAAggkAAMMJ AADGCQAALQ0AAC4NAAAA+/j79Pjw+PD48Pjw+PD48Pjw+PD48Pjw+PDt+PD47fjw+ADt+PD4AO34 8PgA+AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAARDShgAAAc1CIFDShwABzUIgUNKGAAEQ0ocAAAHNQiBQ0okAAAwAAQAAAEEAAAaBAAA GwQAAEcEAAB/BAAAgAQAAFIFAABTBQAAZwUAAG0FAAByBQAAeQUAAIAFAACBBQAAgwUAAIUFAACH BQAAiQUAAIoFAACMBQAAjgUAAJAFAACSBQAA/QAAAAAAAAAAAAAAAPsAAAAAAAAAAAAAAAD4AAAA AAAAAAAAAAAA/QAAAAAAAAAAAAAAAP0AAAAAAAAAAAAAAAD9AAAAAAAAAAAAAAAA8wAAAAAAAAAA AAAAAO8AAAAAAAAAAAAAAAD9AAAAAAAAAAAAAAAA6gAAAAAAAAAAAAAAAOoAAAAAAAAAAAAAAADq AAAAAAAAAAAAAAAA6gAAAAAAAAAAAAAAAM4kAAAAAAAAAAAAAADLAAAAAAAAAAAAAAAA6gAAAAAA AAAAAAAAAOoAAAAAAAAAAAAAAADqAAAAAAAAAAAAAAAAziQAAAAAAAAAAAAAAMsAAAAAAAAAAAAA AADqAAAAAAAAAAAAAAAA6gAAAAAAAAAAAAAAAOoAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAMAABYk AQAbAAAWJAEXJAEClmwABdYYBAEAAAQBAAAEAQAABAEAAAQBAAAEAQAACNYMAASU/yoDQAv8EhIb AAQAAAMkARYkAQADAAAPhGgBBQ8ACiYAC0YBAAMAAAMkAQABAQAAAQAAABcABAAAAQQAABoEAAAb BAAARwQAAH8EAACABAAAUgUAAFMFAABnBQAAbQUAAHIFAAB5BQAAgAUAAIEFAACDBQAAhQUAAIcF AACJBQAAigUAAIwFAACOBQAAkAUAAJIFAACTBQAAlQUAAJcFAACaBQAAnQUAAJ4FAACgBQAAogUA AKQFAACmBQAApwUAAKkFAACrBQAAAPz59vPw6ebj3tnUz8vGwby3s66ppJ+blpGMh4N+eXRva2Zh AAAAAAAAAAAAAAkDAQUKBlj+//8JAwEFCgZa/v//BwMBBlv+//8JAwEFCgZd/v//CQMBBQoGX/7/ /wkDAQUKBmH+//8JAwEFCgZj/v//BwMBB