calculated field using record num in report problem with 4.5 dos

#1

I need to create a calculated field in a report that maps record 1 to 120, 2
to 130, 4 to 140 and so on. When I try use the record number [#], Paradox
will not accept it and gives me an error message. The calc'd field should
have looked like this "10*[#]+110" to perform as wished. It is just the
reference to the record number that is hosing me up. Any ideas?

#2

Kevin Donaker-Ring wrote:

Quote:

Those don't like like PdoxDOS instructions to me.

I didn't notice that it said DOS either..

--

Steve Green - Diamond Software Group, Inc - Waldorf Maryland USA
Corel CTech Paradox - http://www.diamondsg.com - Support/Downloads/Links
---------------------------------------------------------------------------------
Do you need a Sanity Check? http://www.diamondsg.com/sanity.htm
Upgrade/Downgrade versions? http://www.diamondsg.com/upgrade.htm
-------------------------------------------------------------------------

#3

They're not ... I didn't read the last word in the title because
it truncated. Sorry. However, maybe Steve can tell you if the
same principle holds true ...

Mike

In article <3F036450.20109 (AT) DESPAMULATIONaise (DOT) com>,
kevin (AT) DESPAMULATIONaise (DOT) com says...

Quote:

Mike,

Those don't like like PdoxDOS instructions to me.

#4

Thanks, I shall give that a try.

"Steven Green" <greens (AT) diamondsg (DOT) com> wrote

Quote:

rob wrote:

I need to create a calculated field in a report that maps record 1 to
120, 2
to 130, 4 to 140 and so on. When I try use the record number [#],
Paradox
will not accept it and gives me an error message.

in a PdoxDOS report, you can't do it that way.. if you *must* use Recno()
in a
calc, you'll need to create an extra field, SCAN the table to seed it with
RECNO(), then use that field in your calcs..

--

Steve Green - Diamond Software Group, Inc - Waldorf Maryland USA
Corel CTech Paradox - http://www.diamondsg.com - Support/Downloads/Links
--------------------------------------------------------------------------
-------

Do you need a Sanity Check? http://www.diamondsg.com/sanity.htm
Upgrade/Downgrade versions? http://www.diamondsg.com/upgrade.htm
-------------------------------------------------------------------------

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

calculated field using record num in report problem with 4.5 dos

comp.databases.paradox comp.databases.paradox

calculated field using record num in report problem with 4.5 dos - 07-02-2003 , 10:55 AM

Re: calculated field using record num in report problem with 4.5dos - 07-02-2003 , 06:19 PM

Re: calculated field using record num in report problem with 4.5dos - 07-03-2003 , 09:20 AM

Re: calculated field using record num in report problem with 4.5 dos - 07-07-2003 , 10:05 PM