Re: [U2] UniQuery COPY FROM syntax error - Weird behavior
Brian and Gregor, Thanks SO much for your suggestions. I checked the VOC entries and found that the FROM entry was indeed missing in our development account. I added it back and was able to perform the command. I really appreciate everyone's help with this. Cheers! Eric :ELE VOC File name = VOC. Record name = FROM New record. : I 0001= K 0002= FROM 0003= : FI FROM filed in file VOC :COPY FROM APPROVALS RECORD1, RECORD2 1 records copied ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UniQuery COPY FROM syntax error - Weird behavior
I have encountered a strange problem after mistyping the UniQuery COPY command in one of our development environments. The command tried to copy the same record to itself and failed gracefully but subsequent attempts to properly copy records in this environment fail with a syntax error. :COPY FROM APPROVALS RECORD1, RECORD1 Copying APPROVALS RECORD1 to RECORD1... RECORD1 exists in APPROVALS, cannot overwrite 0 records copied All copy statements now result in the message: :COPY FROM APPROVALS RECORD1, RECORD2 -^ syntax error We have several environments on the same server but our dev account seems to be the only one affected. Does anyone have any thoughts on what could be the problem and suggest a resolution. Thanks in advance. Eric ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery COPY FROM syntax error - Weird behavior
You seem to be missing a TO clause Eric Malmberg wrote: I have encountered a strange problem after mistyping the UniQuery COPY command in one of our development environments. The command tried to copy the same record to itself and failed gracefully but subsequent attempts to properly copy records in this environment fail with a syntax error. :COPY FROM APPROVALS RECORD1, RECORD1 Copying APPROVALS RECORD1 to RECORD1... RECORD1 exists in APPROVALS, cannot overwrite 0 records copied All copy statements now result in the message: :COPY FROM APPROVALS RECORD1, RECORD2 -^ syntax error We have several environments on the same server but our dev account seems to be the only one affected. Does anyone have any thoughts on what could be the problem and suggest a resolution. Thanks in advance. Eric ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery COPY FROM syntax error - Weird behavior
I dont remember is it U vs P mode in Unidata, I dont have an active install try lower case copy so Prime information copy style should kick in Eric Malmberg wrote: I have encountered a strange problem after mistyping the UniQuery COPY command in one of our development environments. The command tried to copy the same record to itself and failed gracefully but subsequent attempts to properly copy records in this environment fail with a syntax error. :COPY FROM APPROVALS RECORD1, RECORD1 Copying APPROVALS RECORD1 to RECORD1... RECORD1 exists in APPROVALS, cannot overwrite 0 records copied All copy statements now result in the message: :COPY FROM APPROVALS RECORD1, RECORD2 -^ syntax error We have several environments on the same server but our dev account seems to be the only one affected. Does anyone have any thoughts on what could be the problem and suggest a resolution. Thanks in advance. Eric ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Richard A Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery COPY FROM syntax error - Weird behavior
Actually, the statement I am using is copying a record with an old key to a new key in the same file (basically just changing the primary key keeping everything else identical). It is syntactically correct and works in other environments but the command interpreter is throwing an error in this one environment. Just tried the lower case copy and received the same error. Grrr... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery COPY FROM syntax error - Weird behavior
The use of COPY FROM is flavor dependent, per each accounts' setting ED VOC RELLEVEL is see your flavor for *this* account -Original Message- From: Eric Malmberg eric.malmb...@cpcc.edu To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Wed, Aug 1, 2012 3:12 pm Subject: Re: [U2] UniQuery COPY FROM syntax error - Weird behavior Actually, the statement I am using is copying a record with an old key to a new key in the same file (basically just changing the primary key keeping everything else identical). It is syntactically correct and works in other environments but the command interpreter is throwing an error in this one environment. Just tried the lower case copy and received the same error. Grrr... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery COPY FROM syntax error - Weird behavior
Can you compare the VOC entry of COPY in the other working accounts vs. the VOC COPY entry in your development account? Do they match? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Eric Malmberg Sent: Thursday, 2 August 2012 7:01 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniQuery COPY FROM syntax error - Weird behavior I have encountered a strange problem after mistyping the UniQuery COPY command in one of our development environments. The command tried to copy the same record to itself and failed gracefully but subsequent attempts to properly copy records in this environment fail with a syntax error. :COPY FROM APPROVALS RECORD1, RECORD1 Copying APPROVALS RECORD1 to RECORD1... RECORD1 exists in APPROVALS, cannot overwrite 0 records copied All copy statements now result in the message: :COPY FROM APPROVALS RECORD1, RECORD2 -^ syntax error We have several environments on the same server but our dev account seems to be the only one affected. Does anyone have any thoughts on what could be the problem and suggest a resolution. Thanks in advance. Eric ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Message protected by DealerGuard: e-mail anti-virus, anti-spam and content filtering. http://www.pentanasolutions.com Click here to report this message as spam: https://login.mailguard.com.au/report/1FgeDwxYsH/5dEbw3xNr22C0ByWltu3XD/2.212 This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery COPY FROM syntax error - Weird behavior
Check the VOC entries for COPY and FROM to ensure they are correct. It could be that something other than the failed COPY command has caused your problem by corrupting the FROM entry in the VOC. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Eric Malmberg Sent: Thursday, 2 August 2012 7:01 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniQuery COPY FROM syntax error - Weird behavior I have encountered a strange problem after mistyping the UniQuery COPY command in one of our development environments. The command tried to copy the same record to itself and failed gracefully but subsequent attempts to properly copy records in this environment fail with a syntax error. :COPY FROM APPROVALS RECORD1, RECORD1 Copying APPROVALS RECORD1 to RECORD1... RECORD1 exists in APPROVALS, cannot overwrite 0 records copied All copy statements now result in the message: :COPY FROM APPROVALS RECORD1, RECORD2 -^ syntax error We have several environments on the same server but our dev account seems to be the only one affected. Does anyone have any thoughts on what could be the problem and suggest a resolution. Thanks in advance. Eric ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Message protected by DealerGuard: e-mail anti-virus, anti-spam and content filtering. http://www.pentanasolutions.com Click here to report this message as spam: https://login.mailguard.com.au/report/1Fge2UMmSJ/1IopnSZLqhJubA54RdaPfK/3.307 This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery Output to File
And I've found that I need to be in type U for LIST ... TO DELIM to work. Type P gives syntax error Maybe there's a UDT.OPTION for that? Brad From: Colin Alfke alfke...@hotmail.com To: u2-users@listserver.u2ug.org Date: 06/02/2011 10:42 PM Subject:Re: [U2] UniQuery Output to File Sent by:u2-users-boun...@listserver.u2ug.org I've been using the LIST TO DELIM a lot lately. It works reasonably well although I don't use it for any MV'd data. You can enter a TAB as the delim and it will work. You can even put the full path for the text_file in the statement otherwise it's created in the current directory. As Wally says turn on UDT.OPTION 91 although I think dates are the only thing that really needs it. hth Colin Alfke Calgary Canada From: mstrand send UniQuery output to a file. Perhaps LIST TO DELIM? -- TO [DELIM char] text_file Lists records to a UNIX text file. If you use the DELIM keyword, UniData places char between each attribute in text_file. text_file cannot be strictly numeric. On 6/2/2011 9:43 PM, Bill Haskett wrote: I can't remember how to send UniQuery output to a file. I've looked all through Using UniQuery and the UniQuery Commands Reference with no luck. In D3, I could do whatever query I wanted and send it to a file as tab-delimeted, which would remove any headings, footings, breaks, subtotals, etc. I was sure UD could do something like this. When I tried to send output TOXML, wierd things happened to data that should have been on the same line as other data (it got separated from the line when I opened the file in Excel). This data was an I-Descriptor (Virtual Attribute) calling a BASIC subroutine. Any help would be appreciated. Thanks, Bill Haskett ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery Output to File
Even if you are in proc or in P mode, you can always use the lowercase version of the LIST verb to force U mode parsing of the query. Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Friday, June 03, 2011 6:23 AM To: U2 Users List Subject: Re: [U2] UniQuery Output to File And I've found that I need to be in type U for LIST ... TO DELIM to work. Type P gives syntax error Maybe there's a UDT.OPTION for that? Brad From: Colin Alfke alfke...@hotmail.com To: u2-users@listserver.u2ug.org Date: 06/02/2011 10:42 PM Subject:Re: [U2] UniQuery Output to File Sent by:u2-users-boun...@listserver.u2ug.org I've been using the LIST TO DELIM a lot lately. It works reasonably well although I don't use it for any MV'd data. You can enter a TAB as the delim and it will work. You can even put the full path for the text_file in the statement otherwise it's created in the current directory. As Wally says turn on UDT.OPTION 91 although I think dates are the only thing that really needs it. hth Colin Alfke Calgary Canada From: mstrand send UniQuery output to a file. Perhaps LIST TO DELIM? -- TO [DELIM char] text_file Lists records to a UNIX text file. If you use the DELIM keyword, UniData places char between each attribute in text_file. text_file cannot be strictly numeric. On 6/2/2011 9:43 PM, Bill Haskett wrote: I can't remember how to send UniQuery output to a file. I've looked all through Using UniQuery and the UniQuery Commands Reference with no luck. In D3, I could do whatever query I wanted and send it to a file as tab-delimeted, which would remove any headings, footings, breaks, subtotals, etc. I was sure UD could do something like this. When I tried to send output TOXML, wierd things happened to data that should have been on the same line as other data (it got separated from the line when I opened the file in Excel). This data was an I-Descriptor (Virtual Attribute) calling a BASIC subroutine. Any help would be appreciated. Thanks, Bill Haskett ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery Output to File
Many thanks Matthew Wally! :-) Bill - Original Message - *From:* wterh...@rocketsoftware.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 6/2/2011 7:05 PM *Subject:* Re: [U2] UniQuery Output to File Plus UDT.OPTIONS 91 ON if you want output conversions applied to the data before writing to the text file. Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Matthew Strand Sent: Thursday, June 02, 2011 7:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniQuery Output to File send UniQuery output to a file. Perhaps LIST TO DELIM? -- TO [DELIM char] text_file Lists records to a UNIX text file. If you use the DELIM keyword, UniData places char between each attribute in text_file. text_file cannot be strictly numeric. On 6/2/2011 9:43 PM, Bill Haskett wrote: I can't remember how to send UniQuery output to a file. I've looked all through Using UniQuery and the UniQuery Commands Reference with no luck. In D3, I could do whatever query I wanted and send it to a file as tab-delimeted, which would remove any headings, footings, breaks, subtotals, etc. I was sure UD could do something like this. When I tried to send output TOXML, wierd things happened to data that should have been on the same line as other data (it got separated from the line when I opened the file in Excel). This data was an I-Descriptor (Virtual Attribute) calling a BASIC subroutine. Any help would be appreciated. Thanks, Bill Haskett Advantos Systems, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery Output to File
And, as always, Colin. :-) - Original Message - *From:* wphask...@advantos.net *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 6/3/2011 9:14 AM *Subject:* Re: [U2] UniQuery Output to File Many thanks Matthew Wally! :-) Bill - Original Message - *From:* wterh...@rocketsoftware.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 6/2/2011 7:05 PM *Subject:* Re: [U2] UniQuery Output to File Plus UDT.OPTIONS 91 ON if you want output conversions applied to the data before writing to the text file. Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Matthew Strand Sent: Thursday, June 02, 2011 7:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniQuery Output to File send UniQuery output to a file. Perhaps LIST TO DELIM? -- TO [DELIM char] text_file Lists records to a UNIX text file. If you use the DELIM keyword, UniData places char between each attribute in text_file. text_file cannot be strictly numeric. On 6/2/2011 9:43 PM, Bill Haskett wrote: I can't remember how to send UniQuery output to a file. I've looked all through Using UniQuery and the UniQuery Commands Reference with no luck. In D3, I could do whatever query I wanted and send it to a file as tab-delimeted, which would remove any headings, footings, breaks, subtotals, etc. I was sure UD could do something like this. When I tried to send output TOXML, wierd things happened to data that should have been on the same line as other data (it got separated from the line when I opened the file in Excel). This data was an I-Descriptor (Virtual Attribute) calling a BASIC subroutine. Any help would be appreciated. Thanks, Bill Haskett Advantos Systems, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UniQuery Output to File
I can't remember how to send UniQuery output to a file. I've looked all through Using UniQuery and the UniQuery Commands Reference with no luck. In D3, I could do whatever query I wanted and send it to a file as tab-delimeted, which would remove any headings, footings, breaks, subtotals, etc. I was sure UD could do something like this. When I tried to send output TOXML, wierd things happened to data that should have been on the same line as other data (it got separated from the line when I opened the file in Excel). This data was an I-Descriptor (Virtual Attribute) calling a BASIC subroutine. Any help would be appreciated. Thanks, Bill Haskett Advantos Systems, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery Output to File
send UniQuery output to a file. Perhaps LIST TO DELIM? -- TO [DELIM char] text_file Lists records to a UNIX text file. If you use the DELIM keyword, UniData places char between each attribute in text_file. text_file cannot be strictly numeric. On 6/2/2011 9:43 PM, Bill Haskett wrote: I can't remember how to send UniQuery output to a file. I've looked all through Using UniQuery and the UniQuery Commands Reference with no luck. In D3, I could do whatever query I wanted and send it to a file as tab-delimeted, which would remove any headings, footings, breaks, subtotals, etc. I was sure UD could do something like this. When I tried to send output TOXML, wierd things happened to data that should have been on the same line as other data (it got separated from the line when I opened the file in Excel). This data was an I-Descriptor (Virtual Attribute) calling a BASIC subroutine. Any help would be appreciated. Thanks, Bill Haskett Advantos Systems, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery Output to File
Plus UDT.OPTIONS 91 ON if you want output conversions applied to the data before writing to the text file. Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Matthew Strand Sent: Thursday, June 02, 2011 7:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniQuery Output to File send UniQuery output to a file. Perhaps LIST TO DELIM? -- TO [DELIM char] text_file Lists records to a UNIX text file. If you use the DELIM keyword, UniData places char between each attribute in text_file. text_file cannot be strictly numeric. On 6/2/2011 9:43 PM, Bill Haskett wrote: I can't remember how to send UniQuery output to a file. I've looked all through Using UniQuery and the UniQuery Commands Reference with no luck. In D3, I could do whatever query I wanted and send it to a file as tab-delimeted, which would remove any headings, footings, breaks, subtotals, etc. I was sure UD could do something like this. When I tried to send output TOXML, wierd things happened to data that should have been on the same line as other data (it got separated from the line when I opened the file in Excel). This data was an I-Descriptor (Virtual Attribute) calling a BASIC subroutine. Any help would be appreciated. Thanks, Bill Haskett Advantos Systems, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery Output to File
I've been using the LIST TO DELIM a lot lately. It works reasonably well although I don't use it for any MV'd data. You can enter a TAB as the delim and it will work. You can even put the full path for the text_file in the statement otherwise it's created in the current directory. As Wally says turn on UDT.OPTION 91 although I think dates are the only thing that really needs it. hth Colin Alfke Calgary Canada From: mstrand send UniQuery output to a file. Perhaps LIST TO DELIM? -- TO [DELIM char] text_file Lists records to a UNIX text file. If you use the DELIM keyword, UniData places char between each attribute in text_file. text_file cannot be strictly numeric. On 6/2/2011 9:43 PM, Bill Haskett wrote: I can't remember how to send UniQuery output to a file. I've looked all through Using UniQuery and the UniQuery Commands Reference with no luck. In D3, I could do whatever query I wanted and send it to a file as tab-delimeted, which would remove any headings, footings, breaks, subtotals, etc. I was sure UD could do something like this. When I tried to send output TOXML, wierd things happened to data that should have been on the same line as other data (it got separated from the line when I opened the file in Excel). This data was an I-Descriptor (Virtual Attribute) calling a BASIC subroutine. Any help would be appreciated. Thanks, Bill Haskett ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniquery
Try: X.LIST.STMT:= \HEADER AR Invoices with customer last name \:V.JS.VAR1:\and customer first name John.\ David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Friday, May 27, 2011 3:28 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Uniquery U2 Users! I am trying to pass in arguments into a UniQuery form using JSPARAMS. This works fine when I working with a SELECT LIST: V.JS.VAR1 = Smith PROCEDURE LINE SELECT PERSON WITH LAST.NAME EQ :V.JS.VAR1 But when I try to pass this into a literal statement such as a HEADER - things go haywire (process goes into a loop) X.LIST.STMT:= \HEADER AR Invoices with customer last name :V.JS.VAR1: and customer first name John.\ Does anyone have any clues as to what I should be looking for - UDT.OPTIONS, HEADING settings? Also, when I pass in a V.JS.DATE.VAR to the HEADER I get the internal date regardless how I try to format it. Any insight would be greatly appreciated. Thanks, Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniquery
U2 Users! I am trying to pass in arguments into a UniQuery form using JSPARAMS. This works fine when I working with a SELECT LIST: V.JS.VAR1 = Smith PROCEDURE LINE SELECT PERSON WITH LAST.NAME EQ :V.JS.VAR1 But when I try to pass this into a literal statement such as a HEADER - things go haywire (process goes into a loop) X.LIST.STMT:= \HEADER AR Invoices with customer last name :V.JS.VAR1: and customer first name John.\ Does anyone have any clues as to what I should be looking for - UDT.OPTIONS, HEADING settings? Also, when I pass in a V.JS.DATE.VAR to the HEADER I get the internal date regardless how I try to format it. Any insight would be greatly appreciated. Thanks, Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users