From owner-sqr-users@list.iex.net Tue Jan 1 00:11:42 2002 Date: Tue, 1 Jan 2002 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.9 $ $Date: 2001-06-17 13:23:18-04 $ This document gathers in one location information about the sqr-users mail list. Directions for common list-server commands (including unsubscribing) are given, as are guidelines for list usage. ______________________________________________________________________ Table of Contents 1. Changes Since Previous Version 2. Introduction 2.1 sqr-users Mailing List 2.2 sqr-users Hints and Guidelines Document 2.3 Related Mailing Lists 3. Basic List Server Commands 3.1 Subscribing to the List 3.2 Unsubscribing from the List 3.3 Digests 3.4 Problems 4. Posting to the sqr-users List 4.1 General Guidelines 4.2 Posting a Message 4.3 Replying to a Message 5. Job Announcements ______________________________________________________________________ 1. Changes Since Previous Version Changes since the version dated 2001/01/26: o Announce new sqr-jobs mailing list; Job Announcements section updated to reflect this new list. 2. Introduction 2.1. sqr-users Mailing List The sqr-users mailing list was created to enable discussion related to the SQR database language from Brio Technology (and to other products in the Brio.Report line). Note: SQR used to be published by SQRIBE Technologies, which was merged into Brio Technology on August 3, 1999. The mailing list is provided as a service of Ray Ontko & Co. A searchable archive of past postings to the mailing list is available from the SQR Users Group web site . 2.2. sqr-users Hints and Guidelines Document This document gives various hints and guidelines about the sqr-users mailing list. It will be posted approximately monthly to the mailing list so that new users can see it (and existing users can find it easily). An HTML version of the document is always available at http://www.sqrug.com/sqr-users/sqr-users-hints.html. If you have comments or suggestions about this document, please contact me directly at the address listed in the title section. This document is Copyright (C) 1999-2001 by Ray Ontko & Co. It may be freely copied and distributed provided it is not modified in any way and it retains the original copyright notice. 2.3. Related Mailing Lists sqr-jobs : SQR Jobs This list may be used for posting SQR-related resumes, recruitments, job announcements, project announcments, help- wanted, work-wanted ads, etc. To join, follow the link above, or send any message to "sqr-jobs-subscribe@yahoogroups.com". peoplesoft-fans : PeopleSoft Fans Moderated list covering technical and functional aspects of PeopleSoft. To join, follow the link above, or send any message to "peoplesoft-fans-subscribe@yahoogroups.com". psusers : PeopleSoft Users For questions related to any aspect of PeopleSoft (including PeopleSoft-specific SQR issues). This list has merged with the Peoplesoft Fans mailing list and is no longer active, but the message achive can still be found at the link above. rm-users : ReportMart Users List for discussion of Brio.Portal (previously called ReportMart). To join, follow the link above, or send a message containing the word "subscribe" in the body to "rm-users- request@sqrug.com". 3. Basic List Server Commands Note: The list used to be hosted on usa.net , but the list-hosting service was moved to list.iex.net . The old addresses for the list, list server, and list owner no longer work. A few basic list server commands are listed below. Send these commands as the only line in the body (not the subject line) of an e- mail message sent to "listserv@list.iex.net". 3.1. Subscribing to the List To subscribe to the mailing list, the command is subscribe sqr-users Your Name Note that you do not need to provide your e-mail address as it is taken from your message's header. You will be e-mailed a confirmation number, which you must then send back to the list server software before the command goes into effect. 3.2. Unsubscribing from the List To unsubscribe, the command is simply unsubscribe sqr-users Once again, you will need to confirm your command before it goes into effect. 3.3. Digests Once you are subscribed, you can request to get your messages in digest form (one large message containing all of the posts made each day) by sending the command set sqr-users digests If you use digests you should not just "reply" to the digest mailing. Instead, be sure your message's subject header matches the subject in the original posting to which you are replying, and that you don't include a quoted copy of the entire digest in your post. Use "nodigests" instead of "digests" to restore normal distribution. 3.4. Problems If the above commands do not work, please contact the list manager at "sqr-users-request@list.iex.net". (Do not send a message to the list itself -- no one there can help you with your problem!) Please include a copy of the error message you received from the list server. 4. Posting to the sqr-users List In order to post to the mailing list, you must be subscribed to it (see directions above). 4.1. General Guidelines For any message you send to the list, please: o make sure your mail software is not requesting a "Return Receipt". (If a "Return Receipt Requested" message is sent to the list, several dozen receipt messages will be sent out to the mailing list in reply from other subscribers.) o do not send messages in HTML or other special formats. (These are not usable by many subscribers, especially those who receive their messages in digest format.) o keep in mind that over 500 people will receive your message, and that it will appear in the list archives. Try to keep your messages on-topic and relatively short. Consider sending your message directly to particular people if it won't interest many of the list's subscribers. 4.2. Posting a Message Once you are subscribed, you can post to the list by sending a message to "sqr-users@list.iex.net". Be sure your subject heading describes your specific problem or question (i.e. don't just use "SQR Question"). In the body of your message, please include the following information: o Brio product and version number o Operating system and version number o Database name and version number o Application name (i.e. PeopleSoft) and a version number, if any Also, include a short code sample whenever possible. It's much easier for other people to understand what you are trying to do when they can see the actual code. (At the same time, be careful not to post confidential or proprietary code, since the posting will be placed in a public web archive.) Note that your question should relate to SQR or other Brio Report product in some way. Don't ask questions about PeopleSoft, for example, unless you are having SQR-related issues. To find out your version of SQR, you can run the following program: begin-program show $sqr-ver end-program This will produce a line that looks something like this: SQR/3.0.15/Intel/SCO Unix R3.2 V5.0/Oracle 7.2.2.3/Sep 25 1996 Include the full line of output in your message. Note that the oper- ating system version number listed here is the one under which this copy of SQR was compiled, so you'll still need to include your own information. 4.3. Replying to a Message Messages sent out on the list have a Reply-To header pointing to the list. This means that you should be able to simply use your mail reader's "reply" function to send a reply to the list. Generally, all answers to questions sent out on the list should be public replies, so that other subscribers can benefit. In those cases where a private reply is appropriate, be sure to over-ride the default Reply-To address. If your message is not actually a reply to the earlier message, please do not use the "reply" function. Instead, address a new e-mail message to the list as described in the previous section. (This is because the list archives will incorrectly show the new message in the original thread if you use "reply".) You should quote enough lines from the original message that later readers can understand your answer even if they missed the original question. At the same time, you should remove any unnecessary lines from the quote in order to make your message shorter and easier to understand. (Remember that some people read the mailing list in digest form, and the digests become much larger if unnecessary lines are quoted.) In particular, in order to prevent mail loops, the list server will not accept messages that contain From:, Sender:, etc. lines pointing back to the sqr-users list, even if these lines are quoted (i.e. with ">" characters). Be sure to delete these from your reply message before sending it. 5. Job Announcements Please do not post job announcements on the sqr-users list, but use the sqr-jobs list instead. (See ``Related Mailing Lists'' for more information on this list.) A large number of sqr-users subscribers do not want to receive job announcements (for various reasons) and such posts tend to cause a lot of disruption of the discussion on the list. From owner-sqr-users@list.iex.net Tue Jan 1 23:51:56 2002 Date: Wed, 2 Jan 2002 10:24:17 +0530 From: Satyen Timbadia Subject: Brio ReportBuilder Hi Friends, I need to download a trial copy of Brio ReportBuilder. Can anybody suggest a website or any authorised reseller in Mumbai, India. Thanks & Regards, Satyen Timbadia Voice : 778 1006/8/9 - Ext: 3023 Email : satyen.timbadia@patni.com From owner-sqr-users@list.iex.net Wed Jan 2 07:28:16 2002 Date: Wed, 2 Jan 2002 07:00:28 -0500 From: "Robinson, Celeste" Subject: set sqr-users digests set sqr-users digests Celeste Hunter Robinson Programmer/Analyst -----Original Message----- From: Nathan Stratton Treadway [mailto:nathant@ONTKO.COM] Sent: Tuesday, January 01, 2002 12:00 AM To: SQR-USERS@list.iex.net Subject: Monthly sqr-users Hints Posting sqr-users Mailing List Hints and Guidelines Nathan Stratton Treadway, Ray Ontko & Co. (nathant@ontko.com) $Revision: 1.9 $ $Date: 2001-06-17 13:23:18-04 $ This document gathers in one location information about the sqr-users mail list. Directions for common list-server commands (including unsubscribing) are given, as are guidelines for list usage. ______________________________________________________________________ Table of Contents 1. Changes Since Previous Version 2. Introduction 2.1 sqr-users Mailing List 2.2 sqr-users Hints and Guidelines Document 2.3 Related Mailing Lists 3. Basic List Server Commands 3.1 Subscribing to the List 3.2 Unsubscribing from the List 3.3 Digests 3.4 Problems 4. Posting to the sqr-users List 4.1 General Guidelines 4.2 Posting a Message 4.3 Replying to a Message 5. Job Announcements ______________________________________________________________________ 1. Changes Since Previous Version Changes since the version dated 2001/01/26: o Announce new sqr-jobs mailing list; Job Announcements section updated to reflect this new list. 2. Introduction 2.1. sqr-users Mailing List The sqr-users mailing list was created to enable discussion related to the SQR database language from Brio Technology (and to other products in the Brio.Report line). Note: SQR used to be published by SQRIBE Technologies, which was merged into Brio Technology on August 3, 1999. The mailing list is provided as a service of Ray Ontko & Co. A searchable archive of past postings to the mailing list is available from the SQR Users Group web site . 2.2. sqr-users Hints and Guidelines Document This document gives various hints and guidelines about the sqr-users mailing list. It will be posted approximately monthly to the mailing list so that new users can see it (and existing users can find it easily). An HTML version of the document is always available at http://www.sqrug.com/sqr-users/sqr-users-hints.html. If you have comments or suggestions about this document, please contact me directly at the address listed in the title section. This document is Copyright (C) 1999-2001 by Ray Ontko & Co. It may be freely copied and distributed provided it is not modified in any way and it retains the original copyright notice. 2.3. Related Mailing Lists sqr-jobs : SQR Jobs This list may be used for posting SQR-related resumes, recruitments, job announcements, project announcments, help- wanted, work-wanted ads, etc. To join, follow the link above, or send any message to "sqr-jobs-subscribe@yahoogroups.com". peoplesoft-fans : PeopleSoft Fans Moderated list covering technical and functional aspects of PeopleSoft. To join, follow the link above, or send any message to "peoplesoft-fans-subscribe@yahoogroups.com". psusers : PeopleSoft Users For questions related to any aspect of PeopleSoft (including PeopleSoft-specific SQR issues). This list has merged with the Peoplesoft Fans mailing list and is no longer active, but the message achive can still be found at the link above. rm-users : ReportMart Users List for discussion of Brio.Portal (previously called ReportMart). To join, follow the link above, or send a message containing the word "subscribe" in the body to "rm-users- request@sqrug.com". 3. Basic List Server Commands Note: The list used to be hosted on usa.net , but the list-hosting service was moved to list.iex.net . The old addresses for the list, list server, and list owner no longer work. A few basic list server commands are listed below. Send these commands as the only line in the body (not the subject line) of an e- mail message sent to "listserv@list.iex.net". 3.1. Subscribing to the List To subscribe to the mailing list, the command is subscribe sqr-users Your Name Note that you do not need to provide your e-mail address as it is taken from your message's header. You will be e-mailed a confirmation number, which you must then send back to the list server software before the command goes into effect. 3.2. Unsubscribing from the List To unsubscribe, the command is simply unsubscribe sqr-users Once again, you will need to confirm your command before it goes into effect. 3.3. Digests Once you are subscribed, you can request to get your messages in digest form (one large message containing all of the posts made each day) by sending the command set sqr-users digests If you use digests you should not just "reply" to the digest mailing. Instead, be sure your message's subject header matches the subject in the original posting to which you are replying, and that you don't include a quoted copy of the entire digest in your post. Use "nodigests" instead of "digests" to restore normal distribution. 3.4. Problems If the above commands do not work, please contact the list manager at "sqr-users-request@list.iex.net". (Do not send a message to the list itself -- no one there can help you with your problem!) Please include a copy of the error message you received from the list server. 4. Posting to the sqr-users List In order to post to the mailing list, you must be subscribed to it (see directions above). 4.1. General Guidelines For any message you send to the list, please: o make sure your mail software is not requesting a "Return Receipt". (If a "Return Receipt Requested" message is sent to the list, several dozen receipt messages will be sent out to the mailing list in reply from other subscribers.) o do not send messages in HTML or other special formats. (These are not usable by many subscribers, especially those who receive their messages in digest format.) o keep in mind that over 500 people will receive your message, and that it will appear in the list archives. Try to keep your messages on-topic and relatively short. Consider sending your message directly to particular people if it won't interest many of the list's subscribers. 4.2. Posting a Message Once you are subscribed, you can post to the list by sending a message to "sqr-users@list.iex.net". Be sure your subject heading describes your specific problem or question (i.e. don't just use "SQR Question"). In the body of your message, please include the following information: o Brio product and version number o Operating system and version number o Database name and version number o Application name (i.e. PeopleSoft) and a version number, if any Also, include a short code sample whenever possible. It's much easier for other people to understand what you are trying to do when they can see the actual code. (At the same time, be careful not to post confidential or proprietary code, since the posting will be placed in a public web archive.) Note that your question should relate to SQR or other Brio Report product in some way. Don't ask questions about PeopleSoft, for example, unless you are having SQR-related issues. To find out your version of SQR, you can run the following program: begin-program show $sqr-ver end-program This will produce a line that looks something like this: SQR/3.0.15/Intel/SCO Unix R3.2 V5.0/Oracle 7.2.2.3/Sep 25 1996 Include the full line of output in your message. Note that the oper- ating system version number listed here is the one under which this copy of SQR was compiled, so you'll still need to include your own information. 4.3. Replying to a Message Messages sent out on the list have a Reply-To header pointing to the list. This means that you should be able to simply use your mail reader's "reply" function to send a reply to the list. Generally, all answers to questions sent out on the list should be public replies, so that other subscribers can benefit. In those cases where a private reply is appropriate, be sure to over-ride the default Reply-To address. If your message is not actually a reply to the earlier message, please do not use the "reply" function. Instead, address a new e-mail message to the list as described in the previous section. (This is because the list archives will incorrectly show the new message in the original thread if you use "reply".) You should quote enough lines from the original message that later readers can understand your answer even if they missed the original question. At the same time, you should remove any unnecessary lines from the quote in order to make your message shorter and easier to understand. (Remember that some people read the mailing list in digest form, and the digests become much larger if unnecessary lines are quoted.) In particular, in order to prevent mail loops, the list server will not accept messages that contain From:, Sender:, etc. lines pointing back to the sqr-users list, even if these lines are quoted (i.e. with ">" characters). Be sure to delete these from your reply message before sending it. 5. Job Announcements Please do not post job announcements on the sqr-users list, but use the sqr-jobs list instead. (See ``Related Mailing Lists'' for more information on this list.) A large number of sqr-users subscribers do not want to receive job announcements (for various reasons) and such posts tend to cause a lot of disruption of the discussion on the list. ==================== This email/fax message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this email/fax is prohibited. If you are not the intended recipient, please contact the sender by email/fax and destroy all paper and electronic copies of the original message. From owner-sqr-users@list.iex.net Wed Jan 2 07:28:56 2002 Date: Wed, 2 Jan 2002 07:04:08 -0500 From: "Robinson, Celeste" Subject: Recall: set sqr-users digests Robinson, Celeste would like to recall the message, "set sqr-users digests". ==================== This email/fax message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this email/fax is prohibited. If you are not the intended recipient, please contact the sender by email/fax and destroy all paper and electronic copies of the original message. From owner-sqr-users@list.iex.net Wed Jan 2 09:58:34 2002 Date: Wed, 2 Jan 2002 09:50:36 -0500 From: Denise White Subject: Re: SQL expression not ended, perhaps missing &name Hi Kim, As someone else mentioned (wording it a little differently), within a BEGIN-SELECT, you need to indent all SQR code. In other words, you should begin the columns being selected, the FROM clause, and I think the WHERE clause in the first column of your program, but all the code between the columns and the FROM should be indented. This is definitely the problem you are having, as the two messages indicate the two BEGIN-SELECTs where the SQR code is not indented. I didn't closely examine all your code, but I also see another problem. In the Select-Prod-Client procedure (after first indenting that if statement!), 'if pc.gl_pay_type' should be 'if &pc.gl_pay_type'. You need the ampersand (&) to reference the selected column. Actually, there is really no point in including the aliases (&pc.gl_pay_type, &pc.position_nbr) next to the columns being selected, as those are the exact same names you get anyway, without explicitly declaring the aliases. In addition, your date processing is not going to work. You are moving date columns to the string variables $action_dt and $max_jo_term, and then trying to use these string variables as dates. You could declare these variables as date variables, but I am not sure exactly what format SQR will put them into - it may not be the Oracle native format that you are using in "if $action_dt => '01-Jan-2002'". I usually like to control the exact format myself for a compare (in a compare, if you set up the string in the right format, you don't need to declare the variable as date), so I would probably "select to_char(job.action_dt,'yyyymmdd') &action_dt" and then compare &action_dt to '20020101'. Finding the difference between $action_dt and $max_jo_term would probably require declaring two date variables and then doing the datediff SQR date function. HTH, Denise White Sr. Programmer/Analyst Vicor ------------------------------ Date: Mon, 24 Dec 2001 09:21:23 -0600 From: Kim Little Subject: Re: SQL expression not ended, perhaps missing &name Thanks Steve, but that didn't work either, I still keep getting the error in the following areas: SQL expression not ended, perhaps missing &name. from ps_bas_activity bas and SQL expression not ended, perhaps missing &name. from ps_job_pc. The problem is I did not write this someone else did and with no documentation to follow up on, and this sqr has so many ineligible variables. :-( Stephen Keen @list.iex.net> on 12/25/2001 08:57:30 AM Please respond to sqr-users@list.iex.net Sent by: "Discussion of SQR, Brio Software's database reporting language" To: SQR-USERS@list.iex.net cc: Subject: Re: SQL expression not ended, perhaps missing &name Hey I think the error is in the 'Begin-Procedure Select-Cust-Exists' area. What exactly are you selecting there? From what I see an 'x' Comment the calling area and see if it works Steve Merry Christmas -----Original Message----- From: Discussion of SQR, Brio Software's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Kim Little Sent: Monday, December 24, 2001 9:33 AM To: SQR-USERS@list.iex.net Subject: SQL expression not ended, perhaps missing &name Importance: High Can anyone help I am getting the following error, when trying to run this SQR. #Include 'setenv.sqc' !********************************** Begin-Program !********************************** do Init-Report display 'Report Begin at: ' noline do display-time do Process-Main display 'Report Ended at: ' noline do display-time do Reset do StdAPI-Term End-Program !********************************** Begin-Procedure Init-Report !********************************** do Init-DateTime do Get-Current-DateTime do Init-Number do StdAPI-Init let $ReportID = 'ARC_TCELG' do Get-Report-Language let $ReportTitle = $ARC_TCELG-REPORTTITLE display $ReportID NoLine display ': ' NoLine display $ReportTitle display '' if $prcs_process_instance = '' do Ask-Values else do Get-Values end-if End-Procedure Init-Report !********************************** Begin-Procedure Process-Main !********************************** Begin-SELECT bas.Emplid &bas.Emplid move &bas.Emplid to $Emplid1 move 'N' to $SelectExists do Select-Hire-Date if $action_dt => '01-Jan-2002' do Select-Prod-Client else do Select-Term-Row if ($action_dt - $max_jo_term) > 90 do Select-Prod-Client else if $reg_temp1 = 'T' do Select-Prod-Client end-if end-if end-if from ps_bas_activity bas end-select end-procedure Process-Main !********************************** Begin-Procedure Select-Hire-Date !********************************** begin-select job.action_dt move &job.action_dt to $action_dt from ps_job job where job.emplid = $Emplid1 and job.empl_type not in ('E','S') and job.action = 'HIR' end-select end-procedure Select-Hire-Date !********************************** Begin-Procedure Select-Prod-Client !********************************** Begin-select pc.gl_pay_type &pc.gl_pay_type pc.position_nbr &pc.position_nbr if pc.gl_pay_type between '1000' and '1099' do Update-Reg-Temp else do Select-Client-ID if $SelectExists = 'Y' do Select-Cust-Eff-Status if $eff_status1 = 'A' do Update-Reg-Temp end-if end-if end-if from ps_job pc where pc.emplid = $Emplid1 and pc.effdt = (select max(pc_ed.effdt) from ps_job pc_ed where pc.emplid = pc_ed.emplid and pc.empl_rcd# = pc_ed.empl_rcd#) and pc.effseq = (select max(pc_es.effseq) from ps_job pc_es where pc.emplid = pc_es.emplid) end-select end-procedure Select-Prod-Client !********************************** Begin-Procedure Update-Reg-Temp !********************************** begin-sql update ps_job rt set rt.reg_temp = 'T' where rt.emplid = $Emplid1 and rt.effdt = (select max(rt_ed.effdt) from ps_job rt_ed where rt.emplid = rt_ed.emplid and rt.empl_rcd# = rt_ed.empl_rcd#) and rt.effseq = (select max(rt_es.effseq) from ps_job rt_es where rt.emplid = rt_es.emplid) end-sql end-procedure Update-Reg-Temp !********************************** Begin-Procedure Select-Client-ID !********************************** begin-select client.ps_client_id &client.ps_client_id do Select-Cust-Exists from client@asys client, job_order@asys jo where client.client = jo.client and jo.job_order = &pc.position_nbr end-select end-procedure Select-Client-ID !********************************** Begin-Procedure Select-Cust-Exists !********************************** begin-select 'X' Move 'Y' to #SelectExists from ps_arc_cust_vw cust_vw where cust_vw.setid = 'SHARE' and cust_vw.cust_id = &client.ps_client_id end-select end-procedure Select-Cust-Exists !********************************** Begin-Procedure Select-Cust-Eff-Status !********************************** begin-select noelig.eff_status move &noelig.eff_status to $eff_status1 from ps_arc_noelig_cust noelig where noelig.setid = 'SHARE' and noelig.cust_id = &client.ps_client_id and noelig.EFFDT = (SELECT MAX(noelig_ED.EFFDT) FROM PS_ARC_NOELIG_CUST noelig_ed WHERE noelig.setid = noelig_ed.setid AND noelig.cust_id = noelig_ed.cust_id AND noelig_ED.EFFDT <= SYSDATE) end-select end-procedure Select-Cust-Eff-Status !********************************** Begin-Procedure Select-Term-Row !********************************** begin-select max(jo_term.action_dt) &max_jo_term move &max_jo_term to $max_jo_term do Select-Reg-Temp from ps_job jo_term where jo_term.emplid = $Emplid1 and jo_term.action = 'TER' end-select end-procedure Select-Term-Row !********************************** Begin-Procedure Select-Reg-Temp !********************************** begin-select jo_rt.reg_temp move &jo_rt.reg_temp to $reg_temp1 from ps_job jo_rt where jo_rt.emplid = $Emplid1 and jo_rt.action = 'TER' and jo_rt.action_dt = $max_jo_term end-select end-procedure Select-Reg-Temp !*********************************** #include 'prcsapi.sqc' !Update Process Request API #include 'prcsdef.sqc' !Update Process Request variable declaration #Include 'curdttim.sqc' ! Get-Current-DateTime procedure #Include 'datetime.sqc' ! Routines for date and time formatting #Include 'datemath.sqc' ! Routines for date and time formatting #Include 'number.sqc' ! Routines to format numbers #Include 'stdapi.sqc' ! Update Process API From owner-sqr-users@list.iex.net Wed Jan 2 10:29:39 2002 Date: Wed, 2 Jan 2002 09:23:19 -0600 From: Bob Helm Subject: anyone heard of "MITI SQR"? A document I've come across makes mention using "MITI SQR 3". I thought BRIO has SQR and before that it was Sqribe. Has anyone heard of this and what is MITI? Thanks for any info. B The Programmer formerly known as Bob Mediware Information Systems Inc. (913) 307-1045 Bob.Helm@Mediware.com From owner-sqr-users@list.iex.net Wed Jan 2 10:47:26 2002 Date: Wed, 2 Jan 2002 10:41:45 -0500 From: Jeff Davis Subject: Re: anyone heard of "MITI SQR"? MITI is the company that owned SQR (version 3.0) prior to Sqribe. The MITI company may be out of business... I couldn't get to their web site: miti.com. Bob Helm @list.iex.net> on 01/02/2002 10:23:19 AM Please respond to sqr-users@list.iex.net Sent by: "Discussion of SQR, Brio Software's database reporting language" To: SQR-USERS@list.iex.net cc: Subject: anyone heard of "MITI SQR"? A document I've come across makes mention using "MITI SQR 3". I thought BRIO has SQR and before that it was Sqribe. Has anyone heard of this and what is MITI? Thanks for any info. B The Programmer formerly known as Bob Mediware Information Systems Inc. (913) 307-1045 Bob.Helm@Mediware.com From owner-sqr-users@list.iex.net Wed Jan 2 11:03:04 2002 Date: Wed, 2 Jan 2002 09:56:12 -0600 From: Bob Helm Subject: Re: anyone heard of "MITI SQR"? Nevermind...I found that SQRIBE was formerly known as MITI which bought SQR from Sybase in 1996. BRIO subsequently bought SQRIBE and SQR in August of 1999. Thanks anyway for any responses I haven't seen yet. B The Programmer formerly known as Bob Mediware Information Systems Inc. (913) 307-1045 Bob.Helm@Mediware.com This message has been sent using 100% recycled electrons. -----Original Message----- From: Bob Helm [mailto:Bob.Helm@MEDIWARE.COM] Sent: Wednesday, January 02, 2002 9:23 AM To: SQR-USERS@list.iex.net Subject: anyone heard of "MITI SQR"? A document I've come across makes mention using "MITI SQR 3". I thought BRIO has SQR and before that it was Sqribe. Has anyone heard of this and what is MITI? Thanks for any info. B The Programmer formerly known as Bob Mediware Information Systems Inc. (913) 307-1045 Bob.Helm@Mediware.com From owner-sqr-users@list.iex.net Wed Jan 2 11:08:59 2002 Date: Wed, 2 Jan 2002 09:52:25 -0600 From: Betty Thompson Subject: Re: anyone heard of "MITI SQR"? How cute! --- pronounced like 'mighty', right? Please let me know what you learn. Thanks, Betty -----Original Message----- From: Discussion of SQR, Brio Software's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Bob Helm Sent: Wednesday, January 02, 2002 9:23 AM To: SQR-USERS@list.iex.net Subject: anyone heard of "MITI SQR"? A document I've come across makes mention using "MITI SQR 3". I thought BRIO has SQR and before that it was Sqribe. Has anyone heard of this and what is MITI? Thanks for any info. B The Programmer formerly known as Bob Mediware Information Systems Inc. (913) 307-1045 Bob.Helm@Mediware.com From owner-sqr-users@list.iex.net Wed Jan 2 11:16:02 2002 Date: Wed, 2 Jan 2002 11:09:50 -0500 From: Don Mellen Subject: Re: anyone heard of "MITI SQR"? On Wed, 2 Jan 2002, Bob Helm wrote: > A document I've come across makes mention using "MITI SQR 3". > I thought BRIO has SQR and before that it was Sqribe. and before SQRibe, it was MITI. ----------------------------------------------------------------------- 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 Wed Jan 2 11:20:22 2002 Date: Wed, 2 Jan 2002 11:14:15 -0500 From: Ray Ontko Subject: Re: anyone heard of "MITI SQR"? B, The Programmer formerly known as Bob, Sqribe is the software company formerly known as MITI. Ray [Charset iso-8859-1 unsupported, filtering to ASCII...] > A document I've come across makes mention using "MITI SQR 3". > I thought BRIO has SQR and before that it was Sqribe. > > Has anyone heard of this and what is MITI? > > Thanks for any info. > > B > The Programmer formerly known as Bob > Mediware Information Systems Inc. > (913) 307-1045 > Bob.Helm@Mediware.com > ---------------------------------------------------------------------- Ray Ontko rayo@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ From owner-sqr-users@list.iex.net Wed Jan 2 11:23:13 2002 Date: Wed, 2 Jan 2002 16:10:43 +0000 From: "Paul O'Riordan" Subject: Re: anyone heard of "MITI SQR"? --0__=80256B350058D1278f9e8a93df938690918c80256B350058D127 Content-type: text/plain; charset=us-ascii And just as a bye the way - I believe that PeopleSoft have now bought SQR Regards Paul Bob Helm @list.iex.net> on 02/01/2002 15:56:12 Please respond to sqr-users@list.iex.net Sent by: "Discussion of SQR, Brio Software's database reporting language" To: SQR-USERS@list.iex.net cc: Subject: Re: anyone heard of "MITI SQR"? Nevermind...I found that SQRIBE was formerly known as MITI which bought SQR from Sybase in 1996. BRIO subsequently bought SQRIBE and SQR in August of 1999. Thanks anyway for any responses I haven't seen yet. B The Programmer formerly known as Bob Mediware Information Systems Inc. (913) 307-1045 Bob.Helm@Mediware.com This message has been sent using 100% recycled electrons. -----Original Message----- From: Bob Helm [mailto:Bob.Helm@MEDIWARE.COM] Sent: Wednesday, January 02, 2002 9:23 AM To: SQR-USERS@list.iex.net Subject: anyone heard of "MITI SQR"? A document I've come across makes mention using "MITI SQR 3". I thought BRIO has SQR and before that it was Sqribe. Has anyone heard of this and what is MITI? Thanks for any info. B The Programmer formerly known as Bob Mediware Information Systems Inc. (913) 307-1045 Bob.Helm@Mediware.com --0__=80256B350058D1278f9e8a93df938690918c80256B350058D127 Content-type: application/octet-stream; name="$RFC822.eml" Content-Disposition: attachment; filename="$RFC822.eml" Content-transfer-encoding: base64 UmVjZWl2ZWQ6IGZyb20gYXZlcnktY3AubWdhYS5hdmVyeWRlbm5pc29uLmNvbSAoWzE0NC45My4x MjUuMTJdKQ0KICAgICAgICAgIGJ5IHNtdHAtMjAtY29uLmF2ZXJ5ZGVubmlzb24uY29tIChMb3R1 cyBEb21pbm8gUmVsZWFzZSA1LjAuOCkNCiAgICAgICAgICB3aXRoIFNNVFAgaWQgMjAwMjAxMDIx MTAwNTk3NTo4MTc1ODMgOw0KICAgICAgICAgIFdlZCwgMiBKYW4gMjAwMiAxMTowMDo1OSAtMDUw MCANClJlY2VpdmVkOiBmcm9tIGxpc3QuaWV4Lm5ldCAobGlzdC5pZXgubmV0IFsxOTIuMTU2LjE5 Ni4xNV0pDQoJYnkgbGlzdC5pZXgubmV0ICg4LjExLjEvOC4xMS4xKSB3aXRoIEVTTVRQIGlkIGcw MkZqbjgwODQwMDsNCglXZWQsIDIgSmFuIDIwMDIgMDg6NDU6NTAgLTA3MDAgKE1TVCkNClJlY2Vp dmVkOiBmcm9tIExJU1QuSUVYLk5FVCBieSBMSVNULklFWC5ORVQgKExJU1RTRVJWLVRDUC9JUCBy ZWxlYXNlIDEuOGQpIHdpdGgNCiAgICAgICAgICBzcG9vbCBpZCA3NjE5NDcgZm9yIFNRUi1VU0VS U0BMSVNULklFWC5ORVQ7IFdlZCwgMiBKYW4gMjAwMiAwODo0NTo0OA0KICAgICAgICAgIC0wNzAw DQpSZWNlaXZlZDogZnJvbSBrY214czEucngubWVkdy5uZXQgKG14cy5tZWRpd2FyZS5jb20gWzYz LjY3LjYxLjI1XSkgYnkNCiAgICAgICAgICBsaXN0LmlleC5uZXQgKDguMTEuMS84LjExLjEpIHdp dGggRVNNVFAgaWQgZzAyRmpsODA4MzkzIGZvcg0KICAgICAgICAgIDxzcXItdXNlcnNAbGlzdC5p ZXgubmV0PjsgV2VkLCAyIEphbiAyMDAyIDA4OjQ1OjQ4IC0wNzAwIChNU1QpDQpSZWNlaXZlZDog Ynkga2NteHMxIHdpdGggSW50ZXJuZXQgTWFpbCBTZXJ2aWNlICg1LjUuMjY1My4xOSkgaWQgPFc0 S0c4ODJDPjsNCiAgICAgICAgICBXZWQsIDIgSmFuIDIwMDIgMDk6NTY6MzkgLTA2MDANCk1JTUUt VmVyc2lvbjogMS4wDQpYLU1haWxlcjogSW50ZXJuZXQgTWFpbCBTZXJ2aWNlICg1LjUuMjY1My4x OSkNCk1lc3NhZ2UtSUQ6ICA8NjEyRDQwODYzQ0FFRDMxMTlCM0UwMDA4Qzc5RjJEREUwMTZFNzQ3 RkBrY214czE+DQpEYXRlOiAgICAgICAgIFdlZCwgMiBKYW4gMjAwMiAwOTo1NjoxMiAtMDYwMA0K UmVwbHktVG86IHNxci11c2Vyc0BsaXN0LmlleC5uZXQNClNlbmRlcjogIkRpc2N1c3Npb24gb2Yg U1FSLCBCcmlvIFNvZnR3YXJlJ3MgZGF0YWJhc2UgcmVwb3J0aW5nIGxhbmd1YWdlIiANCiAgICAg ICAgICAgICAgPFNRUi1VU0VSU0BsaXN0LmlleC5uZXQ+DQpGcm9tOiBCb2IgSGVsbSA8Qm9iLkhl bG1ATUVESVdBUkUuQ09NPg0KU3ViamVjdDogICAgICBSZTogYW55b25lIGhlYXJkIG9mICJNSVRJ IFNRUiI/DQpUbzogU1FSLVVTRVJTQGxpc3QuaWV4Lm5ldA0KWC1NSU1FVHJhY2s6IEl0ZW1pemUg YnkgU01UUCBTZXJ2ZXIgb24gU01UUC0yMC1DT04vTkEvQXZlcnlEZW5uaXNvbihSZWxlYXNlIDUu MC44IHxKdW5lDQogMTgsIDIwMDEpIGF0IDAxLzAyLzIwMDIgMTE6MDA6NTkgQU0sDQoJU2VyaWFs aXplIGJ5IFJvdXRlciBvbiBTTVRQLTIwLUNPTi9OQS9BdmVyeURlbm5pc29uKFJlbGVhc2UgNS4w LjggfEp1bmUgMTgsIDIwMDEpIGF0DQogMDEvMDIvMjAwMiAxMTowMTowMiBBTSwNCglTZXJpYWxp emUgY29tcGxldGUgYXQgMDEvMDIvMjAwMiAxMTowMTowMiBBTQ0KWC1Ob3Rlcy1JdGVtOiAyMDsN CiB0eXBlPTMwMDsgbmFtZT0kSG9wcw0KWC1Ob3Rlcy1JdGVtOiBNZW1vOw0KIG5hbWU9Rm9ybQ0K WC1Ob3Rlcy1JdGVtOiAsDQoJQ049U01UUC0yMC1DT04vT1U9TkEvTz1BdmVyeURlbm5pc29uOw0K IHR5cGU9NTAxOyBmbGFncz00NDsgbmFtZT0kVXBkYXRlZEJ5DQpYLU5vdGVzLUl0ZW06ICQkJFN0 b3BFTUhBTkQ7DQogbmFtZT0kJCRTdG9wRU1IQU5ETEVSDQpDb250ZW50LVR5cGU6IHRleHQvcGxh aW47IGNoYXJzZXQ9Imlzby04ODU5LTEiDQoNCk5ldmVybWluZC4uLkkgZm91bmQgdGhhdCBTUVJJ QkUgd2FzIGZvcm1lcmx5IGtub3duIGFzIE1JVEkgd2hpY2ggYm91Z2h0IFNRUg0KZnJvbSBTeWJh c2UgaW4gMTk5Ni4NCkJSSU8gc3Vic2VxdWVudGx5IGJvdWdodCBTUVJJQkUgYW5kIFNRUiBpbiBB dWd1c3Qgb2YgMTk5OS4NCg0KVGhhbmtzIGFueXdheSBmb3IgYW55IHJlc3BvbnNlcyBJIGhhdmVu J3Qgc2VlbiB5ZXQuDQoNCkINClRoZSBQcm9ncmFtbWVyIGZvcm1lcmx5IGtub3duIGFzIEJvYg0K TWVkaXdhcmUgSW5mb3JtYXRpb24gU3lzdGVtcyBJbmMuDQooOTEzKSAzMDctMTA0NQ0KQm9iLkhl bG1ATWVkaXdhcmUuY29tIDxtYWlsdG86Qm9iLkhlbG1ATWVkaXdhcmUuY29tPg0KDQpUaGlzIG1l c3NhZ2UgaGFzIGJlZW4gc2VudCB1c2luZyAxMDAlIHJlY3ljbGVkIGVsZWN0cm9ucy4NCg0KDQoN Cg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IEJvYiBIZWxtIFttYWlsdG86Qm9i LkhlbG1ATUVESVdBUkUuQ09NXQ0KU2VudDogV2VkbmVzZGF5LCBKYW51YXJ5IDAyLCAyMDAyIDk6 MjMgQU0NClRvOiBTUVItVVNFUlNAbGlzdC5pZXgubmV0DQpTdWJqZWN0OiBhbnlvbmUgaGVhcmQg b2YgIk1JVEkgU1FSIj8NCg0KDQpBIGRvY3VtZW50IEkndmUgY29tZSBhY3Jvc3MgbWFrZXMgbWVu dGlvbiB1c2luZyAiTUlUSSBTUVIgMyIuDQpJIHRob3VnaHQgQlJJTyBoYXMgU1FSIGFuZCBiZWZv cmUgdGhhdCBpdCB3YXMgU3FyaWJlLg0KDQpIYXMgYW55b25lIGhlYXJkIG9mIHRoaXMgYW5kIHdo YXQgaXMgTUlUST8NCg0KVGhhbmtzIGZvciBhbnkgaW5mby4NCg0KQg0KVGhlIFByb2dyYW1tZXIg Zm9ybWVybHkga25vd24gYXMgQm9iDQpNZWRpd2FyZSBJbmZvcm1hdGlvbiBTeXN0ZW1zIEluYy4N Cig5MTMpIDMwNy0xMDQ1DQpCb2IuSGVsbUBNZWRpd2FyZS5jb20NCg== --0__=80256B350058D1278f9e8a93df938690918c80256B350058D127-- From owner-sqr-users@list.iex.net Wed Jan 2 11:38:05 2002 Date: Wed, 2 Jan 2002 11:31:41 -0500 From: Don Mellen Subject: Re: anyone heard of "MITI SQR"? On Wed, 2 Jan 2002, Jeff Davis wrote: > MITI is the company that owned SQR (version 3.0) prior to Sqribe. > The MITI company may be out of business... I couldn't get to their web > site: miti.com. Miti changed their name to Sqribe, then Sqribe merged with Brio. ----------------------------------------------------------------------- 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 Wed Jan 2 11:40:33 2002 Date: Wed, 2 Jan 2002 11:31:21 -0500 From: "Williams, Wes HS-SNS" Subject: Re: anyone heard of "MITI SQR"? I believe it was MITI back in 1992 and earlier. Many changes since then. Wes Williams System Analyst, Developer Hamilton Sundstrand 815.226.6196 -----Original Message----- From: Bob Helm [mailto:Bob.Helm@MEDIWARE.COM] Sent: Wednesday, January 02, 2002 9:23 AM To: SQR-USERS@list.iex.net Subject: anyone heard of "MITI SQR"? A document I've come across makes mention using "MITI SQR 3". I thought BRIO has SQR and before that it was Sqribe. Has anyone heard of this and what is MITI? Thanks for any info. B The Programmer formerly known as Bob Mediware Information Systems Inc. (913) 307-1045 Bob.Helm@Mediware.com From owner-sqr-users@list.iex.net Wed Jan 2 11:58:43 2002 Date: Wed, 2 Jan 2002 10:41:12 -0600 From: James Womeldorf Subject: Re: anyone heard of "MITI SQR"? FYI Our virus software seems to have found a virus in Paul's email. Jim Womeldorf Programmer/Analyst Fastenal Company jwomeldo@fastenal.com (507) 453-8250 -----Original Message----- From: Paul O'Riordan [mailto:Paul_O'Riordan@AVERYDENNISON.COM] Sent: Wednesday, January 02, 2002 10:11 AM To: SQR-USERS@list.iex.net Subject: Re: anyone heard of "MITI SQR"? And just as a bye the way - I believe that PeopleSoft have now bought SQR Regards Paul Bob Helm @list.iex.net> on 02/01/2002 15:56:12 Please respond to sqr-users@list.iex.net Sent by: "Discussion of SQR, Brio Software's database reporting language" To: SQR-USERS@list.iex.net cc: Subject: Re: anyone heard of "MITI SQR"? Nevermind...I found that SQRIBE was formerly known as MITI which bought SQR from Sybase in 1996. BRIO subsequently bought SQRIBE and SQR in August of 1999. Thanks anyway for any responses I haven't seen yet. B The Programmer formerly known as Bob Mediware Information Systems Inc. (913) 307-1045 Bob.Helm@Mediware.com This message has been sent using 100% recycled electrons. -----Original Message----- From: Bob Helm [mailto:Bob.Helm@MEDIWARE.COM] Sent: Wednesday, January 02, 2002 9:23 AM To: SQR-USERS@list.iex.net Subject: anyone heard of "MITI SQR"? A document I've come across makes mention using "MITI SQR 3". I thought BRIO has SQR and before that it was Sqribe. Has anyone heard of this and what is MITI? Thanks for any info. B The Programmer formerly known as Bob Mediware Information Systems Inc. (913) 307-1045 Bob.Helm@Mediware.com From owner-sqr-users@list.iex.net Wed Jan 2 12:14:52 2002 Date: Wed, 2 Jan 2002 12:08:59 -0500 From: Ray Ontko Subject: Re: anyone heard of "MITI SQR"? Paul, My understanding is that PeopleSoft bought the rights to the source code for SQR. I don't know any details of the ongoing relationship between Brio and PeopleSoft, but I assume that PS can now control which features get added and which bugs get fixed in _its_ version of SQR, and Brio will continue to license SQR and add features that open new markets for the product as a tool quite separate from those needed for PS. I don't expect PS to sell SQR separately from its products. There is some chance that the two versions of SQR will diverge over time, I suppose. I would expect that both versions will remain largely the same; SQR is a fairly mature product, and all of the enterprise reporting features are still core features for both Brio and PeopleSoft. Ray > And just as a bye the way - I believe that PeopleSoft have now bought SQR > Regards > Paul > > > > > > Bob Helm @list.iex.net> on 02/01/2002 15:56:12 > > Please respond to sqr-users@list.iex.net > > Sent by: "Discussion of SQR, Brio Software's database reporting language" > > > > To: SQR-USERS@list.iex.net > cc: > > Subject: Re: anyone heard of "MITI SQR"? > > > Nevermind...I found that SQRIBE was formerly known as MITI which bought > SQR > from Sybase in 1996. > BRIO subsequently bought SQRIBE and SQR in August of 1999. > > Thanks anyway for any responses I haven't seen yet. > > B > The Programmer formerly known as Bob > Mediware Information Systems Inc. > (913) 307-1045 > Bob.Helm@Mediware.com > > This message has been sent using 100% recycled electrons. > > > > > -----Original Message----- > From: Bob Helm [mailto:Bob.Helm@MEDIWARE.COM] > Sent: Wednesday, January 02, 2002 9:23 AM > To: SQR-USERS@list.iex.net > Subject: anyone heard of "MITI SQR"? > > > A document I've come across makes mention using "MITI SQR 3". > I thought BRIO has SQR and before that it was Sqribe. > > Has anyone heard of this and what is MITI? > > Thanks for any info. > > B > The Programmer formerly known as Bob > Mediware Information Systems Inc. > (913) 307-1045 > Bob.Helm@Mediware.com > [Attachment, skipping...] ---------------------------------------------------------------------- Ray Ontko rayo@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ From owner-sqr-users@list.iex.net Wed Jan 2 12:24:25 2002 Date: Wed, 2 Jan 2002 11:19:13 -0600 From: the dragon Subject: Re: anyone heard of "MITI SQR"? They just changed their name from MITI to sqribe (in 1995 I think) to protect the guilty. clark 'the dragon' willis dragon enterprises, consulting services PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- MITI is the company that owned SQR (version 3.0) prior to Sqribe. The MITI company may be out of business... I couldn't get to their web site: miti.com. Subject: anyone heard of "MITI SQR"? A document I've come across makes mention using "MITI SQR 3". I thought BRIO has SQR and before that it was Sqribe. Has anyone heard of this and what is MITI? Thanks for any info. B The Programmer formerly known as Bob Mediware Information Systems Inc. (913) 307-1045 Bob.Helm@Mediware.com _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com From owner-sqr-users@list.iex.net Wed Jan 2 15:10:18 2002 Date: Wed, 2 Jan 2002 15:00:04 -0500 From: Bruce Kelling Subject: Images in UNIX SQR reports Does anyone know if it is possible to produce an sqr report with an image when run on UNIX? The preferred output is adobe using -printer:pd SQR flag. I have used .bmp, .gif, and .jpg on Windows NT run reports, but have not been able to get any image file types to show up on a UNIX run sqr. Is there a limitation on using SQR version 4.3.4? If anyone has produced images in UNIX run sqr, please share secrets. Bruce From owner-sqr-users@list.iex.net Wed Jan 2 16:27:54 2002 Date: Wed, 2 Jan 2002 14:12:16 +0700 From: John Willson Subject: Re: Images in UNIX SQR reports Hi Bruce. See the print-image command. Note that on UNIX only reports I have only used this command with postscript reports. So before invoking the command I also do an image sizing procedure to ensure the image is scaled (with an aspect ratio) into the area that is being printed. I no longer have a copy of UNIX based SQR to test this on and provide examples; however, I can confirm that SQRs developed under WINNT BR 6 using postscript and nonpostscript when run on UNIX BR 6 just execute faster and print the same. (both gif and jpg. I don't know about bmp) So write and debug with NT and run production with UNIX Hope this helps. John Willson Another approach graphic box somesize print-image type= gif-file source = 'myimage.gif' image-size = somesize http://netwinsite.com/dbabble/ From owner-sqr-users@list.iex.net Wed Jan 2 17:27:08 2002 Date: Wed, 2 Jan 2002 16:21:58 -0600 From: "Shipley, Lisa A." Subject: date problems Oracle 7.3.4 SQR 4.3.4 Good Afternoon, I'm trying to subtract 1 day from a value that a user keys in. I've done this before in other programs, but for some reason, I can't get it to work today. INPUT $BegDate 'Enter begin date (DD-Mon-YYYY)' type=char maxlen=11 IF rtrim($BegDate, ' ') = '' goto Done END-IF let $BDate = strtodate($BegDate, 'DD-MON-YYYY') DISPLAY '$BDate ' Noline Display $Bdate do convert-to-dtu-date($BDate,$DATE_OUT) The output for $DATE_OUT is 2001--24. It's leaving the month DEC out. I can't for the life of me figure out why. Any help is GREATLY appreciated!!!!! Lisa Shipley Senior Programmer Sumitomo Electric Wiring Systems, Inc. Phone: (270) 782-7397 Ext. 2226 From owner-sqr-users@list.iex.net Wed Jan 2 18:15:22 2002 Date: Wed, 2 Jan 2002 17:03:27 -0600 From: Bob Helm Subject: Re: date problems Intriguing. Is there something "wrong" in the procedure convert-to-dtu-date? -----Original Message----- From: Shipley, Lisa A. [mailto:lshipley@SEWSUS.COM] Sent: Wednesday, January 02, 2002 4:22 PM To: SQR-USERS@list.iex.net Subject: date problems Oracle 7.3.4 SQR 4.3.4 Good Afternoon, I'm trying to subtract 1 day from a value that a user keys in. I've done this before in other programs, but for some reason, I can't get it to work today. INPUT $BegDate 'Enter begin date (DD-Mon-YYYY)' type=char maxlen=11 IF rtrim($BegDate, ' ') = '' goto Done END-IF let $BDate = strtodate($BegDate, 'DD-MON-YYYY') DISPLAY '$BDate ' Noline Display $Bdate do convert-to-dtu-date($BDate,$DATE_OUT) The output for $DATE_OUT is 2001--24. It's leaving the month DEC out. I can't for the life of me figure out why. Any help is GREATLY appreciated!!!!! Lisa Shipley Senior Programmer Sumitomo Electric Wiring Systems, Inc. Phone: (270) 782-7397 Ext. 2226 From owner-sqr-users@list.iex.net Wed Jan 2 18:40:50 2002 Date: Wed, 2 Jan 2002 16:35:41 -0700 From: Russ Wulfson Subject: Re: date problems I believe your problem may be that your format 'DD-MON-YYYY' should be 'DD-MM-YYYY' From owner-sqr-users@list.iex.net Thu Jan 3 00:04:38 2002 Date: Wed, 2 Jan 2002 23:49:08 EST From: Edson Fernandes Subject: (no subject) Hi ,=20 I need your help!! Do you have an example where I can display data in 10 rows =A0in an SQR arra= y=20 on one line. I tried to use the write command but it seems to display data on different=20 lines. for example col 1 =A0col2 =A0col3 1 =A0=A0=A0=A0=A0=A0=A0=A0=A02 =A0=A0=A0=A0=A03 4 =A0=A0=A0=A0=A0=A0=A0=A0=A05 =A0=A0=A0=A0=A06 7 =A0=A0=A0=A0=A0=A0=A0=A0=A08 =A0=A0=A0=A0=A09 Result =A0output file should look like 1 =A0=A0=A0=A02 =A0=A0=A0=A0=A03 =A0=A0=A0=A0=A04 =A0=A0=A05 =A0=A0=A06 =A0= =A0=A0=A07 =A0=A0=A08 =A0=A09 =A0 From owner-sqr-users@list.iex.net Thu Jan 3 05:26:33 2002 Date: Thu, 3 Jan 2002 17:03:53 +0700 From: Kalam Subject: how to change font-size ? dear all, i want to change font-size through my sqr file ? how can i do that ? anyhelp would be highly appreciated.... TIA From owner-sqr-users@list.iex.net Thu Jan 3 09:58:29 2002 Date: Thu, 3 Jan 2002 09:41:01 -0500 From: Steve Wowelko Subject: Re: Images in UNIX SQR reports Hi Bruce, I've spent weeks trying to get this to work. I finally did get it to work. Here's what I had to do- Declare your printer as an HP printer. I used a PeopleSoft supplied .sqc: #include 'setup31.sqc' !Portrait HP Printer Declare your image as an HPGL image: declare-image A1 type=HPGL-FILE source='/opt/psoft/syracuse/hrsa750/sqr/iofiles/registr/signature.hpg' ! location on UNIX server image-size=(40,6) end-declare Then just print the image: print-image A1 (66,8) The real (frustrating) problem is creating an HPGL file that SQR likes. I have tried various graphic packages to do this to no avail. There is a SQR that will convert a .bmp file to an .hpg (HPGL) format. It is found at the following web site: http://www.ontko.com/sqr/bmp_to_hpg.sqr It is shareware written by Ray Ontko. It does a wonderful job converting images. (thank you Ray!) Hope this helps. Stephen Wowelko, EDP Syracuse University - Information Systems >>> jwillson@DSSLTD.COM 01/02/02 02:12AM >>> Hi Bruce. See the print-image command. Note that on UNIX only reports I have only used this command with postscript reports. So before invoking the command I also do an image sizing procedure to ensure the image is scaled (with an aspect ratio) into the area that is being printed. I no longer have a copy of UNIX based SQR to test this on and provide examples; however, I can confirm that SQRs developed under WINNT BR 6 using postscript and nonpostscript when run on UNIX BR 6 just execute faster and print the same. (both gif and jpg. I don't know about bmp) So write and debug with NT and run production with UNIX Hope this helps. John Willson Another approach graphic box somesize print-image type= gif-file source = 'myimage.gif' image-size = somesize http://netwinsite.com/dbabble/ From owner-sqr-users@list.iex.net Thu Jan 3 10:19:21 2002 Date: Thu, 3 Jan 2002 09:13:31 -0600 From: the dragon Subject: Re: date problems Lisa, I don't have a lot of time to examine this completely, but, right off the bat, I can tell you Oracle will not see the date formats DD-Mon-YYYY and DD-MON-YYYY (31-Dec-2001 <> 31-DEC-2001) as the same thing. I think if you make the conversion mask the same as the input mask you will see different results. clark 'the dragon' willis dragon enterprises, consulting services "Doing it right the first time, at an affordable rate." PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Oracle 7.3.4 SQR 4.3.4 Good Afternoon, I'm trying to subtract 1 day from a value that a user keys in. I've done this before in other programs, but for some reason, I can't get it to work today. INPUT $BegDate 'Enter begin date (DD-Mon-YYYY)' type=char maxlen=11 IF rtrim($BegDate, ' ') = '' goto Done END-IF let $BDate = strtodate($BegDate, 'DD-MON-YYYY') DISPLAY '$BDate ' Noline Display $Bdate do convert-to-dtu-date($BDate,$DATE_OUT) The output for $DATE_OUT is 2001--24. It's leaving the month DEC out. I can't for the life of me figure out why. Any help is GREATLY appreciated!!!!! Lisa Shipley Senior Programmer Sumitomo Electric Wiring Systems, Inc. Phone: (270) 782-7397 Ext. 2226 PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) NOTICE: The information contained in this message is protected under United States and international copyright laws and is intended for the personal and confidential use of the addressee. If you are not the addressee or an agent of the addressee, you are hereby notified that you have received this message in error and that any review, dissemination, distribution, taking of any action in reliance upon or copying of this message without the express written permission of the sender or his agent is strictly prohibited and in violation of referenced statutes. If you have received this message in error, please notify me (the sender) immediately and you are instructed to delete this message from any computer it resides on, including mail servers. SIGNATURE : Do not meddle in the affairs of dragons, for you are crunchy and taste good with ketchup. You've got to be a Spirit; don't need no Ghosts. Do or Do Not; There is NO Try. Any clod can have facts, but having an opinion is an art ! A conclusion is simply the place where someone got tired of thinking. When a continuing state of defiance and disorder can not be checked by the rules, then new and sometimes drastic rules must be forged to maintain order; the alternative is anarchy. M. Clark Willis III - Sr Systems Analyst, Sr Consultant ceprn@hotmail.com aolim:ceprn ICQ 6633136 Help stamp out SPAM!! http://www.cauce.org The senders of unsolicited commercial e-mail to me at any site are liable for a $500 per message cost under USC 47, which may be found at http://www.law.cornell.edu/uscode/47 Contents of this message, in it's entirety, (c) 2000 M. Clark Willis III / Dragon Enterprises inc. All rights reserved. _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com From owner-sqr-users@list.iex.net Thu Jan 3 11:25:53 2002 Date: Thu, 3 Jan 2002 11:16:32 -0500 From: Bruce Kelling Subject: Re: Images in UNIX SQR reports Great suggestions. This is exactly what I have been trying, but still no image, even after using the bmp to hpg converter. Do you know if an ADOBE pdf file can be created on UNIX with an image? Any other possibilities to check? Thanks, Bruce Kelling PeopleSoft Developer AdvanTech SolutionsSM -----Original Message----- From: Steve Wowelko [mailto:SAWOWELK@SYR.EDU] Sent: Thursday, January 03, 2002 9:41 AM To: SQR-USERS@list.iex.net Subject: Re: Images in UNIX SQR reports Hi Bruce, I've spent weeks trying to get this to work. I finally did get it to work. Here's what I had to do- Declare your printer as an HP printer. I used a PeopleSoft supplied .sqc: #include 'setup31.sqc' !Portrait HP Printer Declare your image as an HPGL image: declare-image A1 type=HPGL-FILE source='/opt/psoft/syracuse/hrsa750/sqr/iofiles/registr/signature.hpg' ! location on UNIX server image-size=(40,6) end-declare Then just print the image: print-image A1 (66,8) The real (frustrating) problem is creating an HPGL file that SQR likes. I have tried various graphic packages to do this to no avail. There is a SQR that will convert a .bmp file to an .hpg (HPGL) format. It is found at the following web site: http://www.ontko.com/sqr/bmp_to_hpg.sqr It is shareware written by Ray Ontko. It does a wonderful job converting images. (thank you Ray!) Hope this helps. Stephen Wowelko, EDP Syracuse University - Information Systems >>> jwillson@DSSLTD.COM 01/02/02 02:12AM >>> Hi Bruce. See the print-image command. Note that on UNIX only reports I have only used this command with postscript reports. So before invoking the command I also do an image sizing procedure to ensure the image is scaled (with an aspect ratio) into the area that is being printed. I no longer have a copy of UNIX based SQR to test this on and provide examples; however, I can confirm that SQRs developed under WINNT BR 6 using postscript and nonpostscript when run on UNIX BR 6 just execute faster and print the same. (both gif and jpg. I don't know about bmp) So write and debug with NT and run production with UNIX Hope this helps. John Willson Another approach graphic box somesize print-image type= gif-file source = 'myimage.gif' image-size = somesize http://netwinsite.com/dbabble/ From owner-sqr-users@list.iex.net Thu Jan 3 11:54:00 2002 Date: Thu, 3 Jan 2002 09:26:51 -0600 From: "Shipley, Lisa A." Subject: FW: date problems I've changed the input mask to fit the conversion mask and it still gives me the same error. INPUT $EndDate maxlen=11 'Enter end date (DD-MON-YYYY)' IF rtrim($EndDate, ' ') = '' goto Done END-IF LET $end = strtodate($EndDate, 'DD-MON-YYYY') DISPLAY '$END ' NOLINE DISPLAY $END do convert-to-dtu-date($End,$ENDYMD) My display on $End looks good '30-DEC-2001' After the attempt at the dtu conversion, I still get 30--2001 with an invalid month error. -----Original Message----- From: the dragon [mailto:ceprn@hotmail.com] Sent: Thursday, January 03, 2002 9:14 AM To: sqr-users@list.iex.net Subject: Re: date problems Lisa, I don't have a lot of time to examine this completely, but, right off the bat, I can tell you Oracle will not see the date formats DD-Mon-YYYY and DD-MON-YYYY (31-Dec-2001 <> 31-DEC-2001) as the same thing. I think if you make the conversion mask the same as the input mask you will see different results. clark 'the dragon' willis dragon enterprises, consulting services "Doing it right the first time, at an affordable rate." PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Oracle 7.3.4 SQR 4.3.4 Good Afternoon, I'm trying to subtract 1 day from a value that a user keys in. I've done this before in other programs, but for some reason, I can't get it to work today. INPUT $BegDate 'Enter begin date (DD-Mon-YYYY)' type=char maxlen=11 IF rtrim($BegDate, ' ') = '' goto Done END-IF let $BDate = strtodate($BegDate, 'DD-MON-YYYY') DISPLAY '$BDate ' Noline Display $Bdate do convert-to-dtu-date($BDate,$DATE_OUT) The output for $DATE_OUT is 2001--24. It's leaving the month DEC out. I can't for the life of me figure out why. Any help is GREATLY appreciated!!!!! Lisa Shipley Senior Programmer Sumitomo Electric Wiring Systems, Inc. Phone: (270) 782-7397 Ext. 2226 PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) NOTICE: The information contained in this message is protected under United States and international copyright laws and is intended for the personal and confidential use of the addressee. If you are not the addressee or an agent of the addressee, you are hereby notified that you have received this message in error and that any review, dissemination, distribution, taking of any action in reliance upon or copying of this message without the express written permission of the sender or his agent is strictly prohibited and in violation of referenced statutes. If you have received this message in error, please notify me (the sender) immediately and you are instructed to delete this message from any computer it resides on, including mail servers. SIGNATURE : Do not meddle in the affairs of dragons, for you are crunchy and taste good with ketchup. You've got to be a Spirit; don't need no Ghosts. Do or Do Not; There is NO Try. Any clod can have facts, but having an opinion is an art ! A conclusion is simply the place where someone got tired of thinking. When a continuing state of defiance and disorder can not be checked by the rules, then new and sometimes drastic rules must be forged to maintain order; the alternative is anarchy. M. Clark Willis III - Sr Systems Analyst, Sr Consultant ceprn@hotmail.com aolim:ceprn ICQ 6633136 Help stamp out SPAM!! http://www.cauce.org The senders of unsolicited commercial e-mail to me at any site are liable for a $500 per message cost under USC 47, which may be found at http://www.law.cornell.edu/uscode/47 Contents of this message, in it's entirety, (c) 2000 M. Clark Willis III / Dragon Enterprises inc. All rights reserved. _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com From owner-sqr-users@list.iex.net Thu Jan 3 12:13:55 2002 Date: Thu, 3 Jan 2002 11:06:21 -0600 From: Betty Thompson Subject: Re: date problems This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C19446.AD4227A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I'm still a beginner, so bear with me, please, if this sounds silly... Could you be missing some variable value that affects how the functions work? I shoved your stuff into a shell program and it worked fine (I only omitted the 'if' statement with the 'goto Done'). What I thought might be different is that I always use a shell with the same bunch of sqc includes. I built this shell after going to SQR class, and I never really look at it any more, but I think it sets a lot of variables regarding dates. I attached my test program and the log from running it. Good luck. Betty -----Original Message----- From: Discussion of SQR, Brio Software's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Shipley, Lisa A. Sent: Thursday, January 03, 2002 9:27 AM To: SQR-USERS@list.iex.net Subject: FW: date problems I've changed the input mask to fit the conversion mask and it still gives me the same error. INPUT $EndDate maxlen=11 'Enter end date (DD-MON-YYYY)' IF rtrim($EndDate, ' ') = '' goto Done END-IF LET $end = strtodate($EndDate, 'DD-MON-YYYY') DISPLAY '$END ' NOLINE DISPLAY $END do convert-to-dtu-date($End,$ENDYMD) My display on $End looks good '30-DEC-2001' After the attempt at the dtu conversion, I still get 30--2001 with an invalid month error. -----Original Message----- From: the dragon [mailto:ceprn@hotmail.com] Sent: Thursday, January 03, 2002 9:14 AM To: sqr-users@list.iex.net Subject: Re: date problems Lisa, I don't have a lot of time to examine this completely, but, right off the bat, I can tell you Oracle will not see the date formats DD-Mon-YYYY and DD-MON-YYYY (31-Dec-2001 <> 31-DEC-2001) as the same thing. I think if you make the conversion mask the same as the input mask you will see different results. clark 'the dragon' willis dragon enterprises, consulting services "Doing it right the first time, at an affordable rate." PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Oracle 7.3.4 SQR 4.3.4 Good Afternoon, I'm trying to subtract 1 day from a value that a user keys in. I've done this before in other programs, but for some reason, I can't get it to work today. INPUT $BegDate 'Enter begin date (DD-Mon-YYYY)' type=char maxlen=11 IF rtrim($BegDate, ' ') = '' goto Done END-IF let $BDate = strtodate($BegDate, 'DD-MON-YYYY') DISPLAY '$BDate ' Noline Display $Bdate do convert-to-dtu-date($BDate,$DATE_OUT) The output for $DATE_OUT is 2001--24. It's leaving the month DEC out. I can't for the life of me figure out why. Any help is GREATLY appreciated!!!!! Lisa Shipley Senior Programmer Sumitomo Electric Wiring Systems, Inc. Phone: (270) 782-7397 Ext. 2226 PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) NOTICE: The information contained in this message is protected under United States and international copyright laws and is intended for the personal and confidential use of the addressee. If you are not the addressee or an agent of the addressee, you are hereby notified that you have received this message in error and that any review, dissemination, distribution, taking of any action in reliance upon or copying of this message without the express written permission of the sender or his agent is strictly prohibited and in violation of referenced statutes. If you have received this message in error, please notify me (the sender) immediately and you are instructed to delete this message from any computer it resides on, including mail servers. SIGNATURE : Do not meddle in the affairs of dragons, for you are crunchy and taste good with ketchup. You've got to be a Spirit; don't need no Ghosts. Do or Do Not; There is NO Try. Any clod can have facts, but having an opinion is an art ! A conclusion is simply the place where someone got tired of thinking. When a continuing state of defiance and disorder can not be checked by the rules, then new and sometimes drastic rules must be forged to maintain order; the alternative is anarchy. M. Clark Willis III - Sr Systems Analyst, Sr Consultant ceprn@hotmail.com aolim:ceprn ICQ 6633136 Help stamp out SPAM!! http://www.cauce.org The senders of unsolicited commercial e-mail to me at any site are liable for a $500 per message cost under USC 47, which may be found at http://www.law.cornell.edu/uscode/47 Contents of this message, in it's entirety, (c) 2000 M. Clark Willis III / Dragon Enterprises inc. All rights reserved. _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com ------=_NextPart_000_0006_01C19446.AD4227A0 Content-Type: application/octet-stream; name="sqrtest.sqr" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="sqrtest.sqr" !*********************************************************************** ! Report Name: sqrtest.SQR ! ! Purpose: testing ! ! Author: B. THOMPSON January, 2002. ! !*********************************************************************** !---------------------------------------------------------------------- ! ALWAYS INCLUDED AT BEGINNING OF SQR !---------------------------------------------------------------------- #include 'setenv.sqc' !Sets enviroment !*********************************************************************** !****************** BEGIN-SETUP ****************************** !*********************************************************************** !---------------------------------------------------------------------- ! CHOOSE PRINTER ORIENTATION !---------------------------------------------------------------------- ! ! NOTE: setup01.sqc includes begin-setup/end-setup; ! ptpsl160.sqc does not. ! ! #include 'setup01.sqc' !Inits Printer and Page-size -- PORTRAIT ! ! - or - (use one or the other) ! ! BEGIN-SETUP ! #include 'ptpsl160.sqc' !Inits Printer and Page-size -- LANDSCAPE ! END-SETUP ! !---------------------------------------------------------------------- BEGIN-SETUP #include 'ptpsl160.sqc' !Inits Printer and Page-size -- LANDSCAPE END-SETUP !:::::::::::::::::::::::::::::: ! => ADD CUSTOM DEFINES HERE... !:::::::::::::::::::::::::::::: #define Report_Institution 'University of Wisconsin - Whitewater' #define Report_Area 'Student Financials' #define ReportTitle 'Betty is Testing' !---- The following are column positions on the report. #define C01 02 ! Emplid #define C02 12 ! term #define C03 20 ! #define C04 40 ! #define C05 60 ! #define C06 80 ! !*********************************************************************** !****************** BEGIN-HEADING ****************************** !*********************************************************************** begin-heading 10 !:::::::::::::::::::::::::::::: ! => IS THE NUMBER OF ! HEADING LINES CORRECT? !:::::::::::::::::::::::::::::: ! >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> ! >>>>>>> NOTE: #current-line depends upon the # of hdg lines stated. ! >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> !---------------------------------------------------------------------- ! ! Heading lines 1-4 are generic report headings for Student Financials. ! !---------------------------------------------------------------------- ! These headings were adapted from: ! #include 'stdhdg01.sqc' !Produces primary headings ! ! When using 'ptpsl160.sqc', you must have this: ! let #RptCol = {ColR} - 11 ! else the headings print beyond the right margin. !----------------------------------------------------------------------- let #RptCol = {ColR} - 9 ! <==== BPT - changed this let $Money_Mask = '$$$,999,999.00MI' !------------- ! Hdg line 1 !------------- print 'Report ID: ' (,1) print $ReportID () print {Report_Institution} () center page-number (0,#RptCol) 'Page No. ' !------------- ! Hdg line 2 !------------- print 'Run Date: ' (+1,1) print $ReportDate () print {Report_Area} () center print 'Run Time: ' (,#RptCol) print $ReportTime () !------------- ! Hdg line 4 !------------- print {ReportTitle} (+2,) center bold !:::::::::::::::::::::::::::::: ! => ADD CUSTOM HDGS HERE... !:::::::::::::::::::::::::::::: end-heading !*********************************************************************** !****************** BEGIN-PROGRAM ****************************** !*********************************************************************** begin-program !---------------------------------------------------------------------- ! ALWAYS INCLUDED AT START OF 'PROGRAM' PARAGRAPH ! ! This is a generic start-up. !---------------------------------------------------------------------- do DEFINE-PRCS-VARS ! Provides PS platform independence do GET-RUN-CONTROL-PARMS ! Std PS startup - gets oprid + run-cntl-id do INIT-DATETIME ! Needed for GET-CURRENT-DATETIME do GET-CURRENT-DATETIME ! Populates the heading date and time !:::::::::::::::::::::::::::::: ! => ADD CUSTOM CODE BELOW... !:::::::::::::::::::::::::::::: INPUT $EndDate maxlen=11 'Enter end date (DD-MON-YYYY)' let $Msg = '$enddate = ' || $enddate display $Msg LET $end = strtodate($EndDate,'DD-MON-YYYY') let $Msg = '$end = ' || $end display $Msg do convert-to-dtu-date($End,$ENDYMD) let $Msg = '$endymd = ' || $endymd display $Msg INPUT $EndDate maxlen=11 'Enter end date (DD-mon-YYYY)' let $Msg = '$enddate = ' || $enddate display $Msg LET $end = strtodate($EndDate,'DD-MON-YYYY') let $Msg = '$end = ' || $end display $Msg do convert-to-dtu-date($End,$ENDYMD) let $Msg = '$endymd = ' || $endymd display $Msg INPUT $EndDate maxlen=11 'Enter end date (DD-MON-YYYY)' LET $end = strtodate($EndDate, 'DD-MON-YYYY') DISPLAY '$END ' NOLINE DISPLAY $END do convert-to-dtu-date($End,$ENDYMD) DISPLAY '$END ' NOLINE DISPLAY $END !---------------------------------------------------------------------- ! ALWAYS INCLUDED AT END OF 'PROGRAM' PARAGRAPH ! ! This is a generic shut-down. !---------------------------------------------------------------------- do RESET !resets PS global variable for reporting do SUCCESSFUL-EOJ !resets PS global variables for exec status end-program !*********************************************************************** ! SQC files for called procedures !*********************************************************************** #include 'datemath.sqc' ! Convert-To-DTU-Date #include 'curdttim.sqc' ! GET-CURRENT-DATETIME #include 'datetime.sqc' ! needed by GET-CURRENT-DATETIME #include 'wwsfslct.sqc' ! WWSFSLCT-SELECT-PARAMETERS #include 'wwsfasgn.sqc' ! WWSFASGN-BUSINESS-UNIT #include 'reset.sqc' ! RESET #include 'eoj.sqc' ! SUCCESSFUL-EOJ #include 'prcsdef.sqc' ! DEFINE-PRCS-VARS #include 'prcsapi.sqc' ! GET-RUN-CONTROL-PARMS ! #include 'getempnm.sqc' ! GET-EMPLOYEE-NAME !************************* End Of Program **************************** ------=_NextPart_000_0006_01C19446.AD4227A0 Content-Type: application/octet-stream; name="sqr.log" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="sqr.log" Please press ENTER (Do not input a value): Enter end date (DD-MON-YYYY): 02-feb-2001 $enddate = 02-feb-2001 $end = 02-FEB-2001 $endymd = 2001-02-02 Enter end date (DD-mon-YYYY): 02-FEB-2001 $enddate = 02-FEB-2001 $end = 02-FEB-2001 $endymd = 2001-02-02 Enter end date (DD-MON-YYYY): 02-FEB-2001 $END 02-FEB-2001 $END 02-FEB-2001 SQR: End of Run. ------=_NextPart_000_0006_01C19446.AD4227A0-- From owner-sqr-users@list.iex.net Thu Jan 3 12:33:11 2002 Date: Thu, 3 Jan 2002 12:26:36 -0500 From: Jerry Coleman Subject: Re: FW: date problems I can't recreate your error on Oracle 8.1.6, PSFT 7.51 using the following. Why don't you try adding -debugx to the SQR command line, and it should dump out some trace info, which may contain some clues. #include 'setenv.sqc' !Set environment BEGIN-REPORT do Init-DateTime do Init-Number do Get-Current-DateTime display 'Report Ended: ' noline do Init-Report END-REPORT BEGIN-PROCEDURE INIT-REPORT INPUT $EndDate maxlen=11 'Enter end date (DD-MON-YYYY)' LET $end = strtodate($EndDate, 'DD-MON-YYYY') SHOW '$END ' $END do convert-to-dtu-date($End,$ENDYMD) SHOW ' $ENDYMD ' $ENDYMD END-PROCEDURE #include 'curdttim.sqc' #include 'datetime.sqc' #include 'number.sqc' #include 'datemath.sqc' #include 'stdapi.sqc' |---------+----------------------------> | | "Shipley, Lisa | | | A." | | | | | | Sent by: | | | "Discussion of | | | SQR, Brio | | | Software's | | | database | | | reporting | | | language" | | | | | | | | | | | | 01/03/02 10:26 AM| | | Please respond to| | | sqr-users | | | | |---------+----------------------------> >--------------------------------------------------------------------------------------------------------------| | | | To: SQR-USERS@list.iex.net | | cc: | | Subject: FW: date problems | >--------------------------------------------------------------------------------------------------------------| I've changed the input mask to fit the conversion mask and it still gives me the same error. INPUT $EndDate maxlen=11 'Enter end date (DD-MON-YYYY)' IF rtrim($EndDate, ' ') = '' goto Done END-IF LET $end = strtodate($EndDate, 'DD-MON-YYYY') DISPLAY '$END ' NOLINE DISPLAY $END do convert-to-dtu-date($End,$ENDYMD) My display on $End looks good '30-DEC-2001' After the attempt at the dtu conversion, I still get 30--2001 with an invalid month error. -----Original Message----- From: the dragon [mailto:ceprn@hotmail.com] Sent: Thursday, January 03, 2002 9:14 AM To: sqr-users@list.iex.net Subject: Re: date problems Lisa, I don't have a lot of time to examine this completely, but, right off the bat, I can tell you Oracle will not see the date formats DD-Mon-YYYY and DD-MON-YYYY (31-Dec-2001 <> 31-DEC-2001) as the same thing. I think if you make the conversion mask the same as the input mask you will see different results. clark 'the dragon' willis dragon enterprises, consulting services "Doing it right the first time, at an affordable rate." PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Oracle 7.3.4 SQR 4.3.4 Good Afternoon, I'm trying to subtract 1 day from a value that a user keys in. I've done this before in other programs, but for some reason, I can't get it to work today. INPUT $BegDate 'Enter begin date (DD-Mon-YYYY)' type=char maxlen=11 IF rtrim($BegDate, ' ') = '' goto Done END-IF let $BDate = strtodate($BegDate, 'DD-MON-YYYY') DISPLAY '$BDate ' Noline Display $Bdate do convert-to-dtu-date($BDate,$DATE_OUT) The output for $DATE_OUT is 2001--24. It's leaving the month DEC out. I can't for the life of me figure out why. Any help is GREATLY appreciated!!!!! Lisa Shipley Senior Programmer Sumitomo Electric Wiring Systems, Inc. Phone: (270) 782-7397 Ext. 2226 PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) NOTICE: The information contained in this message is protected under United States and international copyright laws and is intended for the personal and confidential use of the addressee. If you are not the addressee or an agent of the addressee, you are hereby notified that you have received this message in error and that any review, dissemination, distribution, taking of any action in reliance upon or copying of this message without the express written permission of the sender or his agent is strictly prohibited and in violation of referenced statutes. If you have received this message in error, please notify me (the sender) immediately and you are instructed to delete this message from any computer it resides on, including mail servers. SIGNATURE : Do not meddle in the affairs of dragons, for you are crunchy and taste good with ketchup. You've got to be a Spirit; don't need no Ghosts. Do or Do Not; There is NO Try. Any clod can have facts, but having an opinion is an art ! A conclusion is simply the place where someone got tired of thinking. When a continuing state of defiance and disorder can not be checked by the rules, then new and sometimes drastic rules must be forged to maintain order; the alternative is anarchy. M. Clark Willis III - Sr Systems Analyst, Sr Consultant ceprn@hotmail.com aolim:ceprn ICQ 6633136 Help stamp out SPAM!! http://www.cauce.org The senders of unsolicited commercial e-mail to me at any site are liable for a $500 per message cost under USC 47, which may be found at http://www.law.cornell.edu/uscode/47 Contents of this message, in it's entirety, (c) 2000 M. Clark Willis III / Dragon Enterprises inc. All rights reserved. _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com From owner-sqr-users@list.iex.net Thu Jan 3 12:34:35 2002 Date: Thu, 3 Jan 2002 12:30:42 -0500 From: Jerry Coleman Subject: Re: FW: date problems Also, ask your DBA if he/she changed the NLS_DATE_FORMAT setting, either on the server or your workstation registry. |---------+----------------------------> | | "Shipley, Lisa | | | A." | | | | | | Sent by: | | | "Discussion of | | | SQR, Brio | | | Software's | | | database | | | reporting | | | language" | | | | | | | | | | | | 01/03/02 10:26 AM| | | Please respond to| | | sqr-users | | | | |---------+----------------------------> >--------------------------------------------------------------------------------------------------------------| | | | To: SQR-USERS@list.iex.net | | cc: | | Subject: FW: date problems | >--------------------------------------------------------------------------------------------------------------| I've changed the input mask to fit the conversion mask and it still gives me the same error. INPUT $EndDate maxlen=11 'Enter end date (DD-MON-YYYY)' IF rtrim($EndDate, ' ') = '' goto Done END-IF LET $end = strtodate($EndDate, 'DD-MON-YYYY') DISPLAY '$END ' NOLINE DISPLAY $END do convert-to-dtu-date($End,$ENDYMD) My display on $End looks good '30-DEC-2001' After the attempt at the dtu conversion, I still get 30--2001 with an invalid month error. -----Original Message----- From: the dragon [mailto:ceprn@hotmail.com] Sent: Thursday, January 03, 2002 9:14 AM To: sqr-users@list.iex.net Subject: Re: date problems Lisa, I don't have a lot of time to examine this completely, but, right off the bat, I can tell you Oracle will not see the date formats DD-Mon-YYYY and DD-MON-YYYY (31-Dec-2001 <> 31-DEC-2001) as the same thing. I think if you make the conversion mask the same as the input mask you will see different results. clark 'the dragon' willis dragon enterprises, consulting services "Doing it right the first time, at an affordable rate." PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Oracle 7.3.4 SQR 4.3.4 Good Afternoon, I'm trying to subtract 1 day from a value that a user keys in. I've done this before in other programs, but for some reason, I can't get it to work today. INPUT $BegDate 'Enter begin date (DD-Mon-YYYY)' type=char maxlen=11 IF rtrim($BegDate, ' ') = '' goto Done END-IF let $BDate = strtodate($BegDate, 'DD-MON-YYYY') DISPLAY '$BDate ' Noline Display $Bdate do convert-to-dtu-date($BDate,$DATE_OUT) The output for $DATE_OUT is 2001--24. It's leaving the month DEC out. I can't for the life of me figure out why. Any help is GREATLY appreciated!!!!! Lisa Shipley Senior Programmer Sumitomo Electric Wiring Systems, Inc. Phone: (270) 782-7397 Ext. 2226 PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) NOTICE: The information contained in this message is protected under United States and international copyright laws and is intended for the personal and confidential use of the addressee. If you are not the addressee or an agent of the addressee, you are hereby notified that you have received this message in error and that any review, dissemination, distribution, taking of any action in reliance upon or copying of this message without the express written permission of the sender or his agent is strictly prohibited and in violation of referenced statutes. If you have received this message in error, please notify me (the sender) immediately and you are instructed to delete this message from any computer it resides on, including mail servers. SIGNATURE : Do not meddle in the affairs of dragons, for you are crunchy and taste good with ketchup. You've got to be a Spirit; don't need no Ghosts. Do or Do Not; There is NO Try. Any clod can have facts, but having an opinion is an art ! A conclusion is simply the place where someone got tired of thinking. When a continuing state of defiance and disorder can not be checked by the rules, then new and sometimes drastic rules must be forged to maintain order; the alternative is anarchy. M. Clark Willis III - Sr Systems Analyst, Sr Consultant ceprn@hotmail.com aolim:ceprn ICQ 6633136 Help stamp out SPAM!! http://www.cauce.org The senders of unsolicited commercial e-mail to me at any site are liable for a $500 per message cost under USC 47, which may be found at http://www.law.cornell.edu/uscode/47 Contents of this message, in it's entirety, (c) 2000 M. Clark Willis III / Dragon Enterprises inc. All rights reserved. _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com From owner-sqr-users@list.iex.net Thu Jan 3 12:44:45 2002 Date: Thu, 3 Jan 2002 11:37:46 -0600 From: "Shipley, Lisa A." Subject: FW: FW: date problems The problem has been resolved. I was running this program against our Kronos database. I knew I had gotten this to work in PeopleSoft. The difference was the init-Datetime was not in my Kronos program. Once I added that and a call to the curdttim.sqc, it worked beautifully. Thanks for all of the suggestions, they are greatly appreciated!!!!! -----Original Message----- From: Jerry Coleman [mailto:colemanj@WASHPOST.COM] Sent: Thursday, January 03, 2002 11:31 AM To: SQR-USERS@list.iex.net Subject: Re: FW: date problems Also, ask your DBA if he/she changed the NLS_DATE_FORMAT setting, either on the server or your workstation registry. |---------+----------------------------> | | "Shipley, Lisa | | | A." | | | | | | Sent by: | | | "Discussion of | | | SQR, Brio | | | Software's | | | database | | | reporting | | | language" | | | | | | | | | | | | 01/03/02 10:26 AM| | | Please respond to| | | sqr-users | | | | |---------+----------------------------> >--------------------------------------------------------------------------- -----------------------------------| | | | To: SQR-USERS@list.iex.net | | cc: | | Subject: FW: date problems | >--------------------------------------------------------------------------- -----------------------------------| I've changed the input mask to fit the conversion mask and it still gives me the same error. INPUT $EndDate maxlen=11 'Enter end date (DD-MON-YYYY)' IF rtrim($EndDate, ' ') = '' goto Done END-IF LET $end = strtodate($EndDate, 'DD-MON-YYYY') DISPLAY '$END ' NOLINE DISPLAY $END do convert-to-dtu-date($End,$ENDYMD) My display on $End looks good '30-DEC-2001' After the attempt at the dtu conversion, I still get 30--2001 with an invalid month error. -----Original Message----- From: the dragon [mailto:ceprn@hotmail.com] Sent: Thursday, January 03, 2002 9:14 AM To: sqr-users@list.iex.net Subject: Re: date problems Lisa, I don't have a lot of time to examine this completely, but, right off the bat, I can tell you Oracle will not see the date formats DD-Mon-YYYY and DD-MON-YYYY (31-Dec-2001 <> 31-DEC-2001) as the same thing. I think if you make the conversion mask the same as the input mask you will see different results. clark 'the dragon' willis dragon enterprises, consulting services "Doing it right the first time, at an affordable rate." PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Oracle 7.3.4 SQR 4.3.4 Good Afternoon, I'm trying to subtract 1 day from a value that a user keys in. I've done this before in other programs, but for some reason, I can't get it to work today. INPUT $BegDate 'Enter begin date (DD-Mon-YYYY)' type=char maxlen=11 IF rtrim($BegDate, ' ') = '' goto Done END-IF let $BDate = strtodate($BegDate, 'DD-MON-YYYY') DISPLAY '$BDate ' Noline Display $Bdate do convert-to-dtu-date($BDate,$DATE_OUT) The output for $DATE_OUT is 2001--24. It's leaving the month DEC out. I can't for the life of me figure out why. Any help is GREATLY appreciated!!!!! Lisa Shipley Senior Programmer Sumitomo Electric Wiring Systems, Inc. Phone: (270) 782-7397 Ext. 2226 PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) NOTICE: The information contained in this message is protected under United States and international copyright laws and is intended for the personal and confidential use of the addressee. If you are not the addressee or an agent of the addressee, you are hereby notified that you have received this message in error and that any review, dissemination, distribution, taking of any action in reliance upon or copying of this message without the express written permission of the sender or his agent is strictly prohibited and in violation of referenced statutes. If you have received this message in error, please notify me (the sender) immediately and you are instructed to delete this message from any computer it resides on, including mail servers. SIGNATURE : Do not meddle in the affairs of dragons, for you are crunchy and taste good with ketchup. You've got to be a Spirit; don't need no Ghosts. Do or Do Not; There is NO Try. Any clod can have facts, but having an opinion is an art ! A conclusion is simply the place where someone got tired of thinking. When a continuing state of defiance and disorder can not be checked by the rules, then new and sometimes drastic rules must be forged to maintain order; the alternative is anarchy. M. Clark Willis III - Sr Systems Analyst, Sr Consultant ceprn@hotmail.com aolim:ceprn ICQ 6633136 Help stamp out SPAM!! http://www.cauce.org The senders of unsolicited commercial e-mail to me at any site are liable for a $500 per message cost under USC 47, which may be found at http://www.law.cornell.edu/uscode/47 Contents of this message, in it's entirety, (c) 2000 M. Clark Willis III / Dragon Enterprises inc. All rights reserved. _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com From owner-sqr-users@list.iex.net Thu Jan 3 13:12:21 2002 Date: Thu, 3 Jan 2002 14:04:15 -0400 From: Peter Clark Subject: Re: date problems Betty, you beat me to the punch. I would wager that the culprit is SETENV.SQC. This sets several substitution variables for PeopleSoft date handling routines ... including Format-DateTime (in DateTime.sqc) which is invoked by the Convert-To-DTU-Date procedure in DateMath.sqc. Another possibility is that presumably (based on her use of the input command) Lisa's SQR is intended to run outside the PeopleSoft environment and is being run via SQRW. Lisa, is it possible that your command flags in SQRW are pointing to SQR.INI instead of PSSQR.INI (it is possible that these are not in synch)? This is where the SQR DB date format is defined (although I don't think your code would be dependant upon the DB date format). HTH, Peter >>> Betty Thompson 2002/01/03 1:06:21 pm >>> I'm still a beginner, so bear with me, please, if this sounds silly... Could you be missing some variable value that affects how the functions work? I shoved your stuff into a shell program and it worked fine (I only omitted the 'if' statement with the 'goto Done'). What I thought might be different is that I always use a shell with the same bunch of sqc includes. I built this shell after going to SQR class, and I never really look at it any more, but I think it sets a lot of variables regarding dates. I attached my test program and the log from running it. Good luck. Betty -----Original Message----- From: Discussion of SQR, Brio Software's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Shipley, Lisa A. Sent: Thursday, January 03, 2002 9:27 AM To: SQR-USERS@list.iex.net Subject: FW: date problems I've changed the input mask to fit the conversion mask and it still gives me the same error. INPUT $EndDate maxlen=11 'Enter end date (DD-MON-YYYY)' IF rtrim($EndDate, ' ') = '' goto Done END-IF LET $end = strtodate($EndDate, 'DD-MON-YYYY') DISPLAY '$END ' NOLINE DISPLAY $END do convert-to-dtu-date($End,$ENDYMD) My display on $End looks good '30-DEC-2001' After the attempt at the dtu conversion, I still get 30--2001 with an invalid month error. -----Original Message----- From: the dragon [mailto:ceprn@hotmail.com] Sent: Thursday, January 03, 2002 9:14 AM To: sqr-users@list.iex.net Subject: Re: date problems Lisa, I don't have a lot of time to examine this completely, but, right off the bat, I can tell you Oracle will not see the date formats DD-Mon-YYYY and DD-MON-YYYY (31-Dec-2001 <> 31-DEC-2001) as the same thing. I think if you make the conversion mask the same as the input mask you will see different results. clark 'the dragon' willis dragon enterprises, consulting services "Doing it right the first time, at an affordable rate." PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Oracle 7.3.4 SQR 4.3.4 Good Afternoon, I'm trying to subtract 1 day from a value that a user keys in. I've done this before in other programs, but for some reason, I can't get it to work today. INPUT $BegDate 'Enter begin date (DD-Mon-YYYY)' type=char maxlen=11 IF rtrim($BegDate, ' ') = '' goto Done END-IF let $BDate = strtodate($BegDate, 'DD-MON-YYYY') DISPLAY '$BDate ' Noline Display $Bdate do convert-to-dtu-date($BDate,$DATE_OUT) The output for $DATE_OUT is 2001--24. It's leaving the month DEC out. I can't for the life of me figure out why. Any help is GREATLY appreciated!!!!! Lisa Shipley Senior Programmer Sumitomo Electric Wiring Systems, Inc. Phone: (270) 782-7397 Ext. 2226 PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) NOTICE: The information contained in this message is protected under United States and international copyright laws and is intended for the personal and confidential use of the addressee. If you are not the addressee or an agent of the addressee, you are hereby notified that you have received this message in error and that any review, dissemination, distribution, taking of any action in reliance upon or copying of this message without the express written permission of the sender or his agent is strictly prohibited and in violation of referenced statutes. If you have received this message in error, please notify me (the sender) immediately and you are instructed to delete this message from any computer it resides on, including mail servers. SIGNATURE : Do not meddle in the affairs of dragons, for you are crunchy and taste good with ketchup. You've got to be a Spirit; don't need no Ghosts. Do or Do Not; There is NO Try. Any clod can have facts, but having an opinion is an art ! A conclusion is simply the place where someone got tired of thinking. When a continuing state of defiance and disorder can not be checked by the rules, then new and sometimes drastic rules must be forged to maintain order; the alternative is anarchy. M. Clark Willis III - Sr Systems Analyst, Sr Consultant ceprn@hotmail.com aolim:ceprn ICQ 6633136 Help stamp out SPAM!! http://www.cauce.org The senders of unsolicited commercial e-mail to me at any site are liable for a $500 per message cost under USC 47, which may be found at http://www.law.cornell.edu/uscode/47 Contents of this message, in it's entirety, (c) 2000 M. Clark Willis III / Dragon Enterprises inc. All rights reserved. _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com From owner-sqr-users@list.iex.net Thu Jan 3 14:42:49 2002 Date: Thu, 3 Jan 2002 11:36:03 -0800 From: Arun Kumar Subject: Re: date problems Lisa, By looking at your code you are in Peoplesoft environment. To get date from user, You can use sqc so that your code still stays independent of the the database. There are couple of procedures are already available for date input from user. 1.Get-As-Of-Date 2.Get-From-Thru-Dates Hope this helps Arun --- Peter Clark wrote: > Betty, you beat me to the punch. > > I would wager that the culprit is SETENV.SQC. This > sets several substitution variables for PeopleSoft > date handling routines ... including Format-DateTime > (in DateTime.sqc) which is invoked by the > Convert-To-DTU-Date procedure in DateMath.sqc. > > Another possibility is that presumably (based on her > use of the input command) Lisa's SQR is intended to > run outside the PeopleSoft environment and is being > run via SQRW. Lisa, is it possible that your command > flags in SQRW are pointing to SQR.INI instead of > PSSQR.INI (it is possible that these are not in > synch)? This is where the SQR DB date format is > defined (although I don't think your code would be > dependant upon the DB date format). > > HTH, Peter > > >>> Betty Thompson > 2002/01/03 1:06:21 pm >>> > I'm still a beginner, so bear with me, please, if > this sounds silly... > > Could you be missing some variable value that > affects how the functions > work? > > I shoved your stuff into a shell program and it > worked fine (I only omitted > the > 'if' statement with the 'goto Done'). > > What I thought might be different is that I always > use a shell with the same > bunch > of sqc includes. I built this shell after going to > SQR class, and I never > really > look at it any more, but I think it sets a lot of > variables regarding dates. > > I attached my test program and the log from running > it. > > Good luck. > Betty > > > -----Original Message----- > From: Discussion of SQR, Brio Software's database > reporting language > [mailto:SQR-USERS@list.iex.net]On Behalf Of Shipley, > Lisa A. > Sent: Thursday, January 03, 2002 9:27 AM > To: SQR-USERS@list.iex.net > Subject: FW: date problems > > > I've changed the input mask to fit the conversion > mask and it still gives me > the same error. > > INPUT $EndDate maxlen=11 'Enter end date > (DD-MON-YYYY)' > IF rtrim($EndDate, ' ') = '' > goto Done > END-IF > > > LET $end = strtodate($EndDate, 'DD-MON-YYYY') > DISPLAY '$END ' NOLINE > DISPLAY $END > > > > do convert-to-dtu-date($End,$ENDYMD) > > My display on $End looks good '30-DEC-2001' > After the attempt at the dtu conversion, I still get > 30--2001 with an > invalid month error. > > > > > -----Original Message----- > From: the dragon [mailto:ceprn@hotmail.com] > Sent: Thursday, January 03, 2002 9:14 AM > To: sqr-users@list.iex.net > Subject: Re: date problems > > > Lisa, > > I don't have a lot of time to examine this > completely, but, right off the > bat, I can tell you Oracle will not see the date > formats DD-Mon-YYYY and > DD-MON-YYYY (31-Dec-2001 <> 31-DEC-2001) as the same > thing. I think if you > make the conversion mask the same as the input mask > you will see different > results. > > clark 'the dragon' willis > dragon enterprises, consulting services > "Doing it right the first time, at an affordable > rate." > > PSA: Salary <> Slavery. If you earn a salary, your > employer is renting your > > services for 40 hours a week, not purchasing your > soul. Your time is the > only real finite asset that you have, and once used > it can never be > recovered, so don't waste it by giving it away. > > "Time is the coin of your life. It is the only coin > you > have, and only you can determine how it will be > spent. > Be careful lest you let other people spend it for > you." > > Carl Sandburg > (1878 - 1967) > > ----Original Message Follows---- > > Oracle 7.3.4 > SQR 4.3.4 > > Good Afternoon, > > I'm trying to subtract 1 day from a value that a > user keys in. I've done > this before in other programs, but for some reason, > I can't get it to work > today. > > INPUT $BegDate 'Enter begin date (DD-Mon-YYYY)' > type=char maxlen=11 > IF rtrim($BegDate, ' ') = '' > goto Done > END-IF > > let $BDate = strtodate($BegDate, 'DD-MON-YYYY') > DISPLAY '$BDate ' Noline > Display $Bdate > > do convert-to-dtu-date($BDate,$DATE_OUT) > > > > The output for $DATE_OUT is 2001--24. It's leaving > the month DEC out. I > can't for the life of me figure out why. > > Any help is GREATLY appreciated!!!!! > > Lisa Shipley > Senior Programmer > Sumitomo Electric Wiring Systems, Inc. > Phone: (270) 782-7397 Ext. 2226 > > > > > > > > > > PSA: Salary <> Slavery. If you earn a salary, your > employer is renting your > > services for 40 hours a week, not purchasing your > soul. Your time is the > only real finite asset that you have, and once used > it can never be > recovered, so don't waste it by giving it away. > > "Time is the coin of your life. It is the only coin > you > have, and only you can determine how it will be > spent. > Be careful lest you let other people spend it for > you." > > Carl Sandburg > (1878 - 1967) > > NOTICE: The information contained in this message > is protected under United > > States and international copyright laws and is > intended for the personal and > > === message truncated === __________________________________________________ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com From owner-sqr-users@list.iex.net Thu Jan 3 15:34:09 2002 Date: Thu, 3 Jan 2002 15:27:58 -0500 From: Ray Ontko Subject: Re: Images in UNIX SQR reports Bruce, et al, The hpgl image can only be used with "-printer:hp". If you want a PDF output file, you need to use GIF-FILE or JPEG-FILE, and "-printer:pd" or "-printer:ep". PDF support was added with SQR 4.3.2.2. Ray [Charset iso-8859-1 unsupported, filtering to ASCII...] > Great suggestions. This is exactly what I have been trying, but still no > image, even after using the bmp to hpg converter. > > Do you know if an ADOBE pdf file can be created on UNIX with an image? > > Any other possibilities to check? > > Thanks, > > Bruce Kelling > PeopleSoft Developer > AdvanTech SolutionsSM > > > > > -----Original Message----- > From: Steve Wowelko [mailto:SAWOWELK@SYR.EDU] > Sent: Thursday, January 03, 2002 9:41 AM > To: SQR-USERS@list.iex.net > Subject: Re: Images in UNIX SQR reports > > > Hi Bruce, > > I've spent weeks trying to get this to work. > I finally did get it to work. > > Here's what I had to do- > > Declare your printer as an HP printer. I used a PeopleSoft supplied .sqc: > #include 'setup31.sqc' !Portrait HP Printer > > Declare your image as an HPGL image: > declare-image A1 > type=HPGL-FILE > source='/opt/psoft/syracuse/hrsa750/sqr/iofiles/registr/signature.hpg' ! > location on UNIX server > image-size=(40,6) > end-declare > > Then just print the image: > print-image A1 (66,8) > > The real (frustrating) problem is creating an HPGL file that SQR likes. > I have tried various graphic packages to do this to no avail. > There is a SQR that will convert a .bmp file to an .hpg (HPGL) format. > It is found at the following web site: > http://www.ontko.com/sqr/bmp_to_hpg.sqr > > It is shareware written by Ray Ontko. It does a wonderful job converting > images. (thank you Ray!) > > Hope this helps. > > Stephen Wowelko, EDP > Syracuse University - Information Systems > > > > >>> jwillson@DSSLTD.COM 01/02/02 02:12AM >>> > Hi Bruce. See the print-image command. Note that on UNIX only reports I > have > only used this command with postscript reports. So before invoking the > command > I also do an image sizing procedure to ensure the image is scaled (with an > aspect > ratio) into the area that is being printed. I no longer have a copy of UNIX > based SQR to test this on and provide examples; however, I can confirm that > SQRs developed under WINNT BR 6 using postscript and nonpostscript when run > on UNIX BR 6 just execute faster and print the same. (both gif and jpg. I > don't know about bmp) So write and debug with NT and run production with > UNIX > > > Hope this helps. > > John Willson > > Another approach > > graphic box somesize > print-image > type= gif-file > source = 'myimage.gif' > image-size = somesize > http://netwinsite.com/dbabble/ > ---------------------------------------------------------------------- Ray Ontko rayo@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ From owner-sqr-users@list.iex.net Thu Jan 3 16:52:19 2002 Date: Thu, 3 Jan 2002 16:42:52 -0500 From: Bruce Kelling Subject: Re: Images in UNIX SQR reports Thanks everyone, it works. After numerous trial and errors, I can verify that Ray has clarified the key parts I was stumbling on. By the way, the bmp to hpg utility did produce a hpgl image type that did print OK in a UNIX run sqr. We really needed a PDF, and both the gif and jpeg images work great and don't require any major code changes. Bruce -----Original Message----- From: Ray Ontko [mailto:rayo@ONTKO.COM] Sent: Thursday, January 03, 2002 3:28 PM To: SQR-USERS@list.iex.net Subject: Re: Images in UNIX SQR reports Bruce, et al, The hpgl image can only be used with "-printer:hp". If you want a PDF output file, you need to use GIF-FILE or JPEG-FILE, and "-printer:pd" or "-printer:ep". PDF support was added with SQR 4.3.2.2. Ray [Charset iso-8859-1 unsupported, filtering to ASCII...] > Great suggestions. This is exactly what I have been trying, but still no > image, even after using the bmp to hpg converter. > > Do you know if an ADOBE pdf file can be created on UNIX with an image? > > Any other possibilities to check? > > Thanks, > > Bruce Kelling > PeopleSoft Developer > AdvanTech SolutionsSM > > > > > -----Original Message----- > From: Steve Wowelko [mailto:SAWOWELK@SYR.EDU] > Sent: Thursday, January 03, 2002 9:41 AM > To: SQR-USERS@list.iex.net > Subject: Re: Images in UNIX SQR reports > > > Hi Bruce, > > I've spent weeks trying to get this to work. > I finally did get it to work. > > Here's what I had to do- > > Declare your printer as an HP printer. I used a PeopleSoft supplied .sqc: > #include 'setup31.sqc' !Portrait HP Printer > > Declare your image as an HPGL image: > declare-image A1 > type=HPGL-FILE > source='/opt/psoft/syracuse/hrsa750/sqr/iofiles/registr/signature.hpg' ! > location on UNIX server > image-size=(40,6) > end-declare > > Then just print the image: > print-image A1 (66,8) > > The real (frustrating) problem is creating an HPGL file that SQR likes. > I have tried various graphic packages to do this to no avail. > There is a SQR that will convert a .bmp file to an .hpg (HPGL) format. > It is found at the following web site: > http://www.ontko.com/sqr/bmp_to_hpg.sqr > > It is shareware written by Ray Ontko. It does a wonderful job converting > images. (thank you Ray!) > > Hope this helps. > > Stephen Wowelko, EDP > Syracuse University - Information Systems > > > > >>> jwillson@DSSLTD.COM 01/02/02 02:12AM >>> > Hi Bruce. See the print-image command. Note that on UNIX only reports I > have > only used this command with postscript reports. So before invoking the > command > I also do an image sizing procedure to ensure the image is scaled (with an > aspect > ratio) into the area that is being printed. I no longer have a copy of UNIX > based SQR to test this on and provide examples; however, I can confirm that > SQRs developed under WINNT BR 6 using postscript and nonpostscript when run > on UNIX BR 6 just execute faster and print the same. (both gif and jpg. I > don't know about bmp) So write and debug with NT and run production with > UNIX > > > Hope this helps. > > John Willson > > Another approach > > graphic box somesize > print-image > type= gif-file > source = 'myimage.gif' > image-size = somesize > http://netwinsite.com/dbabble/ > ---------------------------------------------------------------------- Ray Ontko rayo@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ From owner-sqr-users@list.iex.net Thu Jan 3 18:42:33 2002 Date: Thu, 3 Jan 2002 18:38:48 -0500 From: Jason Rupp Subject: Sql Count Hello All: I am trying to do a count - Select count(*) - in sqr and move the value to a variable to be used later. This is how I did it: Begin-sql count(*) &Count FROM PS_JOB End-Sql What am I doing wrong? Thanks for the help!! From owner-sqr-users@list.iex.net Thu Jan 3 19:00:45 2002 Date: Thu, 3 Jan 2002 17:55:08 -0600 From: Betty Thompson Subject: Re: Sql Count Tell it you want to 'select' -----Original Message----- From: Discussion of SQR, Brio Software's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Jason Rupp Sent: Thursday, January 03, 2002 5:39 PM To: SQR-USERS@list.iex.net Subject: Sql Count Hello All: I am trying to do a count - Select count(*) - in sqr and move the value to a variable to be used later. This is how I did it: Begin-sql count(*) &Count FROM PS_JOB End-Sql What am I doing wrong? Thanks for the help!! From owner-sqr-users@list.iex.net Thu Jan 3 19:17:14 2002 Date: Thu, 3 Jan 2002 16:11:02 -0800 From: Allen Cunningham Subject: Re: Sql Count You need a select statement in there, but cannot use one inside the sql-paragraph. Use a begin-select instead. ac -----Original Message----- From: Discussion of SQR, Brio Software's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Jason Rupp Sent: Thursday, January 03, 2002 3:39 PM To: SQR-USERS@list.iex.net Subject: Sql Count Hello All: I am trying to do a count - Select count(*) - in sqr and move the value to a variable to be used later. This is how I did it: Begin-sql count(*) &Count FROM PS_JOB End-Sql What am I doing wrong? Thanks for the help!! From owner-sqr-users@list.iex.net Thu Jan 3 19:41:33 2002 Date: Fri, 4 Jan 2002 11:35:55 +1100 From: Ian Mills Subject: Re: Sql Count Try the following begin-select count(*) &Count let #var = &count FROM PS_JOB end-select Regards, Ian Mills Analyst Programmer ORIX Australia Pty Ltd >>> jrupp@TECHNEGLAS.COM 04/01/2002 10:38:48 am >>> Hello All: I am trying to do a count - Select count(*) - in sqr and move the value to a variable to be used later. This is how I did it: Begin-sql count(*) &Count FROM PS_JOB End-Sql What am I doing wrong? Thanks for the help!! From owner-sqr-users@list.iex.net Thu Jan 3 19:43:32 2002 Date: Thu, 3 Jan 2002 16:38:14 -0800 From: Les Hancock Subject: Re: Sql Count Jason: Try this: begin-select count(*) &count from ps_job end-select Hope that works. Les --- Jason Rupp wrote: > Hello All: > > I am trying to do a count - Select count(*) - in sqr > and move the value > to a variable to be used later. This is how I did > it: > > Begin-sql > count(*) &Count > FROM PS_JOB > End-Sql > > What am I doing wrong? > > Thanks for the help!! __________________________________________________ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com From owner-sqr-users@list.iex.net Thu Jan 3 19:54:15 2002 Date: Thu, 3 Jan 2002 18:48:13 -0600 From: the dragon Subject: Re: Sql Count begin and end select, not sql clark 'the dragon' willis dragon enterprises, sonsulting Doing it right the first time, for less. PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Hello All: I am trying to do a count - Select count(*) - in sqr and move the value to a variable to be used later. This is how I did it: Begin-sql count(*) &Count FROM PS_JOB End-Sql What am I doing wrong? Thanks for the help!! _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com From owner-sqr-users@list.iex.net Thu Jan 3 20:46:21 2002 Date: Thu, 3 Jan 2002 17:41:20 -0800 From: Ganta Subject: Re: Sql Count Hi, Just do like this Begin-select count(*) &Count FROM PS_JOB End-Select Bye Ganta --- Jason Rupp wrote: > Hello All: > > I am trying to do a count - Select count(*) - in sqr > and move the value > to a variable to be used later. This is how I did > it: > > Begin-sql > count(*) &Count > FROM PS_JOB > End-Sql > > What am I doing wrong? > > Thanks for the help!! ===== __________________________________________________ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com From owner-sqr-users@list.iex.net Thu Jan 3 21:48:34 2002 Date: Thu, 3 Jan 2002 18:43:14 -0800 From: David Thorburn Subject: Re: Sql Count Jason, You are presently using the begin-Select - end-Select syntax structure within a begin-SQL - end-SQL construct. Use a procedure with a begin-Select - end-Select structure and the &variable will be correctly populated. The begin-SQL - end-SQL is only for 'pure SQL' syntax constructs. Additionally, don't forget to qualify effective-dated records so the only 'current' rows get counted if that is your wish. You will find numerous examples of effdt/effseq in the selects contained in PeopleSoft delivered SQR's. Regards, David ----- Original Message ----- From: "Jason Rupp" To: Sent: Thursday, January 03, 2002 3:38 PM Subject: Sql Count > Hello All: > > I am trying to do a count - Select count(*) - in sqr and move the value > to a variable to be used later. This is how I did it: > > Begin-sql > count(*) &Count > FROM PS_JOB > End-Sql > > What am I doing wrong? > > Thanks for the help!! > From owner-sqr-users@list.iex.net Thu Jan 3 22:16:18 2002 Date: Thu, 3 Jan 2002 22:12:22 -0500 From: Jason Rupp Subject: Re: Sql Count SOLVED!! Thank you everyone! The Problem is Solved ----- Original Message ----- From: "Jason Rupp" To: Sent: Thursday, January 03, 2002 3:38 PM Subject: Sql Count > Hello All: > > I am trying to do a count - Select count(*) - in sqr and move the value > to a variable to be used later. This is how I did it: > > Begin-sql > count(*) &Count > FROM PS_JOB > End-Sql > > What am I doing wrong? > > Thanks for the help!! > From owner-sqr-users@list.iex.net Fri Jan 4 00:21:44 2002 Date: Fri, 4 Jan 2002 16:15:38 +1100 From: Ian Mills Subject: Adding Style Sheets to an SQR Report Can anyone help? I have an SQR report that is run on Brio Portal that produces an HTML output. I tried to add the following code to my report so that I can use style sheets to set my fonts for the HTML output. When I add this code, the report will no longer work when I try to run it on the Portal. When I comment it out, the report runs fine. Is there something obvious here to anyone that I am doing wrong? begin-program do html_on let $temp1 = '}' ! let $temp = 'LP_044 - Reference Report' let $temp = '' do html_set_head_tags($temp) ...etc Regards, Ian Mills From owner-sqr-users@list.iex.net Fri Jan 4 06:28:39 2002 Date: Fri, 4 Jan 2002 06:21:51 -0500 From: Jeffrey Bedell Subject: Re: Sql Count You forgot the SELECT statement. Jeffrey K. Bedell Senior Systems Analyst Information Systems Syracuse University (315) 443-9273 >>> jrupp@TECHNEGLAS.COM 01/03/02 06:38PM >>> Hello All: I am trying to do a count - Select count(*) - in sqr and move the value to a variable to be used later. This is how I did it: Begin-sql count(*) &Count FROM PS_JOB End-Sql What am I doing wrong? Thanks for the help!! From owner-sqr-users@list.iex.net Fri Jan 4 06:36:32 2002 Date: Fri, 4 Jan 2002 22:30:41 +1100 From: jarrodb Subject: Re: Adding Style Sheets to an SQR Report Does it run ok outside of the portal? If so check out what the html_set_head_tags actually outputs with regards to your temp string. You will probably find that your temp string is in the midst of the title that the html_set_head_tags is doing. ie you will probably end up with something like this. <STYLE type="text/css"><!!-- .bigHeading {....</STYLE> I remember also having problems with the squiggle brackets so I did this Let $LeftSquiggle = Chr(123) Let $RightSquiggle = Chr(125) if you have a look at the html.inc file you will find. begin-procedure html_set_head_tags($tags) let $outtag = '%%HEADTAGS=' || $tags print $outtag () code-printer=ht end-procedure ! html_set_head_tags I still haven't found out where or how the %%HEADTAGS is set. If you find out please let me know! This is what I ended up doing. Let $Title = $ReportID || ' - ' || $ReportName Let $CSSLink = 'rel="stylesheet" type="text/css" href="MyCSS.css"' Let $ExtraStyleTags = 'p.page' || chr(9) || Chr(123) || 'page-break-after:always' || Chr(125) Do html_set_head_tags($Title) Do html_CSS_link($CSSLink) Do html_extraStyle($ExtraStyleTags) Do html_extraStyle_end begin-procedure html_extraStyle($tags) if $tags = '' print '' () code-printer=ht end-procedure begin-procedure html_CSS_link($tags) if $tags = '' print '' () code-printer=ht else let $outtag = '' print $outtag () code-printer=ht end-if end-procedure I hope this helps. Try cutting and pasting but I can't guarentee anything as it was copied from an old version of a program I had lying around. Always test and retest it outside the portal first. We ended up simply writing programs to generate the html files outside of the portal and them load them using the OneAPI. For us it was a better o