From owner-sqr-users@list.iex.net Sat Jan 1 00:19:20 2000 Date: Sat, 1 Jan 2000 00:00:01 -0500 From: Nathan Stratton Treadway Subject: Monthly sqr-users Hints Posting sqr-users Mailing List Hints and Guidelines Nathan Stratton Treadway, Ray Ontko & Co. (nathant@ontko.com) $Revision: 1.5 $ $Date: 1999-08-31 18:59:00-04 $ This document gathers in one location information about the sqr-users mail list. Directions for common list-server commands (including unsubscribing) are given, as are guidelines for list usage. ______________________________________________________________________ Table of Contents 1. Changes Since Previous Version 2. Introduction 2.1 sqr-users Mailing List 2.2 sqr-users Hints and Guidelines Document 2.3 Related Mailing Lists 3. Basic List Server Commands 3.1 Subscribing to the List 3.2 Unsubscribing from the List 3.3 Digests 3.4 Problems 4. Posting to the sqr-users List 4.1 General Guidelines 4.2 Posting a Message 4.3 Replying to a Message 5. Job Announcements ______________________________________________________________________ 1. Changes Since Previous Version Changes since the version dated 1999/04/30: o Reflected the takeover of SQRIBE Technologies by Brio Technology and the resulting new product names (throughout document). o Added additional hints to the "Posting to the sqr-users List" section. 2. Introduction 2.1. sqr-users Mailing List The sqr-users mailing list was created to enable discussion related to the SQR database language from Brio Technology (and to other products in the Brio.Report line). Note: SQR used to be published by SQRIBE Technologies, which was merged into Brio Technology on August 3, 1999. The Brio website has more information on the merger. The mailing list is provided as a service of Ray Ontko & Co. . A searchable archive of past postings to the mailing list is available from the SQR Users Group web site . 2.2. sqr-users Hints and Guidelines Document This document gives various hints and guidelines about the sqr-users mailing list. It will be posted approximately monthly to the mailing list so that new users can see it (and existing users can find it easily). An HTML version of the document is always available at http://www.sqrug.com/sqr-users/sqr-users-hints.html. If you have comments or suggestions about this document, please contact me directly at the address listed in the title section. This document is (C)Copyright 1999 by Ray Ontko & Co. It may be freely copied and distributed provided it is not modified in any way and it retains the original copyright notice. 2.3. Related Mailing Lists psusers : PeopleSoft Users For questions related to any aspect of PeopleSoft (including PeopleSoft-specific SQR issues). To join, follow the link above, or send any message to "psusers-subscribe@egroups.com" . rm-users : ReportMart Users List for discussion of Brio.Portal (previously called ReportMart). To join, follow the link above, or send a message containing the word "subscribe" in the body to "rm-users- request@sqrug.com". 3. Basic List Server Commands Note: The list used to be hosted on usa.net , but the list-hosting service was moved to list.iex.net . The old addresses for the list, list server, and list owner no longer work. A few basic list server commands are listed below. Send these commands as the only line in the body (not the subject line) of an e- mail message sent to "listserv@list.iex.net". 3.1. Subscribing to the List To subscribe to the mailing list, the command is subscribe sqr-users Your Name Note that you do not need to provide your e-mail address as it is taken from your message's header. You will be e-mailed a confirmation number, which you must then send back to the list server software before the command goes into effect. 3.2. Unsubscribing from the List To unsubscribe, the command is simply unsubscribe sqr-users Once again, you will need to confirm your command before it goes into effect. 3.3. Digests Once you are subscribed, you can request to get your messages in digest form (one large message containing all of the posts made each day) by sending the command set sqr-users digests If you use digests you should not just "reply" to the digest mailing. Instead, be sure your message's subject header matches the subject in the original posting to which you are replying, and that you don't include a quoted copy of the entire digest in your post. Use "nodigests" instead of "digests" to restore normal distribution. 3.4. Problems If the above commands do not work, please contact the list manager at "sqr-users-request@list.iex.net". (Do not send a message to the list itself -- no one there can help you with your problem!) Please include a copy of the error message you received from the list server. 4. Posting to the sqr-users List In order to post to the mailing list, you must be subscribed to it (see directions above). 4.1. General Guidelines For any message you send to the list, please: o make sure your mail software is not requesting a "Return Receipt". (If a "Return Receipt Requested" message is sent to the list, several dozen receipt messages will be sent out to the mailing list in reply from other subscribers.) o do not send messages in HTML or other special formats. (These are not usable by many subscribers, especially those who receive their messages in digest format.) o keep in mind that over 500 people will receive your message, and that it will appear in the list archives. Try to keep your messages on-topic and relatively short. Consider sending your message directly to particular people if it won't interest many of the list's subscribers. 4.2. Posting a Message Once you are subscribed, you can post to the list by sending a message to "sqr-users@list.iex.net". Be sure your subject heading describes your specific problem or question (i.e. don't just use "SQR Question"). In the body of your message, please include the following information: o Brio product and version number o Operating system and version number o Database name and version number o Application name (i.e. PeopleSoft) and a version number, if any Also, include a short code sample whenever possible. It's much easier for other people to understand what you are trying to do when they can see the actual code. (At the same time, be careful not to post confidential or proprietary code, since the posting will be placed in a public web archive.) Note that your question should relate to SQR or other Brio Report product in some way. Don't ask questions about PeopleSoft, for example, unless you are having SQR-related issues. To find out your version of SQR, you can run the following program: begin-program show $sqr-ver end-program This will produce a line that looks something like this: SQR/3.0.15/Intel/SCO Unix R3.2 V5.0/Oracle 7.2.2.3/Sep 25 1996 Include the full line of output in your message. Note that the oper- ating system version number listed here is the one under which this copy of SQR was compiled, so you'll still need to include your own information. 4.3. Replying to a Message Messages sent out on the list have a Reply-To header pointing to the list. This means that you should be able to simply use your mail reader's "reply" function to send a reply to the list. Generally, all answers to questions sent out on the list should be public replies, so that other subscribers can benefit. In those cases where a private reply is appropriate, be sure to over-ride the default Reply-To address. If your message is not actually a reply to the earlier message, please do not use the "reply" function. Instead, address a new e-mail message to the list as described in the previous section. (This is because the list archives will incorrectly show the new message in the original thread if you use "reply".) You should quote enough lines from the original message that later readers can understand your answer even if they missed the original question. At the same time, you should remove any unnecessary lines from the quote in order to make your message shorter and easier to understand. (Remember that some people read the mailing list in digest form, and the digests become much larger if unnecessary lines are quoted.) In particular, in order to prevent mail loops, the list server will not accept messages that contain From:, Sender:, etc. lines pointing back to the sqr-users list, even if these lines are quoted (i.e. with ">" characters). Be sure to delete these from your reply message before sending it. 5. Job Announcements SQR-related job announcements are currently allowed on the list, subject to the following restrictions: o The subject line must begin with the words "JOB ANNOUNCEMENT:". o The message should be very short (fewer than 20 lines), giving brief details of the job and a way for those interested to get more information directly (i.e. web page or phone number). o The message should specifically remind people interested in the job to respond directly to the message author (and not to use their mailer's "reply" function, since that would send the reply out on the list). o Post job announcements as infrequently as possible. From owner-sqr-users@list.iex.net Mon Jan 3 13:07:42 2000 Date: Mon, 3 Jan 2000 10:17:05 -0700 From: Brad Blake Subject: sqr page break I am trying to write a report that the client will end up importing into Excel, so it needs to have no page breaks, and no headers. to eliminate the page breaks, I used the following: declare-layout default formfeed=no bottom-margin=0 top-margin=0 orientation=landscape end-declare This eliminates the page breaks, but in viewing the output .lis file, there is still one blank line inserted between each page. How do I eliminate this?? Thanks in advance- Brad Blake bblake@sandmonk.com From owner-sqr-users@list.iex.net Mon Jan 3 13:07:42 2000 Date: Mon, 3 Jan 2000 11:28:53 -0600 From: KBLUMEN@SEARS.COM Subject: Re: sqr page break --0__=FjfdRudwUpQtn6P5AqkAsJj1Von35Dlm4WhSdDqcuc57mT2DvfsUJi0T Content-type: text/plain; charset=us-ascii Content-Disposition: inline Did you try importing the file into Excel to see what happens? The blank line may not cause a problem. It could be that it just shows up that way in the .lis file. (Embedded image moved Brad Blake to file: 01/03/2000 11:17 AM pic07921.pcx) Please respond to sqr-users@list.iex.net To: SQR-USERS@list.iex.net cc: (bcc: Kimberly Blumenberg) Subject: sqr page break I am trying to write a report that the client will end up importing into Excel, so it needs to have no page breaks, and no headers. to eliminate the page breaks, I used the following: declare-layout default formfeed=no bottom-margin=0 top-margin=0 orientation=landscape end-declare This eliminates the page breaks, but in viewing the output .lis file, there is still one blank line inserted between each page. How do I eliminate this?? Thanks in advance- Brad Blake bblake@sandmonk.com --0__=FjfdRudwUpQtn6P5AqkAsJj1Von35Dlm4WhSdDqcuc57mT2DvfsUJi0T Content-type: application/octet-stream; name="pic07921.pcx" Content-Disposition: attachment; filename="pic07921.pcx" Content-transfer-encoding: base64 CgUBCAAAAABoACwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAABaQABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAD1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPH E8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sT zRPHE8MTwhPwEwzIBgzYE8wTxhPDE8IT7hPOBtcTzBPGE8MTE+wTwgbCBwbCEgbCEgbCEsUG1hPL E8YTwxMT6hMMwgYHwgLCAwISwgfEEsMCwwbVE8sTxRPDExPpE8MGAwcCBwMCwhLDB8ISwgISwgLD BtUTyhPFE8MTE+gTwgIHA8ICEw4DDgLDE8USwwLCEMIG1BPKE8UTwxMT5xMCAwcDAg4TDgITwgIS D8ISD8ISBRICEcICwwbUE8oTxRPCExPmEwYCBwMCDgIOwgLDExITEhPCEg8GxgLDBtMMDAfJE8QT whMT5hMGwwITBgMCDhLFEw8SE8ISBgIDwhIDEsMGB9MDxwwHxRPDExPlEwYHAhESAg8CwhMPwhMP xBMPxRIQwgIDAgMCBtMDxwPEDAfDE8IT4RMHwwzCBgLCEhMCDxLIE8MSD8MSwwIQAwIDBgfSDMkD wgPCDAfCExPbEwfGDMIDDAIHERITEhMSwxMPwxMPwxPDEgIDAgMCwwMCBgzREwfHDMYDDMITE9YT B8UMyAMGB8ICBhLDAsYTEhMSExIPwhIHAgcCAwUQAgYRBgfSE8UTB8QMwgMMwhMT0hMHxAzLA8IM BsISDxESExITAw4DxBMSExITwxICBwPCAsMDDMIGB9ITyRMHwwzCExPPEwfDDMkDxQwHwhMGBxIT AhECEwMOAg7DExITDxMPwxIDAgMCBwMCDAYRBgfSE8kTwhPCDMITE8wTB8MMxwPEDMIHxxMGxBLD Ag4DDgIGwg/IEgIDwgIDAgwCEMIGB9ITyRMHDAcMwhMTyhMHwgzGA8MMwgfMEwYHwhLCEAIOAg4C DhDDAhIPxhIFAgXDAgUCEQYH0hPHEwfCDAcPDMITE8gTB8IMxQPDDAfQEwbDEhDEAhAOEA4QwgLG EgcSBhIGBcMCBcIGB9ATB8UMEwfCDA8HDwwHwhMTxhMHwgzEA8MMB9MTBgfCEhADEMICDhAOEMIC EQIDxxIGBwbCAgUCEQYHyxMHxAwHwhMHEwzCEwcPBw8MB8MTE8UTBwzEA8IMB9YTBsQSEAMCA8UC EQIDAgPDEgcSBgfCBgUQAhDCBgfGEwfEDAfGE8INEwzCEw8HwgwHwxPCE8QTBwzDA8IMB9gTBgfE EhACEMYCEQIDAsQSBhLDBsICEALCBgfCEwfDDAfKEwfCDRMHwhPCDAfEE8ITE8MTBwzCA8IMB9oT DBIHwxLDDBEDxQIDAgPDEgYSBgfCBgIQAhAGDAfCEwzDE8MHyRMHwhPCBxMHxRPDExPDEwzCAwwH 3RMGxxICEQPDAgMCA8MSBhIGBwYMBhACEAIGDMMTDBPCB8YTwwfHEwfGE8MTwhPDEwwDDAfeEwYH xxICEQPDAgMCwhIGEgYHBgwGEAIQAsIGB8MTDMYTwwfKEwzGE8MTwhPDE8IMB98TDBLCB8USAgMR xAISB8ISBgcGDAYQBhAGEAYMB8MMB8kTwwfHEwzGE8MTwhPDEwwPwgzfEwYSB8ISB8ISAhECAwID EgcSBwYHBgwGEAYQxgzDD8IHxRPDB8kTBwzGE8MTwhPDEwzDD8QM3BPCBhIGwxIGAhECAwIHBgcG yAzJDxMHzRMHwwwHxxPDE8ITwxMHDMYPxwwH1BMGEgYSBhLLDM4PwwwTDMcTwgfEDAfJE8QTwhMT xBMHwgzLD9sM0w/GDAfDEwzDEwfEDAfLE8YTwxMTxhMHxAztD8gMBgfIE8QMB84TxxPDE8ITyhMH xwzbD8sMEAUMBcIMwgYH1RPKE8UTwxMT0RMH2wwGEAYQBhACBQwFDAUMBgwHBgfWE8sTxRPDExPu EwYMBhAGEAIGDAYMwwYH1xPLE8YTwxMT8BPKBgfYE8wTxhPDExP1E9sTzRPHE8MTwhP1E9sTzRPH E8MTwhMMAAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD/ /wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8A AAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A //8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAA AP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA /wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCk gICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vw oKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw //vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzA psrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDA wNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICA wMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACA AICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACA gACA//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP////// --0__=FjfdRudwUpQtn6P5AqkAsJj1Von35Dlm4WhSdDqcuc57mT2DvfsUJi0T-- From owner-sqr-users@list.iex.net Mon Jan 3 13:10:35 2000 Date: Mon, 3 Jan 2000 17:44:22 GMT From: data files Subject: Re: sqr page break Brad, Just a thought - If you wrote the report to a flat file, instead of a .lis file, you would have more control over the formatting. To accomplish, put this in your main procedure: open c:\temp\myfile.txt as 1 for-writing record=200 !this line declares the max width of the file Then, in your procedure where you would type: print $variable1 (,1,20) print $variable2 (,25,10) instead type: let $spacer = 5 write 1 from $variable1:20 write 1 from $spacer:5 write 1 from $variable2:10 This will print $variable1 starting at position 1 for a length of 20, skip 5 spaces, then $variable2 starting at position 25 for a length of 10. Each time the system goes through the select loop, it automatically drops down one line. Melissia ---------------------- Melissia D. Dembrosky Technical Consultant MBH Consulting 770-998-2323 >From: Brad Blake >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: sqr page break >Date: Mon, 3 Jan 2000 10:17:05 -0700 > >I am trying to write a report that the client will end up importing into >Excel, so it needs to have no page breaks, and no headers. to eliminate >the >page breaks, I used the following: > >declare-layout default >formfeed=no >bottom-margin=0 >top-margin=0 >orientation=landscape >end-declare > >This eliminates the page breaks, but in viewing the output .lis file, there >is still one blank line inserted between each page. How do I eliminate >this?? > >Thanks in advance- >Brad Blake >bblake@sandmonk.com ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Mon Jan 3 13:17:15 2000 Date: Mon, 3 Jan 2000 12:57:30 -0500 From: Mark Risman Subject: Re: sqr page break Have you tried setting the max-lines parameter within SQR? When I set it to a large number such as 999, I don't get any blank lines. - Mark -----Original Message----- From: Brad Blake [mailto:bblake@SANDMONK.COM] Sent: Monday, January 03, 2000 12:17 PM To: SQR-USERS@list.iex.net Subject: sqr page break I am trying to write a report that the client will end up importing into Excel, so it needs to have no page breaks, and no headers. to eliminate the page breaks, I used the following: declare-layout default formfeed=no bottom-margin=0 top-margin=0 orientation=landscape end-declare This eliminates the page breaks, but in viewing the output .lis file, there is still one blank line inserted between each page. How do I eliminate this?? Thanks in advance- Brad Blake bblake@sandmonk.com From owner-sqr-users@list.iex.net Mon Jan 3 13:24:12 2000 Date: Mon, 3 Jan 2000 13:07:56 -0500 From: "Schutz, Jay" Subject: Re: sqr page break How would you get a .lis file into excel anyway? I have excel97 SR-2, and I can't get a .lis file in there. Thanks, Jay R Schutz Toys "R" Us - HR Systems (201)986-8546 SchutzJ@toysrus.com "C code...C code run...Run, code, RUN!" > -----Original Message----- > From: data files [SMTP:transmit20@HOTMAIL.COM] > Sent: Monday, January 03, 2000 12:44 PM > To: SQR-USERS@list.iex.net > Subject: Re: sqr page break > > Brad, > > Just a thought - If you wrote the report to a flat file, instead of a .lis > file, you would have more control over the formatting. > > To accomplish, put this in your main procedure: > > open c:\temp\myfile.txt as 1 > for-writing > record=200 !this line declares the max width of the file > > Then, in your procedure where you would type: > print $variable1 (,1,20) > print $variable2 (,25,10) > > instead type: > let $spacer = 5 > write 1 from $variable1:20 > write 1 from $spacer:5 > write 1 from $variable2:10 > > This will print $variable1 starting at position 1 for a length of 20, skip > 5 > spaces, then $variable2 starting at position 25 for a length of 10. Each > time the system goes through the select loop, it automatically drops down > one line. > > Melissia > ---------------------- > Melissia D. Dembrosky > Technical Consultant > MBH Consulting > 770-998-2323 > > > >From: Brad Blake > >Reply-To: sqr-users@list.iex.net > >To: SQR-USERS@list.iex.net > >Subject: sqr page break > >Date: Mon, 3 Jan 2000 10:17:05 -0700 > > > >I am trying to write a report that the client will end up importing into > >Excel, so it needs to have no page breaks, and no headers. to eliminate > >the > >page breaks, I used the following: > > > >declare-layout default > >formfeed=no > >bottom-margin=0 > >top-margin=0 > >orientation=landscape > >end-declare > > > >This eliminates the page breaks, but in viewing the output .lis file, > there > >is still one blank line inserted between each page. How do I eliminate > >this?? > > > >Thanks in advance- > >Brad Blake > >bblake@sandmonk.com > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Mon Jan 3 15:52:16 2000 Date: Mon, 3 Jan 2000 13:59:31 -0600 From: Wes Williams Subject: Re: sqr page break Brad try this.. where the 297 is the total length of your file, adjust accordingly . begin-setup page-size 1 0297 no-formfeed end-setup Wes Williams Hamilton Sundstrand wes.williams@hs.utc.com >>> Brad Blake 01/03 11:17 AM >>> I am trying to write a report that the client will end up importing into Excel, so it needs to have no page breaks, and no headers. to eliminate the page breaks, I used the following: declare-layout default formfeed=no bottom-margin=0 top-margin=0 orientation=landscape end-declare This eliminates the page breaks, but in viewing the output .lis file, there is still one blank line inserted between each page. How do I eliminate this?? Thanks in advance- Brad Blake bblake@sandmonk.com ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** From owner-sqr-users@list.iex.net Mon Jan 3 18:27:23 2000 Date: Mon, 3 Jan 2000 17:00:26 -0600 From: "Robert (A) Cole" Subject: SQR interactive internet capabilities I would like to use SQR to build interactive web sites and would like to see some HTML code examples (links). I have used SQR to write out HTML files, but now I would like to examples of coding queries to the database and displaying the results. I'm looking for something simplier than a PowerBuilder type solution, and I haven't seen anything that the Brio Portal product can deliver on this. Thanks From owner-sqr-users@list.iex.net Tue Jan 4 04:41:23 2000 Date: Tue, 4 Jan 2000 09:25:50 +0000 From: Colin A Faith Subject: Re: SQR Editors? You should try Textpad from http://www.textpad.com. This is a full 32 bit text editor that is a proper coders editor. One feature that is missing on most editors is block mode cut and paste - very useful. It also has a, rather basis, SQR syntax highlighter. I have improved it a little so if you decide to use this then give me a shout and I will email it. Textpad is the best editor that I have come across and is very useful for other languages as well e.g. it has 5/6 syntax checkers available for free download. Whilst on the subject of utilities, if you are sending your SQR output to files and wish to compare different runs a very good file compare utility is Beyond Compare from scootersoftware.com. It is feature rich and allows for complex comparison rules to be set up. happy coding & New Year to all. Colin. From owner-sqr-users@list.iex.net Tue Jan 4 09:15:38 2000 Date: Tue, 4 Jan 2000 09:01:16 -0500 From: "White, Denise" Subject: Re: sqr page break The sequence of write statements in the message below will not do what is described. Each write statement will write a separate line. Instead of: write 1 from $variable1:20 write 1 from $spacer:5 write 1 from $variable2:10 use: write 1 from $variable1:25 $variable2:10 You could still use the $spacer variable, but it is simpler to just pad the first variable by increasing the size. Denise White (about to change jobs) > -----Original Message----- > From: Automatic digest processor [SMTP:LISTSERV@list.iex.net] > Sent: Tuesday, January 04, 2000 2:01 AM > To: Recipients of SQR-USERS digests > Subject: SQR-USERS Digest - 31 Dec 1999 to 3 Jan 2000 (#2000-2) > > Date: Mon, 3 Jan 2000 17:44:22 GMT > Subject: Re: sqr page break > > Brad, > > Just a thought - If you wrote the report to a flat file, instead of a .lis > file, you would have more control over the formatting. > > To accomplish, put this in your main procedure: > > open c:\temp\myfile.txt as 1 > for-writing > record=200 !this line declares the max width of the file > > Then, in your procedure where you would type: > print $variable1 (,1,20) > print $variable2 (,25,10) > > instead type: > let $spacer = 5 > write 1 from $variable1:20 > write 1 from $spacer:5 > write 1 from $variable2:10 > > This will print $variable1 starting at position 1 for a length of 20, skip > 5 > spaces, then $variable2 starting at position 25 for a length of 10. Each > time the system goes through the select loop, it automatically drops down > one line. > > Melissia > ---------------------- > Melissia D. Dembrosky > Technical Consultant > MBH Consulting > 770-998-2323 From owner-sqr-users@list.iex.net Tue Jan 4 10:26:08 2000 Date: Tue, 4 Jan 2000 14:59:13 GMT From: data files Subject: Re: sqr page break Denise, You are completely correct. Sorry. Must have been the medication for my 'New Years Celebration' injury. :) Thanks for noticing and correcting me. Melissia >From: "White, Denise" >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Re: sqr page break >Date: Tue, 4 Jan 2000 09:01:16 -0500 > >The sequence of write statements in the message below will not do what is >described. Each write statement will write a separate line. Instead of: > >write 1 from $variable1:20 >write 1 from $spacer:5 >write 1 from $variable2:10 > >use: > >write 1 from $variable1:25 $variable2:10 > >You could still use the $spacer variable, but it is simpler to just pad the >first variable by increasing the size. > >Denise White >(about to change jobs) > > > -----Original Message----- > > From: Automatic digest processor [SMTP:LISTSERV@list.iex.net] > > Sent: Tuesday, January 04, 2000 2:01 AM > > To: Recipients of SQR-USERS digests > > Subject: SQR-USERS Digest - 31 Dec 1999 to 3 Jan 2000 (#2000-2) > > > > Date: Mon, 3 Jan 2000 17:44:22 GMT > > Subject: Re: sqr page break > > > > Brad, > > > > Just a thought - If you wrote the report to a flat file, instead of a >.lis > > file, you would have more control over the formatting. > > > > To accomplish, put this in your main procedure: > > > > open c:\temp\myfile.txt as 1 > > for-writing > > record=200 !this line declares the max width of the file > > > > Then, in your procedure where you would type: > > print $variable1 (,1,20) > > print $variable2 (,25,10) > > > > instead type: > > let $spacer = 5 > > write 1 from $variable1:20 > > write 1 from $spacer:5 > > write 1 from $variable2:10 > > > > This will print $variable1 starting at position 1 for a length of 20, >skip > > 5 > > spaces, then $variable2 starting at position 25 for a length of 10. >Each > > time the system goes through the select loop, it automatically drops >down > > one line. > > > > Melissia > > ---------------------- > > Melissia D. Dembrosky > > Technical Consultant > > MBH Consulting > > 770-998-2323 ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Tue Jan 4 11:59:26 2000 Date: Tue, 4 Jan 2000 11:36:39 -0500 From: paresh.j.patel@BELLATLANTIC.COM Subject: SQR & Flat Files SQR Version: SQR/4.2.3/PC/Windows NT 4.0/ODBC Level1/Apr 22 1998 I need to write a SQR to read data from a flat file (as opposed to PS tables), do some processing, and then generate a report. Does anyone have a working example I can look at? Any help would be appreciated. Thanks. From owner-sqr-users@list.iex.net Tue Jan 4 12:06:16 2000 Date: Tue, 4 Jan 2000 16:48:27 +0000 From: Colin A Faith Subject: Re: SQR & Flat Files Use the READ statement to read a line at a time until End of File, and then just substring each line to extract any given data elements. There are more sophisticated methods but this should get you started. Colin. From owner-sqr-users@list.iex.net Tue Jan 4 12:25:08 2000 Date: Tue, 4 Jan 2000 12:58:56 -0400 From: Peter Clark Subject: Re: SQR & Flat Files RTFM ... specifically, pages 254 thru 256 of the SQR 4.2.3 SQR Language Reference Manual (examples given) Peter Clark Veterans Affairs Canada >>> 2000/01/04 12:36:39 pm >>> SQR Version: SQR/4.2.3/PC/Windows NT 4.0/ODBC Level1/Apr 22 1998 I need to write a SQR to read data from a flat file (as opposed to PS tables), do some processing, and then generate a report. Does anyone have a working example I can look at? Any help would be appreciated. Thanks. From owner-sqr-users@list.iex.net Tue Jan 4 12:43:25 2000 Date: Tue, 4 Jan 2000 12:16:52 -0500 From: "htreadwell(contr-comp)" Subject: Lock Syntax on Begin-Select We have an SQR program running against a Sybase database that is locking out another process . To resolve the lock, we attempted to make the SQR query read only by using the following syntax: Begin-Select -LOCK RO The syntax is correct based on the manual, however, when we tried to compile the SQR program, we got a 3721 error - Bad param found on 'BEGIN-SELECT' line. Is the syntax database dependent? Can we use a " For Read Only " statement somehow (we tried this, but still got the lock)? Any suggestions on how to affect the isolation level for Sybase within the SQR program? Many thanks, Huey From owner-sqr-users@list.iex.net Tue Jan 4 12:46:52 2000 Date: Tue, 4 Jan 2000 12:26:31 -0500 From: Rick_Creel@AONCONS.COM Subject: Re: Lock Syntax on Begin-Select I encountered the same problem using Oracle on a Unix server. The various switch syntaxes shown in the book (such as -LOCK RO) seem to be for SQLBase only... what ever SQLBase is. I know it does NOT work for Oracle/Unix environment. Not sure what your solution will be. "htreadwell(contr-comp)" on 01/04/2000 12:16:52 PM Please respond to sqr-users@list.iex.net To: SQR-USERS@list.iex.net cc: (bcc: Rick Creel/IT/Aon Consulting) Subject: Lock Syntax on Begin-Select We have an SQR program running against a Sybase database that is locking out another process . To resolve the lock, we attempted to make the SQR query read only by using the following syntax: Begin-Select -LOCK RO The syntax is correct based on the manual, however, when we tried to compile the SQR program, we got a 3721 error - Bad param found on 'BEGIN-SELECT' line. Is the syntax database dependent? Can we use a " For Read Only " statement somehow (we tried this, but still got the lock)? Any suggestions on how to affect the isolation level for Sybase within the SQR program? Many thanks, Huey From owner-sqr-users@list.iex.net Tue Jan 4 12:56:01 2000 Date: Tue, 4 Jan 2000 12:33:52 -0500 From: Peter Alan Burton Subject: Re: Lock Syntax on Begin-Select Huey, As documented -LOCK is for SQLBase only. Peter On 4 Jan 00, at 12:16, htreadwell(contr-comp) wrote: Date sent: Tue, 4 Jan 2000 12:16:52 -0500 Send reply to: sqr-users@list.iex.net From: "htreadwell(contr-comp)" Subject: Lock Syntax on Begin-Select To: SQR-USERS@list.iex.net > We have an SQR program running against a Sybase database that is locking out > another process . To resolve the lock, we attempted to make the SQR query > read only by using the following syntax: > > Begin-Select -LOCK RO > > The syntax is correct based on the manual, however, when we tried to compile > the SQR program, we got a 3721 error - Bad param found on 'BEGIN-SELECT' > line. > > Is the syntax database dependent? Can we use a " For Read Only " statement > somehow (we tried this, but still got the lock)? Any suggestions on how to > affect the isolation level for Sybase within the SQR program? > > Many thanks, > Huey From owner-sqr-users@list.iex.net Tue Jan 4 13:21:09 2000 Date: Tue, 4 Jan 2000 11:51:06 -0600 From: Wes Williams Subject: Re: Lock Syntax on Begin-Select -lock is only for SQLBase e.g. Centura formally known as Gupta and will not work with Sybase. Wes Wes Williams Hamilton Sundstrand wes.williams@hs.utc.com >>> "htreadwell(contr-comp)" 01/04 11:16 AM >>> We have an SQR program running against a Sybase database that is locking out another process . To resolve the lock, we attempted to make the SQR query read only by using the following syntax: Begin-Select -LOCK RO The syntax is correct based on the manual, however, when we tried to compile the SQR program, we got a 3721 error - Bad param found on 'BEGIN-SELECT' line. Is the syntax database dependent? Can we use a " For Read Only " statement somehow (we tried this, but still got the lock)? Any suggestions on how to affect the isolation level for Sybase within the SQR program? Many thanks, Huey ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** From owner-sqr-users@list.iex.net Tue Jan 4 16:09:34 2000 Date: Tue, 4 Jan 2000 14:21:46 -0500 From: "Wanko, Christopher G, CFCTR" Subject: Re: Lock Syntax on Begin-Select > We have an SQR program running against a Sybase database that > is locking out another process . To resolve the lock, we attempted to make > the SQR query read only by using the following syntax: > > Begin-Select -LOCK RO Others have told you that this isn't gonna fly against the Sybase server. True enough. To accomplish what you need... try "set transaction isolation level 0" as part of a Begin-SQL command. Run the Begin-SELECT part of the report, and when finished, set the trans isolation level back to 3. Alternately try something like: "select title from titles at isolation read uncommitted", which accomplishes the same thing for the duration of the SELECT. You might have to play with this a bit, probably by using a Begin-SQL for your main SELECT and dumping retrieved values into variables, rather than using Begin-SELECT statement blocks. Try it and let us know, willya? -Chris From owner-sqr-users@list.iex.net Tue Jan 4 15:32:48 2000 Date: Tue, 4 Jan 2000 14:52:40 -0500 From: "htreadwell(contr-comp)" Subject: Re: Lock Syntax on Begin-Select Thank you all for your quick and helpful replies. Sorry I misunderstood the documentation but do appreciate your help. We are now modifying the programs updating sequences to try and avoid the locking. Thanks again. Huey -----Original Message----- From: htreadwell(contr-comp) [mailto:htreadwell@SNAP.ORG] Sent: Tuesday, January 04, 2000 12:17 PM To: SQR-USERS@list.iex.net Subject: Lock Syntax on Begin-Select We have an SQR program running against a Sybase database that is locking out another process . To resolve the lock, we attempted to make the SQR query read only by using the following syntax: Begin-Select -LOCK RO The syntax is correct based on the manual, however, when we tried to compile the SQR program, we got a 3721 error - Bad param found on 'BEGIN-SELECT' line. Is the syntax database dependent? Can we use a " For Read Only " statement somehow (we tried this, but still got the lock)? Any suggestions on how to affect the isolation level for Sybase within the SQR program? Many thanks, Huey From owner-sqr-users@list.iex.net Tue Jan 4 16:44:12 2000 Date: Tue, 4 Jan 2000 16:08:08 -0500 From: Ray Ontko Subject: Re: SQR interactive internet capabilities Robert, We have constructed a number of SQR-based web-form applications. The library of routines we use to access the information from a web form (using the Common Gateway Interface (CGI) protocol) is available at: http://www.ontko.com/sqr/cgi-lib.html This software was developed by our own Eric Eastman. A new release of this software will be coming soon. Watch this space for an announcement. Ray > I would like to use SQR to build interactive web sites and would like to see some HTML code examples (links). I have used SQR to write out HTML files, but now I would like to examples of coding queries to the database and displaying the results. I'm looking for something simplier than a PowerBuilder type solution, and I haven't seen anything that the Brio Portal product can deliver on this. > > Thanks > ---------------------------------------------------------------------- Ray Ontko rayo@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ From owner-sqr-users@list.iex.net Tue Jan 4 16:55:54 2000 Date: Tue, 4 Jan 2000 15:23:30 -0600 From: Deepak Joshi Subject: Re: Lock Syntax on Begin-Select Huey, For DB2 we used 'with UR' with the from clause, this ensured that the table was read without lock eg. BEGIN-SELECT ON-ERROR=CANNOT-SELECT IFS.SUBCUST_USE_SW let $subcust_use_sw = rtrim(&ifs.subcust_use_sw,' ') from PS_INSTALLATION_FS IFS with UR END-SELECT There should a similar command for Sybase. check your sybase documentation. -----Original Message----- From: Discussion of SQR, Brio Technology's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of htreadwell(contr-comp) Sent: Tuesday, January 04, 2000 11:17 AM To: SQR-USERS@list.iex.net Subject: Lock Syntax on Begin-Select We have an SQR program running against a Sybase database that is locking out another process . To resolve the lock, we attempted to make the SQR query read only by using the following syntax: Begin-Select -LOCK RO The syntax is correct based on the manual, however, when we tried to compile the SQR program, we got a 3721 error - Bad param found on 'BEGIN-SELECT' line. Is the syntax database dependent? Can we use a " For Read Only " statement somehow (we tried this, but still got the lock)? Any suggestions on how to affect the isolation level for Sybase within the SQR program? Many thanks, Huey From owner-sqr-users@list.iex.net Wed Jan 5 04:09:02 2000 Date: Wed, 5 Jan 2000 14:22:48 +0530 From: srinivasan.seetharaman@DB.COM Subject: Strange Problem Hello All, I have a strange problem. I have a SQL statement in SQR. I select a date from a table .Take for instance the date is c_dt, the database variable is referenced as &c_dt. In the Insert statement in the same SQR , I'm inserting &c_dt into a date field. The insert executes successfully. But surprisingly , a date value(say 01-jun-1999') is inserted as ('01-jun-2099'). Could anyone throw some light on this ?. And let me know what the problem is . Even though &c_dt is not a date variable but a character variable , it should have populated it as 19yy instead of 20yy right ?. Thanks in Advance. From owner-sqr-users@list.iex.net Wed Jan 5 04:34:21 2000 Date: Wed, 5 Jan 2000 09:22:23 -0000 From: "Slattery, Chad" Subject: Re: Strange Problem This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BF575E.603368EC Content-Type: text/plain; charset="iso-8859-1" Hi, Is the date value really 01-jun-1999 or is it 01-jun-99? I discovered this problem yesterday and have to change a lot of sqrs. As Im dealing with dates of birth Im not going to be too worried about the implications for another 20 years or so, so Im happy with the fix. If anybody else has any better suggestions Id be happy to accept and use them. Anyway I fixed by the following. As we had been working with a date eg. 18NOV68 and wanted to use date format 'YYYYMMDD', the yyyy is taking 2000 and not 1900 from the server(obviously). I extracted out the original date components and concatted a '19' to the year. Although it may seem a bit lengthy, my procedure already existed, I just had to add the '19' to $outdt. Hope you get some use out of it anyway.. ! $a is the date 18nov68 begin-procedure conv-dat($a) extract $dt-dd from $a 0 2 ! get the day move $dt-dd to $outdt concat '-' with $outdt extract $dt-mm from $a 2 3 ! get the month concat $dt-mm with $outdt concat '-' with $outdt move '19' to $nt move $nt to $nt 99 ! use format 99 concat $nt with $outdt extract $dt-yy from $a 5 4 ! get the year concat $dt-yy with $outdt begin-select to_char(to_date($outdt,'DD-MON-YYYY'),'YYYYMMDD') &b from dual end-select let $ndat = &b end-procedure !conv-dat Chad. -----Original Message----- From: srinivasan.seetharaman@DB.COM [mailto:srinivasan.seetharaman@DB.COM] Sent: Wednesday, January 05, 2000 8:53 AM To: SQR-USERS@LIST.IEX.NET Subject: Strange Problem Hello All, I have a strange problem. I have a SQL statement in SQR. I select a date from a table .Take for instance the date is c_dt, the database variable is referenced as &c_dt. In the Insert statement in the same SQR , I'm inserting &c_dt into a date field. The insert executes successfully. But surprisingly , a date value(say 01-jun-1999') is inserted as ('01-jun-2099'). Could anyone throw some light on this ?. And let me know what the problem is ------_=_NextPart_001_01BF575E.603368EC-- From owner-sqr-users@list.iex.net Wed Jan 5 05:13:39 2000 Date: Wed, 5 Jan 2000 15:33:20 +0530 From: srinivasan.seetharaman@DB.COM Subject: Re: Strange Problem The date value is 01-jun-99. ---------------------------------------- Message History ---------------------------------------- From: Chad.Slattery@csclac.irlgov.ie on 01/05/2000 09:22 AM GMT Please respond to sqr-users@list.iex.net To: SQR-USERS@list.iex.net cc: Subject: Re: Strange Problem Hi, Is the date value really 01-jun-1999 or is it 01-jun-99? I discovered this problem yesterday and have to change a lot of sqrs. As Im dealing with dates of birth Im not going to be too worried about the implications for another 20 years or so, so Im happy with the fix. If anybody else has any better suggestions Id be happy to accept and use them. Anyway I fixed by the following. As we had been working with a date eg. 18NOV68 and wanted to use date format 'YYYYMMDD', the yyyy is taking 2000 and not 1900 from the server(obviously). I extracted out the original date components and concatted a '19' to the year. Although it may seem a bit lengthy, my procedure already existed, I just had to add the '19' to $outdt. Hope you get some use out of it anyway.. ! $a is the date 18nov68 begin-procedure conv-dat($a) extract $dt-dd from $a 0 2 ! get the day move $dt-dd to $outdt concat '-' with $outdt extract $dt-mm from $a 2 3 ! get the month concat $dt-mm with $outdt concat '-' with $outdt move '19' to $nt move $nt to $nt 99 ! use format 99 concat $nt with $outdt extract $dt-yy from $a 5 4 ! get the year concat $dt-yy with $outdt begin-select to_char(to_date($outdt,'DD-MON-YYYY'),'YYYYMMDD') &b from dual end-select let $ndat = &b end-procedure !conv-dat Chad. -----Original Message----- From: srinivasan.seetharaman@DB.COM [mailto:srinivasan.seetharaman@DB.COM] Sent: Wednesday, January 05, 2000 8:53 AM To: SQR-USERS@LIST.IEX.NET Subject: Strange Problem Hello All, I have a strange problem. I have a SQL statement in SQR. I select a date from a table .Take for instance the date is c_dt, the database variable is referenced as &c_dt. In the Insert statement in the same SQR , I'm inserting &c_dt into a date field. The insert executes successfully. But surprisingly , a date value(say 01-jun-1999') is inserted as ('01-jun-2099'). Could anyone throw some light on this ?. And let me know what the problem is From owner-sqr-users@list.iex.net Wed Jan 5 06:52:08 2000 Date: Wed, 5 Jan 2000 13:36:16 +0200 From: Jason Wainwright Subject: Printing Memo Objects Hi all >From the Database I read a field that is varchar(250), only thing is, is that it has the enter character in it. How do I print a string with these in, on screen (.SPF) it displays the two solid bars (extended acsii I think), when i print it it carriage returns. The system is Win 95 and Sybase and Worbench v4.1. Any simple solutions? TIA From owner-sqr-users@list.iex.net Wed Jan 5 07:57:28 2000 Date: Wed, 5 Jan 2000 06:39:38 -0600 From: Wes Williams Subject: Re: Printing Memo Objects Hi Jason, the translate can remove the double bars e.g. let $Varchar_field = translate(&varchar_field, chr(13), '') Then to wrap use the print $Varchar_field (,1,1) wrap 50 5 on =<10> Or try using just the print with on =<13> hth Wes Wes Williams Hamilton Sundstrand wes.williams@hs.utc.com >>> Jason Wainwright 01/05 5:36 AM >>> Hi all >From the Database I read a field that is varchar(250), only thing is, is that it has the enter character in it. How do I print a string with these in, on screen (.SPF) it displays the two solid bars (extended acsii I think), when i print it it carriage returns. The system is Win 95 and Sybase and Worbench v4.1. Any simple solutions? TIA ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** From owner-sqr-users@list.iex.net Wed Jan 5 08:18:56 2000 Date: Wed, 5 Jan 2000 08:00:50 -0500 From: "Johnson, Dan" Subject: Re: Strange Problem Hi, What DBMS are you using? If you are using Oracle here is what is happening. Your Oracle NLS date format is 'dd-mon-yy' this means that when you insert a date with a two digit year Oracle will attach the current century, which is now 20 as opposed to 19, onto the front of the year. Hence you get 2099 instead of 1999. To correct this you can do one of two things. You can change your Oracle NLS date format to 'dd-mon-rr' which is the Oracle windowing format. This is the easiest and safest way to fix the problem. Or you can find all of your date inserts and use the Oracle date function to_date(&some_date,'dd-mon-rr') when you insert. I don't know about other DBMS systems but I am sure they have something similar that you can do. Dan Hello All, I have a strange problem. I have a SQL statement in SQR. I select a date from a table .Take for instance the date is c_dt, the database variable is referenced as &c_dt. In the Insert statement in the same SQR , I'm inserting &c_dt into a date field. The insert executes successfully. But surprisingly , a date value(say 01-jun-1999') is inserted as ('01-jun-2099'). Could anyone throw some light on this ?. And let me know what the problem is . Even though &c_dt is not a date variable but a character variable , it should have populated it as 19yy instead of 20yy right ?. Thanks in Advance. From owner-sqr-users@list.iex.net Wed Jan 5 08:29:52 2000 Date: Wed, 5 Jan 2000 08:22:45 -0500 From: "Mani, Bharati" Subject: Re: Strange Problem Hi while inserting the date into a date field use tha mask 'dd-mon-rr' e.g insert into table_name values( .... to_date(&c_dt, 'dd-mon-rr') HTH Bharathi > -----Original Message----- > From: srinivasan.seetharaman@DB.COM [SMTP:srinivasan.seetharaman@DB.COM] > Sent: Wednesday, January 05, 2000 3:53 AM > To: SQR-USERS@list.iex.net > Subject: Strange Problem > > Hello All, > I have a strange problem. I have a SQL statement in SQR. I select a > date > from a table .Take for instance the date is c_dt, the database variable is > referenced as &c_dt. > > In the Insert statement in the same SQR , I'm inserting &c_dt into a date > field. > The insert executes successfully. But surprisingly , a date value(say > 01-jun-1999') is inserted as ('01-jun-2099'). > > Could anyone throw some light on this ?. And let me know what the problem > is . > Even though &c_dt is not a date variable but a character variable , it > should > have populated it as 19yy instead of 20yy right ?. > > > Thanks in Advance. From owner-sqr-users@list.iex.net Wed Jan 5 14:21:46 2000 Date: Wed, 5 Jan 2000 07:33:46 -0700 From: Reinier de Ruiter Subject: Re: Strange Problem Haven't done your y2k testing have you ? :-)) Anyways, we had a similar situation. It turns out the nls-date format is set to dd-mon-yy and Oracle automatically adds the current century to it (2000) and that's why you get 2099 instead of 1999. Change your nls-date format to dd-mon-yyyy which will probably give you problems elsewhere in the code. In your situation I would use the dd-mon-rr in your edit-mask. The rr will cause Oracle to convert 99 into 1999. (50-99 will be converted into 1950-1999 and 00-49 will be converted into 2000-2049) good luck, Reinier de Ruiter Peoplesoft Programmer/Analyst Apollo Group, University of Phoenix Phoenix, Arizona tel:480-557-1158 email: reinier.deruiter@apollogrp.edu -----Original Message----- From: srinivasan.seetharaman@DB.COM [mailto:srinivasan.seetharaman@DB.COM] Sent: Wednesday, January 05, 2000 1:53 AM To: SQR-USERS@list.iex.net Subject: Strange Problem Hello All, I have a strange problem. I have a SQL statement in SQR. I select a date from a table .Take for instance the date is c_dt, the database variable is referenced as &c_dt. In the Insert statement in the same SQR , I'm inserting &c_dt into a date field. The insert executes successfully. But surprisingly , a date value(say 01-jun-1999') is inserted as ('01-jun-2099'). Could anyone throw some light on this ?. And let me know what the problem is . Even though &c_dt is not a date variable but a character variable , it should have populated it as 19yy instead of 20yy right ?. Thanks in Advance. From owner-sqr-users@list.iex.net Wed Jan 5 09:59:51 2000 Date: Wed, 5 Jan 2000 09:47:29 EST From: Vishner@AOL.COM Subject: Re: Strange Problem Hi to all, For the small population of us who are over 50 years old, I object to the use of "-RR" as a long term solution. It is fine if no dates occuring before 1950 are processed, but if my birthday is inserted, the resultant year would be 2048 isntead of 1948. Alternatively, use NLS_DATE FORMAT (or to_char mask everywhere) containing a 4-digit year (e.g.,'dd-mon-yyyy', 'yyyy-mm-dd'). I understand that this might mean more work if dates are parsed or reformatted, but it is safer). If you are using a fairly recent release of SQR, you can modify the SQR default date format. If using an old version, you can change the NLS_DATE_FORMAT only for the duration of that SQR by coding the following in begin-SETUP/end-SETUP begin-SQL ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY' end-SQL This will ensure that any other applications will continue to see dates in standard ORACLE format. HTH, Hugh In a message dated Wed, 5 Jan 2000 7:59:04 AM Eastern Standard Time, "Johnson, Dan" writes: > Hi, > What DBMS are you using? If you are using Oracle here is what is > happening. Your Oracle NLS date format is 'dd-mon-yy' this means that when > you insert a date with a two digit year Oracle will attach the current > century, which is now 20 as opposed to 19, onto the front of the year. > Hence you get 2099 instead of 1999. To correct this you can do one of two > things. You can change your Oracle NLS date format to 'dd-mon-rr' which is > the Oracle windowing format. This is the easiest and safest way to fix the > problem. Or you can find all of your date inserts and use the Oracle date > function to_date(&some_date,'dd-mon-rr') when you insert. I don't know about > other DBMS systems but I am sure they have something similar that you can > do. > > Dan > > Hello All, > I have a strange problem. I have a SQL statement in SQR. I > select a date > from a table .Take for instance the date is c_dt, the database > variable is > referenced as &c_dt. > > In the Insert statement in the same SQR , I'm inserting &c_dt into a > date field. > The insert executes successfully. But surprisingly , a date > value(say > 01-jun-1999') is inserted as ('01-jun-2099'). > > Could anyone throw some light on this ?. And let me know what the > problem is . > Even though &c_dt is not a date variable but a character variable , > it should > have populated it as 19yy instead of 20yy right ?. > > > Thanks in Advance. From owner-sqr-users@list.iex.net Wed Jan 5 10:32:40 2000 Date: Wed, 5 Jan 2000 15:13:09 -0000 From: "Slattery, Chad" Subject: Re: Strange Problem This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BF578F.60150696 Content-Type: text/plain; charset="iso-8859-1" Reinier, Date of births prior to 1950 restricts us (I would think everyone else using dates of birth as well) from using the 'rr' format. I had tried that first before hardcoding the '19' onto the date itself. Other developers not using dates prior to 1950 shouldnt have to do this. The problem I found with using the 'yyyy' was that the year has to be in 4 digit format in the first place(which ours isnt, when the data is being punched into files). I think everyone has to assess what range of dates they're going to be using and use what format best suits them. As you suggested though, the 'rr' format should fix the original query. regards, Chad. -----Original Message----- From: Reinier de Ruiter [mailto:Reinier.deRuiter@APOLLOGRP.EDU] Sent: Wednesday, January 05, 2000 2:34 PM To: SQR-USERS@LIST.IEX.NET Subject: Re: Strange Problem Haven't done your y2k testing have you ? :-)) Anyways, we had a similar situation. It turns out the nls-date format is set to dd-mon-yy and Oracle automatically adds the current century to it (2000) and that's why you get 2099 instead of 1999. Change your nls-date format to dd-mon-yyyy which will probably give you problems elsewhere in the code. In your situation I would use the dd-mon-rr in your edit-mask. The rr will cause Oracle to convert 99 into 1999. (50-99 will be converted into 1950-1999 and 00-49 will be converted into 2000-2049) good luck, Reinier de Ruiter Peoplesoft Programmer/Analyst Apollo Group, University of Phoenix Phoenix, Arizona tel:480-557-1158 email: reinier.deruiter@apollogrp.edu -----Original Message----- From: srinivasan.seetharaman@DB.COM [mailto:srinivasan.seetharaman@DB.COM] Sent: Wednesday, January 05, 2000 1:53 AM To: SQR-USERS@list.iex.net Subject: Strange Problem Hello All, I have a strange problem. I have a SQL statement in SQR. I select a date from a table .Take for instance the date is c_dt, the database variable is referenced as &c_dt. In the Insert statement in the same SQR , I'm inserting &c_dt into a date field. The insert executes successfully. But surprisingly , a date value(say 01-jun-1999') is inserted as ('01-jun-2099'). Could anyone throw some light on this ?. And let me know what the problem is ------_=_NextPart_001_01BF578F.60150696 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Strange Problem

Reinier,

Date of births prior to 1950 restricts us (I would = think everyone else using dates of birth as well) from using the 'rr' = format.  I had tried that first before hardcoding the '19' onto = the date itself. 

Other developers not using dates prior to 1950 = shouldnt have to do this.  The problem I found with using the = 'yyyy' was that the year has to be in 4 digit format in the first = place(which ours isnt, when the data is being punched into = files).  I think everyone has to assess what range of dates = they're going to be using and use what format best suits = them.

As you suggested though, the 'rr' format should fix = the original query.
regards,
Chad.



-----Original Message-----
From: Reinier de Ruiter [mailto:Reinier.deRuiter@A= POLLOGRP.EDU]
Sent: Wednesday, January 05, 2000 2:34 PM
To: SQR-USERS@LIST.IEX.NET
Subject: Re: Strange Problem


Haven't done your y2k testing have you ? :-))

Anyways, we had a similar situation. It turns out the = nls-date format is set
to dd-mon-yy and Oracle automatically adds the = current century to it (2000)
and that's why you get 2099 instead of 1999. Change = your nls-date format to
dd-mon-yyyy which will probably give you problems = elsewhere in the code. In
your situation I would use the dd-mon-rr in your = edit-mask. The rr will
cause Oracle to convert 99 into 1999. (50-99 will be = converted into
1950-1999 and 00-49 will be converted into = 2000-2049)

good luck,

Reinier de Ruiter
Peoplesoft Programmer/Analyst
Apollo Group, University of Phoenix
Phoenix, Arizona
tel:480-557-1158
email: reinier.deruiter@apollogrp.edu



-----Original Message-----
From: srinivasan.seetharaman@DB.COM
[mailto:srinivasan.seethara= man@DB.COM]
Sent: Wednesday, January 05, 2000 1:53 AM
To: SQR-USERS@list.iex.net
Subject: Strange Problem


Hello All,
     I have a strange problem. I = have a SQL statement in SQR. I select a
date
from a table .Take for instance the date is c_dt, = the database variable is
referenced as &c_dt.

In the Insert statement in the same SQR , I'm = inserting &c_dt into a date
field.
The insert executes successfully. But surprisingly , = a date value(say
01-jun-1999') is inserted as ('01-jun-2099').

Could anyone throw some light on this ?. And let me = know what the problem is

------_=_NextPart_001_01BF578F.60150696-- From owner-sqr-users@list.iex.net Tue Jan 4 12:07:12 2000 Date: Wed, 5 Jan 2000 10:48:56 -0600 From: =?iso-8859-1?Q?Juan_Enrique_Mu=F1oz?= Subject: Re: SQR & Flat Files You can follow this example for reading a file if exists('cust.dat') = 0 open 'cust.dat' as 10 for-reading status=#ostat record=133 ! open the file and SQR gets the fila as 10 and define the size of record in char else display 'File ''cust.dat'' does not exist: exiting' stop quiet end-if if #ostat = -1 display 'File ''cust.dat'' could not be opened.' stop quiet end-if while 1=1 ! Loop until break read 10 into $c:12 $st:2 $z:10 ! Read the file as 10 an store the values in every variable with the own size if #end-file break ! No more records to read end-if begin-sql insert into cust (city, state, zip) values ($c, $st, $z) ! Insert the prior variable to the table end-sql end-while I hope that this works for you!! -----Mensaje original----- De: paresh.j.patel@BELLATLANTIC.COM Para: SQR-USERS@list.iex.net Fecha: Martes, 04 de Enero de 2000 10:47 a.m. Asunto: SQR & Flat Files >SQR Version: SQR/4.2.3/PC/Windows NT 4.0/ODBC Level1/Apr 22 1998 > >I need to write a SQR to read data from a flat file (as opposed to PS tables), >do some processing, and then generate a report. Does anyone have a working >example I can look at? Any help would be appreciated. Thanks. From owner-sqr-users@list.iex.net Wed Jan 5 14:11:50 2000 Date: Wed, 5 Jan 2000 10:50:54 PST From: Scott Hitchcock Subject: Re: Printing Memo Objects Jason, You might try something like below.... begin-procedure main encode '<013>' into $cr !ascii Carriage Return encode '<010>' into $lf !ascii Line Feed begin-select var &var let $var = translate(translate(&var,$cr,' '),$lf,' ') print $var (+1,1) from table where .... end-select end-procedure main >From: Jason Wainwright >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Printing Memo Objects >Date: Wed, 5 Jan 2000 13:36:16 +0200 > >Hi all > >From the Database I read a field that is varchar(250), only thing is, is >that it has the enter character in it. How do I print a string with these >in, on screen (.SPF) it displays the two solid bars (extended acsii I >think), when i print it it carriage returns. The system is Win 95 and >Sybase and Worbench v4.1. > >Any simple solutions? > >TIA ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jan 5 15:10:31 2000 Date: Wed, 5 Jan 2000 14:46:46 -0500 From: Jeffrey Bedell Subject: Connecting to Oracle This will probably sound like a simple question to all of you Oracle people out there but being basically a Sybase shop, I'm stumped. I'm trying to connect to an Oracle database and according to the documentation I need to specify: SQR [programname] [connectivity] [flags] So I am executing: sqrw.exe c:\test\testfile USERID/PASSWORD@DB-SERVER and I get: (SQR 5528) Sybase ct_connect error in cursor 0: (3) ct_connect(): network packet layer: internal net library error: Specified server name attribute could not be found (SQR 4701) Cannot logon to the database. SQR: Program Aborting. I am running sqr on an NT server and accessing Oracle on a different NT server. Are there files that are specific to Oracle that I need to have on the application server? Thanks for your help. Jeffrey Bedell Syracuse University From owner-sqr-users@list.iex.net Wed Jan 5 15:29:09 2000 Date: Wed, 5 Jan 2000 14:13:03 -0600 From: Julie Waggoner Subject: Re: Printing Memo Objects This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BF57B9.45259D44 Content-Type: text/plain; charset="iso-8859-1" You can use the wrap function to translate carriage returns. print $test (+1,1) wrap 50 5000 strip=<13> on=<10> (From SQR Help) The STRIP and ON arguments affect which characters are to be converted before wrapping, and which characters will force a wrap to occur. Characters in the STRIP string argument will be converted to spaces before the wrap occurs. Characters in the ON string argument will cause a wrap at each ON character found. The ON character will not be printed. Both arguments will accept regular characters plus non-display characters whose ASCII values are surrounded by angled brackets, . -----Original Message----- From: Jason Wainwright [mailto:JasonW@LIMON.CO.ZA] Sent: Wednesday, January 05, 2000 5:36 AM To: SQR-USERS@list.iex.net Subject: Printing Memo Objects Hi all >From the Database I read a field that is varchar(250), only thing is, is that it has the enter character in it. How do I print a string with these in, on screen (.SPF) it displays the two solid bars (extended acsii I think), when i print it it carriage returns. The system is Win 95 and Sybase and Worbench v4.1. Any simple solutions? TIA ------_=_NextPart_001_01BF57B9.45259D44 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Printing Memo Objects

You can use the wrap function to translate carriage = returns.

        print = $test   (+1,1) wrap 50 5000 strip=3D<13> = on=3D<10>

(From SQR Help)
The STRIP and ON arguments affect which characters = are to be converted before wrapping, and which characters will force a = wrap to occur.

Characters in the STRIP string argument will be = converted to spaces before the wrap occurs.

Characters in the ON string argument will cause a = wrap at each ON character found. The ON character will not be = printed.

Both arguments will accept regular characters plus = non-display characters whose ASCII values are surrounded by angled = brackets, <nn>.


-----Original Message-----
From: Jason Wainwright [mailto:JasonW@LIMON.CO.ZA]=
Sent: Wednesday, January 05, 2000 5:36 AM
To: SQR-USERS@list.iex.net
Subject: Printing Memo Objects


Hi all

From the Database I read a field that is = varchar(250), only thing is, is
that it has the enter character in it.  How do = I print a string with these
in, on screen (.SPF) it displays the two solid bars = (extended acsii I
think), when i print it it carriage returns.  = The system is Win 95 and
Sybase and Worbench v4.1.

Any simple solutions?

TIA

------_=_NextPart_001_01BF57B9.45259D44-- From owner-sqr-users@list.iex.net Wed Jan 5 15:55:58 2000 Date: Wed, 5 Jan 2000 14:37:11 -0600 From: itzgee Subject: Re: Connecting to Oracle -- linking two databases On your SQR.ini file, I'm guessing that you only have one license for sqr and so it is defaulting to the Sybase settings. You do not have sqr installed on the Oracle database. You could try linking up to Oracle inside the sqr -- no flags needed as far as I know. Your dba would need to set up a database link from your sybase server to the oracle server. I wrote a lengthy response to this question a couple of months ago, so if you search the archive for my name or the term Link, you should be able to find the answer. Gracen Duffield Texas Department of Housing and Community Affairs 475-3839 -----Original Message----- From: Discussion of SQR, Brio Technology's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Jeffrey Bedell Sent: Wednesday, January 05, 2000 1:47 PM To: SQR-USERS@list.iex.net Subject: Connecting to Oracle This will probably sound like a simple question to all of you Oracle people out there but being basically a Sybase shop, I'm stumped. I'm trying to connect to an Oracle database and according to the documentation I need to specify: SQR [programname] [connectivity] [flags] So I am executing: sqrw.exe c:\test\testfile USERID/PASSWORD@DB-SERVER and I get: (SQR 5528) Sybase ct_connect error in cursor 0: (3) ct_connect(): network packet layer: internal net library error: Specified server name attribute could not be found (SQR 4701) Cannot logon to the database. SQR: Program Aborting. I am running sqr on an NT server and accessing Oracle on a different NT server. Are there files that are specific to Oracle that I need to have on the application server? Thanks for your help. Jeffrey Bedell Syracuse University From owner-sqr-users@list.iex.net Thu Jan 6 01:08:56 2000 Date: Thu, 6 Jan 2000 14:05:21 +0800 From: Tam Siu Tung Subject: Font Size in SQR?? Hello, I would like to ask that how to change the font to be bigger in SQR? My printer is Xerox 4215/MRP2! Thank You From owner-sqr-users@list.iex.net Thu Jan 6 08:35:03 2000 Date: Thu, 6 Jan 2000 08:20:32 -0500 From: Ray Ontko Subject: Re: Font Size in SQR?? Howdy, > I would like to ask that how to change the font to be bigger in > SQR? My printer is Xerox 4215/MRP2! It appears that the Xerox 4215/MRP2 supports HP PCL and Adobe PostScript: http://www.mrsp.com/products/42154219/ If you can figure out how to put the printer into PCL or PostScript "mode", then you can use SQR with -printer:hp or -printer:ps to generate PCL or PostScript output. Then, to change the font, use the ALTER-PRINTER command to change the font-size, character-set, type-face, etc. Ray ---------------------------------------------------------------------- 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 6 10:11:17 2000 Date: Thu, 6 Jan 2000 09:58:14 -0500 From: Mark Risman Subject: Re: Font Size in SQR?? If you want to change the default font size or other similar attributes of the whole SQR, you can also use DECLARE-PRINTER (available in SQR 3 and up) or DECLARE PRINTER (deprecated in SQR 3 and up). - Mark -----Original Message----- From: Ray Ontko [mailto:rayo@ONTKO.COM] Sent: Thursday, January 06, 2000 8:21 AM To: SQR-USERS@list.iex.net Subject: Re: Font Size in SQR?? Howdy, > I would like to ask that how to change the font to be bigger in > SQR? My printer is Xerox 4215/MRP2! It appears that the Xerox 4215/MRP2 supports HP PCL and Adobe PostScript: http://www.mrsp.com/products/42154219/ If you can figure out how to put the printer into PCL or PostScript "mode", then you can use SQR with -printer:hp or -printer:ps to generate PCL or PostScript output. Then, to change the font, use the ALTER-PRINTER command to change the font-size, character-set, type-face, etc. Ray ---------------------------------------------------------------------- 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 6 10:48:04 2000 Date: Thu, 6 Jan 2000 09:40:29 -0600 From: Bill Beckner Subject: Reading Binary files Hello SQR gurus! I hope someone can help.... We are using SQR 4.3.4. I'm having difficulty in reading a binary file, which is a PCL image file, into a string variable. I've opened the file with a record-length of 9559 (the # of bytes in the file) and set the record type as FIXED_NOLF: open 'P:\BILL\SQR\HR\ICCLOGO2.PCL' as #In for-reading record=9559:fixed_nolf status=#InStatus Now when I READ the file: READ #In into $ICCLogo:9559 I only get the first 19 bytes of the file (up to the first NULL byte). Is there any way to get the entire file into a single string variable? Or is this plan doomed to failure? TIA!!! -- William Beckner -- Stunt Programmer (Just call me "Bill") Illinois Central College, Rm L141 -- East Peoria, IL 61635-0001 PH: (309) 694-8419 -- FAX: (309) 694-8995 "C code. C code run. Please, code, RUN!" From owner-sqr-users@list.iex.net Thu Jan 6 11:05:58 2000 Date: Thu, 6 Jan 2000 10:56:13 -0500 From: Ray Ontko Subject: Re: Reading Binary files Bill, You are doomed to failure. If you want to read binary data, use a numeric variable to read byte by byte. move '' to $s move 0 to #i while #i < 9559 read #In into #byte:1 ! process the byte. For example: do byte_to_bitstring( #byte , $bit_string ) ! you'll have to write this concat $bit_string with $s add 1 to #i end-while Ray [Charset iso-8859-1 unsupported, filtering to ASCII...] > Hello SQR gurus! I hope someone can help.... > > We are using SQR 4.3.4. > > I'm having difficulty in reading a binary file, which is a PCL image file, > into a string variable. I've opened the file with a record-length of 9559 > (the # of bytes in the file) and set the record type as FIXED_NOLF: > > open 'P:\BILL\SQR\HR\ICCLOGO2.PCL' as #In for-reading > record=9559:fixed_nolf > status=#InStatus > > Now when I READ the file: > > READ #In into $ICCLogo:9559 > > I only get the first 19 bytes of the file (up to the first NULL byte). Is > there any way to get the entire file into a single string variable? Or is > this plan doomed to failure? TIA!!! > -- > William Beckner -- Stunt Programmer (Just call me "Bill") > Illinois Central College, Rm L141 -- East Peoria, IL 61635-0001 > PH: (309) 694-8419 -- FAX: (309) 694-8995 > "C code. C code run. Please, code, RUN!" > ---------------------------------------------------------------------- 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 6 12:04:52 2000 Date: Thu, 6 Jan 2000 11:51:26 EST From: Manoj Gurjar Subject: Re: Strange Problem What database u are on? Read/see document related to RR (centurey) format/mask for Date. HTH, Manoj >From: srinivasan.seetharaman@DB.COM >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Strange Problem >Date: Wed, 5 Jan 2000 14:22:48 +0530 > >Hello All, > I have a strange problem. I have a SQL statement in SQR. I select a >date >from a table .Take for instance the date is c_dt, the database variable is >referenced as &c_dt. > >In the Insert statement in the same SQR , I'm inserting &c_dt into a date >field. >The insert executes successfully. But surprisingly , a date value(say >01-jun-1999') is inserted as ('01-jun-2099'). > >Could anyone throw some light on this ?. And let me know what the problem >is . >Even though &c_dt is not a date variable but a character variable , it >should >have populated it as 19yy instead of 20yy right ?. > > >Thanks in Advance. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Thu Jan 6 17:12:17 2000 Date: Thu, 6 Jan 2000 14:47:25 -0700 From: Fong Ed Subject: ON-BREAK processing Hello all. Has anyone encountered the following: I have a fairly standard select paragraph: begin-select a.break1 a.break2 b.name If $parm_hardcopy = 'Y' Print &a.acad_prog_primary on-break level=1 print=never before=before-1 after=after-1 If $parm_break = '2' #debuga display ' about to print break 2' Print &a.acad_plan on-break level=2 print=never before=before-2 after=after-2 End-If End-If from ps_table_1 A, ps_table_2 B, Situation 1: $parm_hardcopy = 'Y' $parm_break = '1' Procedure before-1 executes (as expected), but procedure before-2 also executes! And, procedure after-1 executes (as expected), but procedure after-2 also executes! Situation 2: $parm_hardcopy = 'N' $parm_break = '1' All four before and after procedures execute once each. (The before procedures execute just before the first row is selected and the after procedures execute after the last row has been selected) The funny thing is that in either situation, the debug statement immediately following the inner if is never found in the sqr.log file. What gives? TIA, Ed Edward Fong University of Alberta - OASIS Project Phone: (780) 492-5376 Fax: (780) 492-2371 ed.fong@ualberta.ca From owner-sqr-users@list.iex.net Thu Jan 6 17:08:52 2000 Date: Thu, 6 Jan 2000 16:48:01 -0500 From: Sam Spritzer Subject: This is not trivia pursuit.... Don't you just love it when clueless users make a request that, in their world, makes perfect sense to them within the realm of their logic and common sense.....hence, take a look at the following. I am trying to update a varchar(30) column from one table with a varchar(30) column from another table. I have already tested both columns for null values....and there aren't any. Can any of you shed any light in this? ********************************************* SQL*Plus: Release 3.3.2.0.2 - Production on Thu Jan 06 16:26:11 2000 Copyright (c) Oracle Corporation 1979, 1994. All rights reserved. Connected to: Oracle7 Server Release 7.3.4.3.0 - Production With the distributed, replication, parallel query and Spatial Data options PL/SQL Release 2.3.4.3.0 - Production SQL> update ps_employment a 2 set a.business_title = (select b.jobtitle 3 from ps_employees b 4 where a.emplid = b.emplid); from ps_employees b * ERROR at line 3: ORA-01407: cannot update mandatory (NOT NULL) column to NULL **************************************** SQRly yours, Sam From owner-sqr-users@list.iex.net Thu Jan 6 17:16:10 2000 Date: Thu, 6 Jan 2000 17:08:21 -0500 From: John Ferguson Subject: Re: This is not trivia pursuit.... I thought the whole purpose of this group was to help each other out. Not everyone can be a smart as you think you are. It would have served everyone better if you just pointed out the mistake instead of making a joke about it. If you remember back to when you started coding, I'm sure you didn't have all of the answers. Think about that next you consider any question stupid or people as clueless. John Sam Spritzer wrote: > Don't you just love it when clueless users make a request that, in their world, makes perfect sense to them within the realm of their logic and common > sense.....hence, take a look at the following. > > I am trying to update a varchar(30) column from one table with a varchar(30) column from another table. I have already tested both columns for null > values....and there aren't any. Can any of you shed any light in this? > > ********************************************* > SQL*Plus: Release 3.3.2.0.2 - Production on Thu Jan 06 16:26:11 2000 > > Copyright (c) Oracle Corporation 1979, 1994. All rights reserved. > > Connected to: > Oracle7 Server Release 7.3.4.3.0 - Production > With the distributed, replication, parallel query and Spatial Data options > PL/SQL Release 2.3.4.3.0 - Production > > SQL> update ps_employment a > 2 set a.business_title = (select b.jobtitle > 3 from ps_employees b > 4 where a.emplid = b.emplid); > from ps_employees b > * > ERROR at line 3: > ORA-01407: cannot update mandatory (NOT NULL) column to NULL > **************************************** > > SQRly yours, > Sam From owner-sqr-users@list.iex.net Thu Jan 6 17:21:58 2000 Date: Thu, 6 Jan 2000 15:09:05 -0700 From: Robert Goshko Subject: Re: This is not trivia pursuit.... I do not think you can use a correlated sub query as the value on a set statement (I may be wrong, but I have never gotten it to work), try this one: SELECT 'UPDATE PS_EMPLOYMENT SET BUSINESS_TITLE = ''' || B.JobTitle || ''' WHERE EMPLID = ''' || A.EmplID || ''' AND Empl_Rcd# = ' || TO_CHAR( A.Empl_Rcd#, '999' ) || ';' FROM PS_EMPLOYMENT A , PS_EMPLOYEES B WHERE A.EmplID = B.EmplID AND A.Empl_Rcd# = B.Empl_Rcd# AND A.Business_Title <> B.JobTitle The last parameter will eliminate any conditions where the titles already match, the result will be a series of update statements that can be run to update the employment table. .....Rob _________________________________________________ Robert Goshko Owner Axis Developments System Consulting Services Sherwood Park, Alberta, Canada http://www.axis-dev.com/ -----Original Message----- From: Discussion of SQR, Brio Technology's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Sam Spritzer Sent: Thursday, January 06, 2000 2:48 PM To: SQR-USERS@list.iex.net Subject: This is not trivia pursuit.... Don't you just love it when clueless users make a request that, in their world, makes perfect sense to them within the realm of their logic and common sense.....hence, take a look at the following. I am trying to update a varchar(30) column from one table with a varchar(30) column from another table. I have already tested both columns for null values....and there aren't any. Can any of you shed any light in this? ********************************************* SQL*Plus: Release 3.3.2.0.2 - Production on Thu Jan 06 16:26:11 2000 Copyright (c) Oracle Corporation 1979, 1994. All rights reserved. Connected to: Oracle7 Server Release 7.3.4.3.0 - Production With the distributed, replication, parallel query and Spatial Data options PL/SQL Release 2.3.4.3.0 - Production SQL> update ps_employment a 2 set a.business_title = (select b.jobtitle 3 from ps_employees b 4 where a.emplid = b.emplid); from ps_employees b * ERROR at line 3: ORA-01407: cannot update mandatory (NOT NULL) column to NULL **************************************** SQRly yours, Sam From owner-sqr-users@list.iex.net Thu Jan 6 17:22:33 2000 Date: Thu, 6 Jan 2000 17:12:00 -0500 From: "Fay, Brannon" Subject: Re: ON-BREAK processing Ed, Try switching the levels around, so level=2 on your $parm_hardcopy if and level=1 on your $parm_break if. Looking on page 230 in the 4.3 Lang Ref, if a break occurs on the state level, the state, county and city after and befores will all be triggered. HTH, Brannon Fay -----Original Message----- From: Fong Ed [mailto:ed.fong@UALBERTA.CA] Sent: Thursday, January 06, 2000 4:47 PM To: SQR-USERS@list.iex.net Subject: ON-BREAK processing Hello all. Has anyone encountered the following: I have a fairly standard select paragraph: begin-select a.break1 a.break2 b.name If $parm_hardcopy = 'Y' Print &a.acad_prog_primary on-break level=1 print=never before=before-1 after=after-1 If $parm_break = '2' #debuga display ' about to print break 2' Print &a.acad_plan on-break level=2 print=never before=before-2 after=after-2 End-If End-If from ps_table_1 A, ps_table_2 B, Situation 1: $parm_hardcopy = 'Y' $parm_break = '1' Procedure before-1 executes (as expected), but procedure before-2 also executes! And, procedure after-1 executes (as expected), but procedure after-2 also executes! Situation 2: $parm_hardcopy = 'N' $parm_break = '1' All four before and after procedures execute once each. (The before procedures execute just before the first row is selected and the after procedures execute after the last row has been selected) The funny thing is that in either situation, the debug statement immediately following the inner if is never found in the sqr.log file. What gives? TIA, Ed Edward Fong University of Alberta - OASIS Project Phone: (780) 492-5376 Fax: (780) 492-2371 ed.fong@ualberta.ca From owner-sqr-users@list.iex.net Thu Jan 6 17:26:35 2000 Date: Thu, 6 Jan 2000 15:16:44 -0700 From: Rajiv_Agrawal@BC.COM Subject: Re: This is not trivia pursuit.... Sam Try the following statement: SQL> update ps_employment a 2 set a.business_title = (select b.jobtitle 3 from ps_employees b 4 where a.emplid = b.emplid) 5.where exists ( select 'x' from ps_employee b1 where b1.emplid = a.empid) ; HTH -------------------- Rajiv > -----Original Message----- > From: Sam Spritzer [SMTP:SSpritzer@GW.CTG.COM] > Sent: Thursday, January 06, 2000 2:48 PM > To: SQR-USERS@list.iex.net > Subject: This is not trivia pursuit.... > > Don't you just love it when clueless users make a request that, in their > world, makes perfect sense to them within the realm of their logic and > common > sense.....hence, take a look at the following. > > I am trying to update a varchar(30) column from one table with a > varchar(30) column from another table. I have already tested both columns > for null > values....and there aren't any. Can any of you shed any light in this? > > ********************************************* > SQL*Plus: Release 3.3.2.0.2 - Production on Thu Jan 06 16:26:11 2000 > > Copyright (c) Oracle Corporation 1979, 1994. All rights reserved. > > > Connected to: > Oracle7 Server Release 7.3.4.3.0 - Production > With the distributed, replication, parallel query and Spatial Data options > PL/SQL Release 2.3.4.3.0 - Production > > SQL> update ps_employment a > 2 set a.business_title = (select b.jobtitle > 3 from ps_employees b > 4 where a.emplid = b.emplid); > from ps_employees b > * > ERROR at line 3: > ORA-01407: cannot update mandatory (NOT NULL) column to NULL > **************************************** > > SQRly yours, > Sam From owner-sqr-users@list.iex.net Thu Jan 6 17:40:27 2000 Date: Thu, 6 Jan 2000 17:23:01 -0500 From: Greg Hesla Subject: Re: This is not trivia pursuit.... There is an employee in the employment table who is not in the employees table. HTH ================================ Greg Hesla ghesla@cimaconsulting.com Cima Consulting Group www.cimaconsulting.com ================================ ----- Original Message ----- From: "Sam Spritzer" To: Sent: Thursday, January 06, 2000 4:48 PM Subject: This is not trivia pursuit.... > Don't you just love it when clueless users make a request that, in their world, makes perfect sense to them within the realm of their logic and common > sense.....hence, take a look at the following. > > I am trying to update a varchar(30) column from one table with a varchar(30) column from another table. I have already tested both columns for null > values....and there aren't any. Can any of you shed any light in this? > > ********************************************* > SQL*Plus: Release 3.3.2.0.2 - Production on Thu Jan 06 16:26:11 2000 > > Copyright (c) Oracle Corporation 1979, 1994. All rights reserved. > > > Connected to: > Oracle7 Server Release 7.3.4.3.0 - Production > With the distributed, replication, parallel query and Spatial Data options > PL/SQL Release 2.3.4.3.0 - Production > > SQL> update ps_employment a > 2 set a.business_title = (select b.jobtitle > 3 from ps_employees b > 4 where a.emplid = b.emplid); > from ps_employees b > * > ERROR at line 3: > ORA-01407: cannot update mandatory (NOT NULL) column to NULL > **************************************** > > SQRly yours, > Sam > From owner-sqr-users@list.iex.net Thu Jan 6 17:40:58 2000 Date: Thu, 6 Jan 2000 17:29:24 -0500 From: Sam Spritzer Subject: Re: This is not trivia pursuit.... Thanks Raj and to those who respond but this solution did work. Even though I had b.emplid = a.emplid in the sub-select, I also had to consider the possibility of matching, or at least, checking for the existence of emplids in the main select. EMPLOYMENT is populated with everyone whereas, EMPLOYEES is only a selected group. Thanks again! Sam <<< 1/ 6 5:16p >>> Sam Try the following statement: SQL> update ps_employment a 2 set a.business_title = (select b.jobtitle 3 from ps_employees b 4 where a.emplid = b.emplid) 5.where exists ( select 'x' from ps_employee b1 where b1.emplid = a.empid) ; HTH -------------------- Rajiv > -----Original Message----- > From: Sam Spritzer [SMTP:SSpritzer@GW.CTG.COM] > Sent: Thursday, January 06, 2000 2:48 PM > To: SQR-USERS@list.iex.net > Subject: This is not trivia pursuit.... > > Don't you just love it when clueless users make a request that, in their > world, makes perfect sense to them within the realm of their logic and > common > sense.....hence, take a look at the following. > > I am trying to update a varchar(30) column from one table with a > varchar(30) column from another table. I have already tested both columns > for null > values....and there aren't any. Can any of you shed any light in this? > > ********************************************* > SQL*Plus: Release 3.3.2.0.2 - Production on Thu Jan 06 16:26:11 2000 > > Copyright (c) Oracle Corporation 1979, 1994. All rights reserved. > > > Connected to: > Oracle7 Server Release 7.3.4.3.0 - Production > With the distributed, replication, parallel query and Spatial Data options > PL/SQL Release 2.3.4.3.0 - Production > > SQL> update ps_employment a > 2 set a.business_title = (select b.jobtitle > 3 from ps_employees b > 4 where a.emplid = b.emplid); > from ps_employees b > * > ERROR at line 3: > ORA-01407: cannot update mandatory (NOT NULL) column to NULL > **************************************** > > SQRly yours, > Sam From owner-sqr-users@list.iex.net Thu Jan 6 17:52:05 2000 Date: Thu, 6 Jan 2000 17:38:17 -0500 From: Greg Hesla Subject: Re: This is not trivia pursuit.... I should have suggested a fix rather than just pointing out what was wrong... Anyway, here's what I'd do... update ps_employment a set a.business_title = (select b.jobtitle from ps_employees b where a.emplid = b.emplid) where exists (select 'x' from ps_employees where emplid = a.emplid); ================================ Greg Hesla ghesla@cimaconsulting.com Cima Consulting Group www.cimaconsulting.com ================================ ----- Original Message ----- From: "Sam Spritzer" To: Sent: Thursday, January 06, 2000 4:48 PM Subject: This is not trivia pursuit.... > Don't you just love it when clueless users make a request that, in their world, makes perfect sense to them within the realm of their logic and common > sense.....hence, take a look at the following. > > I am trying to update a varchar(30) column from one table with a varchar(30) column from another table. I have already tested both columns for null > values....and there aren't any. Can any of you shed any light in this? > > ********************************************* > SQL*Plus: Release 3.3.2.0.2 - Production on Thu Jan 06 16:26:11 2000 > > Copyright (c) Oracle Corporation 1979, 1994. All rights reserved. > > > Connected to: > Oracle7 Server Release 7.3.4.3.0 - Production > With the distributed, replication, parallel query and Spatial Data options > PL/SQL Release 2.3.4.3.0 - Production > > SQL> update ps_employment a > 2 set a.business_title = (select b.jobtitle > 3 from ps_employees b > 4 where a.emplid = b.emplid); > from ps_employees b > * > ERROR at line 3: > ORA-01407: cannot update mandatory (NOT NULL) column to NULL > **************************************** > > SQRly yours, > Sam > From owner-sqr-users@list.iex.net Thu Jan 6 18:00:56 2000 Date: Thu, 6 Jan 2000 14:54:11 -0800 From: Robert Stojkovic Subject: Re: This is not trivia pursuit.... Hi Sam Your update has 2 issues. 1. The employees table has multiple rows for each employee and empl_rcd# while employment has only 1 row per employee and empl_rcd#. 2. The employees table is updated by an Sqr you may have an employee that is not in the employees table therefore it is trying to update with a blank value for that employee. Have you modified the Sqr that populates the employees table. All the data that is in employees should be coming out of JOB, Personal data, and Employment. Why are you having to update a core table with the values in a reporting table derived from the core tables. Hope this helps Robert Stojkovic robert.stojkovic@io-consulting .com visit our website www.io-consulting.com 661 803 3178 > -----Original Message----- > From: Discussion of SQR, Brio Technology's database reporting language > [mailto:SQR-USERS@list.iex.net]On Behalf Of Sam Spritzer > Sent: Thursday, January 06, 2000 1:48 PM > To: SQR-USERS@list.iex.net > Subject: This is not trivia pursuit.... > > > Don't you just love it when clueless users make a request that, > in their world, makes perfect sense to them within the realm of > their logic and common > sense.....hence, take a look at the following. > > I am trying to update a varchar(30) column from one table with a > varchar(30) column from another table. I have already tested both > columns for null > values....and there aren't any. Can any of you shed any light in this? > > ********************************************* > SQL*Plus: Release 3.3.2.0.2 - Production on Thu Jan 06 16:26:11 2000 > > Copyright (c) Oracle Corporation 1979, 1994. All rights reserved. > > > Connected to: > Oracle7 Server Release 7.3.4.3.0 - Production > With the distributed, replication, parallel query and Spatial Data options > PL/SQL Release 2.3.4.3.0 - Production > > SQL> update ps_employment a > 2 set a.business_title = (select b.jobtitle > 3 from ps_employees b > 4 where a.emplid = b.emplid); > from ps_employees b > * > ERROR at line 3: > ORA-01407: cannot update mandatory (NOT NULL) column to NULL > **************************************** > > SQRly yours, > Sam > From owner-sqr-users@list.iex.net Thu Jan 6 19:44:57 2000 Date: Thu, 6 Jan 2000 18:34:33 -0600 From: Carlton Conley Subject: Re: This is not trivia pursuit.... Try the following update ps_employment a set a.business_title = (select b.jobtitle from ps_employees b where a.emplid = b.emplid) where exists (select 'X' from ps_employees b where a.emplid = b.emplid); Carlton From owner-sqr-users@list.iex.net Thu Jan 6 22:12:43 2000 Date: Fri, 7 Jan 2000 11:06:02 +0800 From: Tam Siu Tung Subject: Re: Font Size in SQR?? I would like to ask can I use the Font = 5 at the first part of the report and then use Font = 8 at the middle partand then change back to font = 5 agin in the last part? I try to change the font to bigger, but it can't change to smaller again! On Thu, 6 Jan 2000, Mark Risman wrote: > If you want to change the default font size or other similar attributes of the whole SQR, you can also use DECLARE-PRINTER (available in SQR 3 and up) or DECLARE PRINTER (deprecated in SQR 3 and up). > > - Mark > > -----Original Message----- > From: Ray Ontko [mailto:rayo@ONTKO.COM] > Sent: Thursday, January 06, 2000 8:21 AM > To: SQR-USERS@list.iex.net > Subject: Re: Font Size in SQR?? > > Howdy, > > > I would like to ask that how to change the font to be bigger in > > SQR? My printer is Xerox 4215/MRP2! > > It appears that the Xerox 4215/MRP2 supports HP PCL and Adobe PostScript: > > http://www.mrsp.com/products/42154219/ > > If you can figure out how to put the printer into PCL or PostScript > "mode", then you can use SQR with -printer:hp or -printer:ps to > generate PCL or PostScript output. > > Then, to change the font, use the ALTER-PRINTER command to change > the font-size, character-set, type-face, etc. > > Ray > ---------------------------------------------------------------------- > Ray Ontko rayo@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 > Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > From owner-sqr-users@list.iex.net Fri Jan 7 09:14:37 2000 Date: Fri, 7 Jan 2000 09:00:03 -0500 From: Ray Ontko Subject: Re: Font Size in SQR?? Tam, Here's an example for a PS printer or SPF output (-printer:ps, -printer:wp, or -keep): begin-program do main end-program begin-procedure main alter-printer point-size=10 print 'Howdy' (1,1) alter-printer point-size=20 print 'Podner' (10,1) end-procedure ! main Here's an example for an HP printer (-printer:hp): begin-program do main end-program begin-procedure main alter-printer pitch=12 print 'Howdy' (1,1) alter-printer pitch=6 print 'Podner' (10,1) end-procedure ! main I think that HP printers use pitch to determine size for fixed-pitch fonts, while PS printers and SPF use point-size to determine size for fonts. This should work on all types of printers: begin-program do main end-program begin-procedure main alter-printer point-size=10 pitch=12 print 'Howdy' (1,1) alter-printer point-size=20 pitch=6 print 'Podner' (10,1) end-procedure ! main Ray > I would like to ask can I use the Font = 5 at the first part of the report > and then use Font = 8 at the middle partand then change back to font = 5 > agin in the last part? > I try to change the font to bigger, but it can't change to smaller again! > > > > On Thu, 6 Jan 2000, Mark Risman wrote: > > > If you want to change the default font size or other similar attributes of the whole SQR, you can also use DECLARE-PRINTER (available in SQR 3 and up) or DECLARE PRINTER (deprecated in SQR 3 and up). > > > > - Mark > > > > -----Original Message----- > > From: Ray Ontko [mailto:rayo@ONTKO.COM] > > Sent: Thursday, January 06, 2000 8:21 AM > > To: SQR-USERS@list.iex.net > > Subject: Re: Font Size in SQR?? > > > > Howdy, > > > > > I would like to ask that how to change the font to be bigger in > > > SQR? My printer is Xerox 4215/MRP2! > > > > It appears that the Xerox 4215/MRP2 supports HP PCL and Adobe PostScript: > > > > http://www.mrsp.com/products/42154219/ > > > > If you can figure out how to put the printer into PCL or PostScript > > "mode", then you can use SQR with -printer:hp or -printer:ps to > > generate PCL or PostScript output. > > > > Then, to change the font, use the ALTER-PRINTER command to change > > the font-size, character-set, type-face, etc. > > > > Ray > > ---------------------------------------------------------------------- > > Ray Ontko rayo@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 > > Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > > > ---------------------------------------------------------------------- Ray Ontko rayo@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ From owner-sqr-users@list.iex.net Fri Jan 7 09:27:14 2000 Date: Fri, 7 Jan 2000 09:14:54 -0500 From: Rick_Creel@AONCONS.COM Subject: Re: This is not trivia pursuit.... I strongly AGREE with what John Ferguson has said....... no purpose was served in ridiculing the question or the intelligence of the person asking the question. John Ferguson on 01/06/2000 05:08:21 PM Please respond to sqr-users@list.iex.net To: SQR-USERS@list.iex.net cc: (bcc: Rick Creel/IT/Aon Consulting) Subject: Re: This is not trivia pursuit.... I thought the whole purpose of this group was to help each other out. Not everyone can be a smart as you think you are. It would have served everyone better if you just pointed out the mistake instead of making a joke about it. If you remember back to when you started coding, I'm sure you didn't have all of the answers. Think about that next you consider any question stupid or people as clueless. John Sam Spritzer wrote: > Don't you just love it when clueless users make a request that, in their world, makes perfect sense to them within the realm of their logic and common > sense.....hence, take a look at the following. > > I am trying to update a varchar(30) column from one table with a varchar(30) column from another table. I have already tested both columns for null > values....and there aren't any. Can any of you shed any light in this? > > ********************************************* > SQL*Plus: Release 3.3.2.0.2 - Production on Thu Jan 06 16:26:11 2000 > > Copyright (c) Oracle Corporation 1979, 1994. All rights reserved. > > Connected to: > Oracle7 Server Release 7.3.4.3.0 - Production > With the distributed, replication, parallel query and Spatial Data options > PL/SQL Release 2.3.4.3.0 - Production > > SQL> update ps_employment a > 2 set a.business_title = (select b.jobtitle > 3 from ps_employees b > 4 where a.emplid = b.emplid); > from ps_employees b > * > ERROR at line 3: > ORA-01407: cannot update mandatory (NOT NULL) column to NULL > **************************************** > > SQRly yours, > Sam From owner-sqr-users@list.iex.net Fri Jan 7 11:36:27 2000 Date: Fri, 7 Jan 2000 11:01:10 -0500 From: *Haixiang Yee Subject: Ways to clear a lookup table. Hi, I have a program that builds a lookup table through each iteration under different criteria. Apparently, the table does not get cleared each time you rebuild it based on different criteria. In fact, it produces an error if I try to build it a second time. Its there ways to get around this? For example: while 1 do Get-Lookup-Where-Clause do Build-LookupTable-ABC do Other-Things end-while It would error out during the second iteration of the loop. Thanks, -Hai From owner-sqr-users@list.iex.net Fri Jan 7 11:39:05 2000 Date: Fri, 7 Jan 2000 10:18:37 -0600 From: itzgee Subject: Re: this is not trivial pursuit - give sam a break Uh ... I think Sam was poking fun at himself. If you read carefully, you'll notice that he was the original poster of the message. Sam Spritzer wrote: > Don't you just love it when clueless users make a request that, in their world, makes perfect sense to them within the realm of their logic and common > sense.....hence, take a look at the following. > > I am trying to update a varchar(30) column from one table with a varchar(30) column from another table. I have already tested both columns for null > values....and there aren't any. Can any of you shed any light in this? > > ********************************************* > SQL*Plus: Release 3.3.2.0.2 - Production on Thu Jan 06 16:26:11 2000 > > Copyright (c) Oracle Corporation 1979, 1994. All rights reserved. > > Connected to: > Oracle7 Server Release 7.3.4.3.0 - Production > With the distributed, replication, parallel query and Spatial Data options > PL/SQL Release 2.3.4.3.0 - Production > > SQL> update ps_employment a > 2 set a.business_title = (select b.jobtitle > 3 from ps_employees b > 4 where a.emplid = b.emplid); > from ps_employees b > * > ERROR at line 3: > ORA-01407: cannot update mandatory (NOT NULL) column to NULL > **************************************** > > SQRly yours, > Sam From owner-sqr-users@list.iex.net Fri Jan 7 11:38:55 2000 Date: Fri, 7 Jan 2000 17:19:53 +0100 From: Philippe DAVID Subject: Prevent Windows Hello folks ! I have a SQR program which edit statistics. I launch it with a little batch.( c:\sqribe\sqr\syb\binw\sqrw f:\devsqr\essais\test2 philipped/xxxxxx -VGLENAT38SYB -DBtest -Ftest2.lis 'HP' '' -PRINTER:HP -DEBUG -KEEP ) I want to avoid the opening of the first MD-DOS window and keep the window opened by my program only. If I use the flag -XCB, I have no window at all but I really want to keep the second window 'cause I've done a beautiful presentation Has someone an idea? Thanks a lot and happy new Y2K Philippe DAVID Editions GLENAT 6 rue Lt Chanaron 38000 GRENOBLE 33 (0)4 76 88 75 92 From owner-sqr-users@list.iex.net Fri Jan 7 13:13:04 2000 Date: Fri, 7 Jan 2000 11:33:18 -0500 From: Pamela Lantzy Subject: Re: Prevent Windows You can set the properties of the first window to close on exit. I have a dos window on my desktop that executes a bat file Right click on properties of the icon select the program tab and check the close on exit -----Original Message----- From: Philippe DAVID [mailto:Philippe.DAVID@GLENAT.COM] Sent: Friday, January 07, 2000 11:20 AM To: SQR-USERS@LIST.IEX.NET Subject: Prevent Windows Hello folks ! I have a SQR program which edit statistics. I launch it with a little batch.( c:\sqribe\sqr\syb\binw\sqrw f:\devsqr\essais\test2 philipped/xxxxxx -VGLENAT38SYB -DBtest -Ftest2.lis 'HP' '' -PRINTER:HP -DEBUG -KEEP ) I want to avoid the opening of the first MD-DOS window and keep the window opened by my program only. If I use the flag -XCB, I have no window at all but I really want to keep the second window 'cause I've done a beautiful presentation Has someone an idea? Thanks a lot and happy new Y2K Philippe DAVID Editions GLENAT 6 rue Lt Chanaron 38000 GRENOBLE 33 (0)4 76 88 75 92 From owner-sqr-users@list.iex.net Fri Jan 7 12:25:17 2000 Date: Fri, 7 Jan 2000 10:34:36 -0600 From: KBLUMEN@SEARS.COM Subject: Re: Ways to clear a lookup table. --0__=AIcOrcFdi6bIe9K3vZFUtFEmd1t3LuK3XccXc2Ggoc7yFSCQvXzkOVR1 Content-type: text/plain; charset=us-ascii Content-Disposition: inline You could create a unique lookup table name within the loop with each iteration by doing something like this: let #num = 0 while 1 do Get-Lookup-Where-Clause do Build-LookupTable-ABC (in this procedure concate the lookup table name with num) do Other-Things add 1 to num end-while (Embedded image moved *Haixiang Yee to file: 01/07/2000 10:01 AM pic32406.pcx) Please respond to sqr-users@list.iex.net To: SQR-USERS@list.iex.net cc: (bcc: Kimberly Blumenberg) Subject: Ways to clear a lookup table. Hi, I have a program that builds a lookup table through each iteration under different criteria. Apparently, the table does not get cleared each time you rebuild it based on different criteria. In fact, it produces an error if I try to build it a second time. Its there ways to get around this? For example: while 1 do Get-Lookup-Where-Clause do Build-LookupTable-ABC do Other-Things end-while It would error out during the second iteration of the loop. Thanks, -Hai --0__=AIcOrcFdi6bIe9K3vZFUtFEmd1t3LuK3XccXc2Ggoc7yFSCQvXzkOVR1 Content-type: application/octet-stream; name="pic32406.pcx" Content-Disposition: attachment; filename="pic32406.pcx" Content-transfer-encoding: base64 CgUBCAAAAABoACwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAABaQABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAD1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPH E8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sT zRPHE8MTwhPwEwzIBgzYE8wTxhPDE8IT7hPOBtcTzBPGE8MTE+wTwgbCBwbCEgbCEgbCEsUG1hPL E8YTwxMT6hMMwgYHwgLCAwISwgfEEsMCwwbVE8sTxRPDExPpE8MGAwcCBwMCwhLDB8ISwgISwgLD BtUTyhPFE8MTE+gTwgIHA8ICEw4DDgLDE8USwwLCEMIG1BPKE8UTwxMT5xMCAwcDAg4TDgITwgIS D8ISD8ISBRICEcICwwbUE8oTxRPCExPmEwYCBwMCDgIOwgLDExITEhPCEg8GxgLDBtMMDAfJE8QT whMT5hMGwwITBgMCDhLFEw8SE8ISBgIDwhIDEsMGB9MDxwwHxRPDExPlEwYHAhESAg8CwhMPwhMP xBMPxRIQwgIDAgMCBtMDxwPEDAfDE8IT4RMHwwzCBgLCEhMCDxLIE8MSD8MSwwIQAwIDBgfSDMkD wgPCDAfCExPbEwfGDMIDDAIHERITEhMSwxMPwxMPwxPDEgIDAgMCwwMCBgzREwfHDMYDDMITE9YT B8UMyAMGB8ICBhLDAsYTEhMSExIPwhIHAgcCAwUQAgYRBgfSE8UTB8QMwgMMwhMT0hMHxAzLA8IM BsISDxESExITAw4DxBMSExITwxICBwPCAsMDDMIGB9ITyRMHwwzCExPPEwfDDMkDxQwHwhMGBxIT AhECEwMOAg7DExITDxMPwxIDAgMCBwMCDAYRBgfSE8kTwhPCDMITE8wTB8MMxwPEDMIHxxMGxBLD Ag4DDgIGwg/IEgIDwgIDAgwCEMIGB9ITyRMHDAcMwhMTyhMHwgzGA8MMwgfMEwYHwhLCEAIOAg4C DhDDAhIPxhIFAgXDAgUCEQYH0hPHEwfCDAcPDMITE8gTB8IMxQPDDAfQEwbDEhDEAhAOEA4QwgLG EgcSBhIGBcMCBcIGB9ATB8UMEwfCDA8HDwwHwhMTxhMHwgzEA8MMB9MTBgfCEhADEMICDhAOEMIC EQIDxxIGBwbCAgUCEQYHyxMHxAwHwhMHEwzCEwcPBw8MB8MTE8UTBwzEA8IMB9YTBsQSEAMCA8UC EQIDAgPDEgcSBgfCBgUQAhDCBgfGEwfEDAfGE8INEwzCEw8HwgwHwxPCE8QTBwzDA8IMB9gTBgfE EhACEMYCEQIDAsQSBhLDBsICEALCBgfCEwfDDAfKEwfCDRMHwhPCDAfEE8ITE8MTBwzCA8IMB9oT DBIHwxLDDBEDxQIDAgPDEgYSBgfCBgIQAhAGDAfCEwzDE8MHyRMHwhPCBxMHxRPDExPDEwzCAwwH 3RMGxxICEQPDAgMCA8MSBhIGBwYMBhACEAIGDMMTDBPCB8YTwwfHEwfGE8MTwhPDEwwDDAfeEwYH xxICEQPDAgMCwhIGEgYHBgwGEAIQAsIGB8MTDMYTwwfKEwzGE8MTwhPDE8IMB98TDBLCB8USAgMR xAISB8ISBgcGDAYQBhAGEAYMB8MMB8kTwwfHEwzGE8MTwhPDEwwPwgzfEwYSB8ISB8ISAhECAwID EgcSBwYHBgwGEAYQxgzDD8IHxRPDB8kTBwzGE8MTwhPDEwzDD8QM3BPCBhIGwxIGAhECAwIHBgcG yAzJDxMHzRMHwwwHxxPDE8ITwxMHDMYPxwwH1BMGEgYSBhLLDM4PwwwTDMcTwgfEDAfJE8QTwhMT xBMHwgzLD9sM0w/GDAfDEwzDEwfEDAfLE8YTwxMTxhMHxAztD8gMBgfIE8QMB84TxxPDE8ITyhMH xwzbD8sMEAUMBcIMwgYH1RPKE8UTwxMT0RMH2wwGEAYQBhACBQwFDAUMBgwHBgfWE8sTxRPDExPu EwYMBhAGEAIGDAYMwwYH1xPLE8YTwxMT8BPKBgfYE8wTxhPDExP1E9sTzRPHE8MTwhP1E9sTzRPH E8MTwhMMAAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD/ /wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8A AAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A //8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAA AP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA /wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCk gICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vw oKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw //vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzA psrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDA wNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICA wMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACA AICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACA gACA//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP////// --0__=AIcOrcFdi6bIe9K3vZFUtFEmd1t3LuK3XccXc2Ggoc7yFSCQvXzkOVR1-- From owner-sqr-users@list.iex.net Fri Jan 7 12:04:50 2000 Date: Fri, 7 Jan 2000 11:35:27 -0500 From: Rick_Creel@AONCONS.COM Subject: Re: Ways to clear a lookup table. How about adding a "clear table" section ? As an example: while 1 do Get-Lookup-Where-Clause do Clear-Lookup-Table ! This section will either delete or truncate the lookup table do Build-LookupTable-ABC do Other-Things end-while begin-procedure Clear-Lookup-Table begin-sql on-error=sql_error truncate table ps_LookupTable-ABC ! Your specific table name here end-sql end-procedure Clear-Lookup-Table *Haixiang Yee on 01/07/2000 11:01:10 AM Please respond to sqr-users@list.iex.net To: SQR-USERS@list.iex.net cc: (bcc: Rick Creel/IT/Aon Consulting) Subject: Ways to clear a lookup table. Hi, I have a program that builds a lookup table through each iteration under different criteria. Apparently, the table does not get cleared each time you rebuild it based on different criteria. In fact, it produces an error if I try to build it a second time. Its there ways to get around this? For example: while 1 do Get-Lookup-Where-Clause do Build-LookupTable-ABC do Other-Things end-while It would error out during the second iteration of the loop. Thanks, -Hai From owner-sqr-users@list.iex.net Fri Jan 7 13:57:50 2000 Date: Fri, 7 Jan 2000 10:42:25 -0600 From: Krishnan Sarangarajan Subject: Re: Prevent Windows This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_01BF592E.2E677304 Content-Type: text/plain; charset="iso-8859-1" Philippe - If I am understanding you correctly, you want to close the DOS window that runs the SQR and leave the SQR window maximized. I do not know how to achieve this but you can try the following : 1. Right click on the batch program that you have created and select properties. Refer to the "mainscr.rtf" for an example. 2. Now, click on the second tab, titled "Shortcut" as shown in "runscr.rtf" and select as desired from the "Run" drop down list. You will need to select "Minimized". This should provide with you what something close to what you wanted to achieve. Hope this helps. Sincerely, Krishnan Ruan Transportation Management Systems (515) 245-5655 [P] (515) 247-2065 [F] ksaranga@ruan.com -----Original Message----- From: Philippe DAVID [mailto:Philippe.DAVID@GLENAT.COM] Sent: Friday, January 07, 2000 10:20 AM To: SQR-USERS@list.iex.net Subject: Prevent Windows Hello folks ! I have a SQR program which edit statistics. I launch it with a little batch.( c:\sqribe\sqr\syb\binw\sqrw f:\devsqr\essais\test2 philipped/xxxxxx -VGLENAT38SYB -DBtest -Ftest2.lis 'HP' '' -PRINTER:HP -DEBUG -KEEP ) I want to avoid the opening of the first MD-DOS window and keep the window opened by my program only. If I use the flag -XCB, I have no window at all but I really want to keep the second window 'cause I've done a beautiful presentation Has someone an idea? Thanks a lot and happy new Y2K Philippe DAVID Editions GLENAT 6 rue Lt Chanaron 38000 GRENOBLE 33 (0)4 76 88 75 92 ------_=_NextPart_000_01BF592E.2E677304 Content-Type: application/rtf; name="mainscr.rtf" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="mainscr.rtf" Content-Location: ATT-0-3F93841020C5D31194DD0008C72482BE-m ainscr.rtf {\rtf1\ansi\ansicpg1252\deff0\deftab720{\fonttbl{\f0\fswiss MS Sans = Serif;}{\f1\froman\fcharset2 Symbol;}{\f2\froman Times New Roman;}} {\colortbl\red0\green0\blue0;} \deflang1033\horzdoc{\*\fchars }{\*\lchars }\pard\plain\f2\fs20 = {\pict\wmetafile8\picw9947\pich12195\picwgoal5639\pichgoal6913 010009000003055701000200AE5401000000050000000B0200000000050000000C02A32F= DB2605 020000F70000030001000000008000000000800000808000000000800080008000008080= 00C0C0 C000C0DCC000A6CAF0000C0004001C0C1000212121002908000029291800212921002931= 310031 101800311808003131210031312900313131003900100039001800390808003929100039= 423900 42001000420018004218210042422900424A31004A0808004A0818004A1808004A213100= 4A2929 004A3139004A3939004A4239004A4A4A0052312100525252005A0008005A1000005A1021= 005A18 00005A2108005A2121005A2139005A3131005A394A005A4239005A4A4A005A4A52005A5A= 5A0063 081800632121006331100063312100635A5200635A5A00636363006B0008006B0800006B= 081800 6B3131006B394A006B4239006B4A4A006B4A52006B525A006B6363006B6B6B0073423100= 735A42 00735A4A00736B630073737300737B7B007B0008007B2129007B4A39007B4A52007B6352= 007B6B 63007B7373007B7B7B007B8484008418210084423900845A4200845A5200846B73008473= 5A0084 7B840084846B0084847B00848484008C0000008C3129008C3139008C5263008C737B0094= 212900 9439310094525A009452630094634A00946B6300946B7B00947B6B00947B8400948C8400= 948C8C 0094948C0094949400949C9C009C1008009C1810009C1818009C3129009C4252009C5239= 009C63 73009C736300B5080800C6081000CE081000A5101000AD101000B5101000AD101800C610= 1800A5 181000C6182100D6182100A5211800BD212100A5212900B5213900AD292100AD312100AD= 4A3100 B5292900B5312900B5313100B5392900CE292900BD293100BD312900CE393100B54A3100= B55239 00CE423900D2463900C6294200C6314A00AD394200BD3D4E00C6525A00C65A4200B1565A= 00CE39 4A00D6424A00D23D5A00D64A4200CE524A00DA4A4A00DE525A00C65A6300C66B5200B573= 6000B5 737300AD6B7B00B1738400C86D7B00C67B7B00DE5A5200D65A6300DB685D00D6736B00CE= 6B7B00 DB6D7B00DE737F009C949400A57B8C00A5848C00A58C7B00AD846B00AD8C7300B58C7B00= B5948C 00C1847700CE846B00CE847B00CE907700BD7B8400BD848C00C67B8C00CE8C8C00CE948C= 00CE9C 8C00D6846300D68C7300D68C8400D6948C00DE948400DE9C8400DE9C8C00E7848400E78C= 7300E7 9C9400E7A58400E7A59400EFA594009C9C9C00AD949C00BD8C9C00C6B59C00CE849C00CE= 949C00 D68C9C0029292900D6949C0042424200E79C9C00EFA59C00A5A5A500ADA5A500B594A500= BDA5A5 00DE94A500A5ADAD00ADADAD00B59CAD00D694AD00DE94AD00E79CAD00B5B5B500BDBDBD= 00C6C6 C600D6D6D600DEDEDE00E7E7E700BF000000FFFBF000A0A0A40080808000FF00000000FF= 0000FF FF00000000FF00FF00FF0000FFFF00FFFFFF000400000034020000030000003500AE5401= 00430F 2000CC000000CD01780100000000A32FDB26000000002800000078010000CD0100000100= 080000 00000018A50200C40E0000C40E0000000000000000000000000000000080000080000000= 808000 800000008000800080800000C0C0C000C0DCC000F0CAA60004000C00100C1C0021212100= 000829 001829290021292100313129001810310008183100213131002931310031313100100039= 001800 390008083900102939003942390010004200180042002118420029424200314A42000808= 4A0018 084A0008184A0031214A0029294A0039314A0039394A0039424A004A4A4A002131520052= 525200 08005A0000105A0021105A0000185A0008215A0021215A0039215A0031315A004A395A00= 39425A 004A4A5A00524A5A005A5A5A0018086300212163001031630021316300525A63005A5A63= 006363 630008006B0000086B0018086B0031316B004A396B0039426B004A4A6B00524A6B005A52= 6B0063 636B006B6B6B0031427300425A73004A5A7300636B7300737373007B7B730008007B0029= 217B00 394A7B00524A7B0052637B00636B7B0073737B007B7B7B0084847B002118840039428400= 425A84 00525A8400736B84005A738400847B84006B8484007B8484008484840000008C0029318C= 003931 8C0063528C007B738C0029219400313994005A529400635294004A639400636B94007B6B= 94006B 7B9400847B9400848C94008C8C94008C949400949494009C9C940008109C0010189C0018= 189C00 29319C0052429C0039529C0073639C0063739C000808B5001008C6001008CE001010A500= 1010AD 001010B5001810AD001810C6001018A5002118C6002118D6001821A5002121BD002921A5= 003921 B5002129AD002131AD00314AAD002929B5002931B5003131B5002939B5002929CE003129= BD0029 31BD003139CE00314AB5003952B5003942CE003946D2004229C6004A31C6004239AD004E= 3DBD00 5A52C600425AC6005A56B1004A39CE004A42D6005A3DD200424AD6004A52CE004A4ADA00= 5A52DE 00635AC600526BC6006073B5007373B5007B6BAD008473B1007B6DC8007B7BC600525ADE= 00635A D6005D68DB006B73D6007B6BCE007B6DDB007F73DE0094949C008C7BA5008C84A5007B8C= A5006B 84AD00738CAD007B8CB5008C94B5007784C1006B84CE007B84CE007790CE00847BBD008C= 84BD00 8C7BC6008C8CCE008C94CE008C9CCE006384D600738CD600848CD6008C94D6008494DE00= 849CDE 008C9CDE008484E700738CE700949CE70084A5E70094A5E70094A5EF009C9C9C009C94AD= 009C8C BD009CB5C6009C84CE009C94CE009C8CD600292929009C94D600424242009C9CE7009CA5= EF00A5 A5A500A5A5AD00A594B500A5A5BD00A594DE00ADADA500ADADAD00AD9CB500AD94D600AD= 94DE00 AD9CE700B5B5B500BDBDBD00C6C6C600D6D6D600DEDEDE00E7E7E7000000BF00F0FBFF00= A4A0A0 00808080000000FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00070707= 070707 000707070707000707000707070707070707070707070707070707070707070707070707= 070700 070707070707070700000000070707070707070707070707000707070707070707070707= 070700 070707070707F800070707FF07070707F8F8F8F8F8F8F8F8F8F8F8F8F800070707070000= 000000 070707070707070707070707070707070707070707070707070707070707070707070007= 070707 070707070700070007070707070707070707070007070707070707070707070707070707= 070707 070707070707070707070007070707070007070707070707070707070707070707070707= F80007 070700F807FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF= 07FF07 FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07= FF07FF 07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF= 07FF07 FF07FF07FF07FF07FF07FF07FF07FF07FF07FF0707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 07070707070707070707070707070707070707070707070707070707070707F800070707= FF0707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 07070707070707070707070707070707070707070707F80007070700F8FF07FF07FF07FF= 07FF07 FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07= FF07FF 07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF= 07FF07 FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07= FF07FF 07FF07FF0707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 0707070707070707070707070707070707F800070707FF07070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 0707070707070707F80007070700F807FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07= FF07FF 07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF= 07FF07 FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07= FF07FF 07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707F800070707FF070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707F80007= 070700 F8FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF= 07FF07 FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07= FF07FF 07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF07FF= 07FF07 FF07FF07FF07FF07FF07FF07FF07FF070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 07070707070707070707070707070707070707070707070707070707F800070707FF0707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 07070707070707070707070707070707070707F80007070700F8FFFFFFFFFFFFFFFFFFFF= FFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF= FFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF= FFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF= FFFFFF FFFF07070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 0707070707070707070707070707F800070707FF07070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 0707070707F80007070700F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8= F8F8F8 F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8= F8F8F8 F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8= F8F8F8 F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8F8FFFFFFFFFFFFFFFFFF= FFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF= FFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF= FFFFFF FF00070707FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF= FFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF= FFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF= FFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0007070700= 000000 000000000000000000000000000000000000000000000000000000000000000000000000= 000000 000000000000000000000000000000000000000000000000000000000000000000000000= 000000 000000000000000000000000000000000000000000000000000000000000000000000000= 000000 000000000000000000000000000707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707FFFFFFFFFFFFFFFFFFFFFFFF= FFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF= FFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF= FFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF= FFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF= FFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF= FFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF= FFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF= FFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF= FFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF= FFFFFF FFFFFFFFFFFFFFFFFFFF0707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= 070707 070707070707070707070707070707070707070707070707070707070707070707070707= FF0707 070707070707070707