RE: [U2] Wintegrate Query Builder

Hi Colin, Your idea sounds like it would fix my problem. You can either create an associated I-desc that has the mv position Can you show me an example? I have built some simple I-desc's, but I'm pretty weak at it. or use a dict that combines all of the MV's into one block. This would be

[U2] Wintegrate Query Builder

Will go home Might look like this: And then I I am going to Will go home The park today Is there a way to keep a note in the right sequence? Thanks, Bruce Ordway Unidata 5.2 Dataflo5.4G7 Viking Engineering Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com

RE: [U2] RE: TCL literal select

) ... SELECT PARTS WITH F1.TILDA = [~] John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Tuesday, August 12, 2008 4:00 PM To: u2

[U2] TCL literal select

system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message

[U2] Dataflo Unidata TCL and the INV file

** Can somebody show me how to query INV correctly? Thanks, Bruce Ordway Viking Engineering P.S. I find INV to be the most confusing part of my MV world. I'd like to hear any insights/comments on INV. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please

RE: [U2] Dataflo Unidata TCL and the INV file

Kevin, It's MV alright, but there is something I don't understand about this file. That's why I was hoping a someone familiar with the app might be browsing today. I've got a work around using two Query Builders to export and then using sub queries in Access. BTW here's the dirctory structure:

RE: [U2] Dataflo Unidata TCL and the INV file

Graham, I think this is what you want LIST INV '302618''302618' F4 F9 F8 I thought the same thing but Bin Qty Bin Loc are blank when I list INV On the other hand, Inv Code is blank if I list INV,SV It's driving me crazy. Thanks, Bruce --- u2-users mailing list

RE: [U2] To Limit TCL Access Privilege

Do you use Wintegrate? I have my users use Query Builder instead of TCL. -Original Message- From: Ang Suan Yong [mailto:[EMAIL PROTECTED] Sent: Thursday, October 27, 2005 9:32 PM To: U2-Users New Lists Subject: [U2] To Limit TCL Access Privilege Dear All I am trying to give

RE: [U2] Unidata TCL - beginner question

What you are looking for is the MAX verb. You would use it thus: LIST file.name PART MAX DATE DET.SUP I'm on HPUX 11 Unidata 5.2. There doesn't seem to be a MAX available. However, I do see a basic function called MAXIMUM(). I wonder if I could create a Virtual field using this to give me the

RE: [U2] Unidata TCL - beginner question

SORT filename BY Part BY Date @ID BREAK.ON Part Date DET.SUP BTW, I thought this worked to begin with. Then, I started noticing it wasn't really. I keep getting dates in the middle of the range for some parts. Just so happens I'm working on a huge file, 886817 records. I wonder if Unidata SORT's

[U2] Unidata TCL - beginner question

Hi, I ran into yet another beginners TCL puzzle today. Is there a way to use TCL and return only latest record? i.e. I have 4 records @ID Part Date 1234 1589 12/2/04 1235 1589 11/6/03 1236 1589 10/1/05 1249 1589 10/2/05 I only want to see 1249 1589 dated 10/2/05. Thanks, Bruce Ordway Viking

[U2] Unidata TCL - beginner question - correction

a lot of trouble. If not TCL, then how about in a program? Thanks again, Bruce Ordway Viking Engineering 763-586-1228 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Unidata TCL - beginner question

/10/05 1224 1590 2/23/05 *** I only want to see: 1249 1589 10/2/05 1224 1590 2/23/05 Thanks, Bruce Ordway Viking Engineering 763-586-1228 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http

RE: [U2] Unidata TCL - beginner question

I got this answer from another user group. Never noticed BREAK-ON combined with DET-SUPP does exactly what I wanted. LIST FILE @ID BREAK-ON PART DATE DET-SUPP --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] Tracking down how fields are filled

to? Thanks, Bruce Ordway Viking Engineering 763-586-1228 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] TCL beginner

something like this: RMAF40 1234 1 2345 1 3456 1 4567 2 5678 2 1345 3 1456 3 Now, what I'd like to see are totals of unique values in F40 i.e. 1 = 3 2 = 2 3 = 2 Is it possible to do with just TCL? Thanks, Bruce Ordway Viking Engineering 763-586-1228 [EMAIL PROTECTED

RE: [U2] TCL beginner

Assume you called it One I called it Z_RMA_CNT. I also had to change the words a little because of my flavor I think. LIST RMA BY F40 BREAK-ON F40 TOTAL Z_RMA_CNT ID-SUPP DET-SUPP Anyway, I'm getting wierd results. Could it be because F40 is a MV field? COMMENT Z_RMA_CNT

RE: [U2] TCL beginner

Hmmm... I looked a little closer noticed that all the bogus values were for old files which may or may not have had correct values entered. I modified the TCL to this: LIST RMA WITH F41 = Y AND WITH F40 = 1028 1029 1030 1031 1032 1033 1034 1035 BY F40 BREAK-ON F40 TOTAL Z_RMA_CNT ID-SUPP