X-Received: by 10.182.134.200 with SMTP id pm8mr4646192obb.19.1391736331117; Thu, 06 Feb 2014 17:25:31 -0800 (PST) X-Received: by 10.50.43.194 with SMTP id y2mr51684igl.6.1391736330953; Thu, 06 Feb 2014 17:25:30 -0800 (PST) Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!c10no11390662igq.0!news-out.google.com!vg8ni16igb.0!nntp.google.com!c10no11390655igq.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.pick Date: Thu, 6 Feb 2014 17:25:30 -0800 (PST) In-Reply-To: Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=24.24.165.35; posting-account=nRH3PwoAAAA-e6gjxEGgm0GUUzM71AXc NNTP-Posting-Host: 24.24.165.35 References: User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <227c773a-cc44-4e0b-9193-e05f30b457fa@googlegroups.com> Subject: Re: openqm TRANS or XLATE with I type dictionary Item From: ernievegas40@gmail.com Injection-Date: Fri, 07 Feb 2014 01:25:30 +0000 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Xref: csiph.com comp.databases.pick:2297 What version number of OpenQM is it? Also, what edition (personal, etc.) Robert Norman ROBERT NORMAN AND ASSOCIATES 23441 Golden Springs Dr., #289, Diamond Bar, CA 91765 (951) 541-1668 http://universe-basic-programming.webstarts.com/index.html http://users.keyway.net/~ice/ http://www.affordablemultivalueprogramming.i8.com/ Affordable computer consulting services for these environments and language= s: * UNIVERSE (language: UNIVERSE BASIC) * CACHE (language: MV BASIC) * INFORMATION (language: INFO/BASIC) * jBASE (language: jBC, jBASE BASIC, jBASIC) * MENTOR System (language: DATA/BASIC, DATABASIC, DATA BASIC) * MVENTERPRISE (language: MVENTERPRISE BASIC) * MVON/ONWARE (language: ONWARE BASIC) * OPENINSIGHT (language: BASIC+) * OPENQM, QM (language: QMBASIC) * PICK, Advanced PICK, D3 (language: PICK BASIC) * Power95 (language: DATA/BASIC, DATABASIC, DATA BASIC) * REALITY System (language: DATA/BASIC, DATABASIC, DATA BASIC) * REVELATION, Advanced REVELATION (language: R/BASIC, REVELATION BASIC) * UNIDATA (language: UNIBASIC) * UNIVISION (language: UVBASIC) * WebSphere DataStage (language: DSBASIC, DataStage BASIC) On Thursday, December 26, 2013 1:18:28 PM UTC-8, garcia...@gmail.com wrote: > El viernes, 18 de febrero de 2011 11:09:19 UTC-5, Martin Phillips escrib= i=F3: >=20 > > Some further thoughts on why your original program did no work.... >=20 > >=20 >=20 > > > PRINT TRANS("ORDERS",1,"TEST","X") would be more correct? >=20 > > > with that you get (hex address):Invalid I-type at line number of PROG= NAME >=20 > >=20 >=20 > > When used in a program (as against a dictionary item), the third >=20 > > argument to TRANS() must be a field number, not the name of the field. >=20 > >=20 >=20 > >=20 >=20 > > Martin Phillips, Ladybridge Systems >=20 >=20 >=20 > Maybe I am a little bit late on this... nevertheless, I am trying to use = the trans function today (Why? Because it is useful) and I am trying to use= this 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 = actually about what I was looking for. It happens to be that the company I = work with owns the license for QM, and I read the manual (most of it... I t= hink), and I have read the pages about trans() many times. First, it is not= cool 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= that... Second, examples are either too few or too short, so I get a hard= time figuring out how to make things work. Yet, I can deal with that, too:= labor omnia vinci... And last, but no least, the ***** manual DOES say the= function should work the way Wilson wrote down! Not only the pdf, but the = on-line (wanna-be-up-to-date) version:=20 >=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 >=20 >=20 >=20 > In the same page:=20 >=20 > "When used in a dictionary I-type expression this can also be >=20 > A data item (A/C/D/I/S-type) defined in the target file's dictionary. If = the field name does not follow the rules for construction of QMBasic variab= le names, it must be quoted." (sic) >=20 >=20 >=20 > On the other hand, if you are right, then the manual has been wrong for y= ears now... but it clearly says "field name", not 'field number', nor it cl= aims that field has to be numeric. >=20 >=20 >=20 > Anyways, I am giving up with that. Just a word of advise for the next per= son looking for the way to make this work: do not trust the QM manual. >=20 >=20 >=20 > Best regards.