X-Received: by 10.58.112.195 with SMTP id is3mr18812546veb.29.1388092708642; Thu, 26 Dec 2013 13:18:28 -0800 (PST) X-Received: by 10.49.6.41 with SMTP id x9mr4912qex.36.1388092708620; Thu, 26 Dec 2013 13:18:28 -0800 (PST) Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!peer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!p15no44284286qaj.0!news-out.google.com!l9ni207qay.0!nntp.google.com!p15no44284278qaj.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.pick Date: Thu, 26 Dec 2013 13:18:28 -0800 (PST) In-Reply-To: Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=190.34.209.194; posting-account=nh_Y0AoAAAAxmPdLGWRr_enZlfkMjisJ NNTP-Posting-Host: 190.34.209.194 References: User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: Subject: Re: openqm TRANS or XLATE with I type dictionary Item From: garcia.luis.e@gmail.com Injection-Date: Thu, 26 Dec 2013 21:18:28 +0000 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Received-Bytes: 3577 X-Received-Body-CRC: 505743766 Xref: csiph.com comp.databases.pick:2287 El viernes, 18 de febrero de 2011 11:09:19 UTC-5, Martin Phillips escribi= =F3: > Some further thoughts on why your original program did no work.... >=20 > > PRINT TRANS("ORDERS",1,"TEST","X") would be more correct? > > with that you get (hex address):Invalid I-type at line number of PROGNA= ME >=20 > When used in a program (as against a dictionary item), the third > argument to TRANS() must be a field number, not the name of the field. >=20 >=20 > Martin Phillips, Ladybridge Systems Maybe I am a little bit late on this... nevertheless, I am trying to use th= e trans function today (Why? Because it is useful) and I am trying to use t= his feature (Why? Because that would mean lot of time-code-stress savings..= . if I could make the thing work), and I ran into this thread. Which is ac= tually about what I was looking for. It happens to be that the company I wo= rk with owns the license for QM, and I read the manual (most of it... I thi= nk), and I have read the pages about trans() many times. First, it is not c= ool to have rtrans listed in the pdf within trans... it confuses, and it is= not the only function without its own entry in the menu. I can live with t= hat... Second, examples are either too few or too short, so I get a hard t= ime figuring out how to make things work. Yet, I can deal with that, too: l= abor omnia vinci... And last, but no least, the ***** manual DOES say the f= unction should work the way Wilson wrote down! Not only the pdf, but the on= -line (wanna-be-up-to-date) version:=20 "TOTAL.VALUE =3D QTY * TRANS('STOCK', PART.NO, 'PRICE', 'X')" (sic, http://= www.openqm.org/docs/index.html?qmb_trans.htm, Dec/26/2013). =20 In the same page:=20 "When used in a dictionary I-type expression this can also be A data item (A/C/D/I/S-type) defined in the target file's dictionary. If th= e field name does not follow the rules for construction of QMBasic variable= names, it must be quoted." (sic) On the other hand, if you are right, then the manual has been wrong for yea= rs now... but it clearly says "field name", not 'field number', nor it clai= ms that field has to be numeric. Anyways, I am giving up with that. Just a word of advise for the next perso= n looking for the way to make this work: do not trust the QM manual. Best regards.