RE: UniCommand via UniObjects (Java)
I would actually try sending PA @FM QSELECT @FM SSELECT Dunno whether it would work, but if sending an @FM-delimited list of commands screws up by giving all the rest of the string to the first command, maybe making the first command PA (to invoke the paragraph processor) would achieve exactly what he wants? I never realised before I started reading cdp/oliver that you didn't need PA at the start of an @FM list called by EXECUTE, so that's the way I've always done things. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Phil Walker Sent: 24 February 2004 21:25 To: U2 Users Discussion List Subject: RE: UniCommand via UniObjects (Java) I believe he can just call a paragraph such PARAGRAPH 12345 Where PARAGRAPH is the following VOC entry PA * C2,ARG1 QSELECT CLIENT.XREF ARG1 SSELECT AR.TR BY MATTER WITH INVOICE = ARG1 Phil Walker +64 21 336294 [EMAIL PROTECTED] infocusp limited \\ PO Box 77032, Auckland New Zealand -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dawn M. Wolthuis Sent: Wednesday, February 25, 2004 10:16 AM To: 'U2 Users Discussion List' Subject: RE: UniCommand via UniObjects (Java) I think you can put the commands in a single paragraph and run that from UniObjects. You'll have to pass in the DATA to the paragraph (since I figure that 12345 is the value of a variable) and I haven't tried that with UOJ, but I suspect others have. Good luck. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Donald Kibbey Sent: Tuesday, February 24, 2004 1:55 PM To: [EMAIL PROTECTED] Subject: UniCommand via UniObjects (Java) I'm attempting to send a compound command with the UniCommand object and have hit what looks like a documented limitation. Before I go off and rethink how I'm doing this, I thought I'd ask to make sure this really won't work. What I'm attempting is to run something like this under UniObjects. QSELECT CLIENT.XREF 12345 :@FM: SSELECT AR.TR BY MATTER WITH INVOICE = 12345 On this system, doing this results in a very quick selection of a couple hundred records out of the AR.TR file. But, the docs for UniObjects say only one command at a time. Does this mean that sticking a couple commands together like this is just not possible? I've tried it and it looks like the QSELECT is being attempted with all parts of the command string. If it won't work, I suppose I'll be reduced to writing up a stub of a program to do the same thing and just call it from the UniObjects side of things. But, if there's a better way, I'm all ears. Thanks, -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniCommand via UniObjects (Java)
Sorry, I haven't tried this with Uniobjects, perhaps it's stripping the @FM somehow?? You could always put the commands into a paragraph and run that - or write a program that executes all of the commands that it is sent... good luck -- Colin Alfke Calgary, Alberta Canada Just because something isn't broken doesn't mean that you can't fix it Stu Pickles -Original Message- From: Donald Kibbey [mailto:[EMAIL PROTECTED] I'm attempting to send a compound command with the UniCommand object and have hit what looks like a documented limitation. Before I go off and rethink how I'm doing this, I thought I'd ask to make sure this really won't work. What I'm attempting is to run something like this under UniObjects. QSELECT CLIENT.XREF 12345 :@FM: SSELECT AR.TR BY MATTER WITH INVOICE = 12345 On this system, doing this results in a very quick selection of a couple hundred records out of the AR.TR file. But, the docs for UniObjects say only one command at a time. Does this mean that sticking a couple commands together like this is just not possible? I've tried it and it looks like the QSELECT is being attempted with all parts of the command string. If it won't work, I suppose I'll be reduced to writing up a stub of a program to do the same thing and just call it from the UniObjects side of things. But, if there's a better way, I'm all ears. Thanks, -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniCommand via UniObjects (Java)
I think it would be better to put it into a paragraph so that you can handle errors from individual commands anyway. Phil Walker +64 21 336294 [EMAIL PROTECTED] infocusp limited \\ PO Box 77032, Auckland New Zealand -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 9:30 AM To: [EMAIL PROTECTED] Subject: RE: UniCommand via UniObjects (Java) Sorry, I haven't tried this with Uniobjects, perhaps it's stripping the @FM somehow?? You could always put the commands into a paragraph and run that - or write a program that executes all of the commands that it is sent... good luck -- Colin Alfke Calgary, Alberta Canada Just because something isn't broken doesn't mean that you can't fix it Stu Pickles -Original Message- From: Donald Kibbey [mailto:[EMAIL PROTECTED] I'm attempting to send a compound command with the UniCommand object and have hit what looks like a documented limitation. Before I go off and rethink how I'm doing this, I thought I'd ask to make sure this really won't work. What I'm attempting is to run something like this under UniObjects. QSELECT CLIENT.XREF 12345 :@FM: SSELECT AR.TR BY MATTER WITH INVOICE = 12345 On this system, doing this results in a very quick selection of a couple hundred records out of the AR.TR file. But, the docs for UniObjects say only one command at a time. Does this mean that sticking a couple commands together like this is just not possible? I've tried it and it looks like the QSELECT is being attempted with all parts of the command string. If it won't work, I suppose I'll be reduced to writing up a stub of a program to do the same thing and just call it from the UniObjects side of things. But, if there's a better way, I'm all ears. Thanks, -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniCommand via UniObjects (Java)
Donald Kibbey wrote: I'm attempting to send a compound command with the UniCommand object and have hit what looks like a documented limitation. Before I go off and rethink how I'm doing this, I thought I'd ask to make sure this really won't work. What I'm attempting is to run something like this under UniObjects. QSELECT CLIENT.XREF 12345 :@FM: SSELECT AR.TR BY MATTER WITH INVOICE = 12345 Is there some problem with executing two UniCommands in succession? I try to minimize the RPC calls, but if it's just two I probably wouldn't move it up to the database server. [not tested] uCommand = uSession.command (QSELECT CLIENT.XREF 12345); uCommand.exec(); uCommand = uSession.command (SSELECT AR.TR BY MATTER WITH INVOICE = 12345); uCommand.exec(); (I'm not sure if UniCommands are mutable, you might be able to do uCommand.setCommand() for the second one.) Since you're in the same session, it should keep the active select list. -- Wendy Smoak Application Systems Analyst, Sr. ASU IA Information Resources Management -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users