pilot-db-list

[pilot-db-list] Calculations with linked fields...

[Michael O. <mob...@co...>]

I'm making a calorie counter that uses two databases, one for food items and the other with what items I had on that day.
The problem arises when I try to use linked fields in calculations.

first database has a [string] and an [integer]  description and calories

the sceond one has a [date] folowed by a [link] to the string description in the first database and a [linked] to the integer calories

I'd like to add a calculated field that accumulates calories for any given day, but I think the scripts don't consider links to integers to actually be integers.

The manual is really vauge on linked stuff, and I've reached my wits end, Any help would be appreciated.


    Thanks in advance..
Michael Obersnel

RE: [pilot-db-list] Calculations with linked fields...

[Craig B. <sy...@ca...>]

No, they're likely considered strings. Did you try casting them to an
integer first?

  -----Original Message-----
  From: pil...@li...
[mailto:pil...@li...]On Behalf Of Michael
Obersnel
  Sent: Thursday, October 30, 2003 10:46 AM
  To: pil...@li...
  Subject: [pilot-db-list] Calculations with linked fields...


  I'm making a calorie counter that uses two databases, one for food items
and the other with what items I had on that day.
  The problem arises when I try to use linked fields in calculations.

  first database has a [string] and an [integer]  description and calories

  the sceond one has a [date] folowed by a [link] to the string description
in the first database and a [linked] to the integer calories

  I'd like to add a calculated field that accumulates calories for any given
day, but I think the scripts don't consider links to integers to actually be
integers.

  The manual is really vauge on linked stuff, and I've reached my wits end,
Any help would be appreciated.


      Thanks in advance..
  Michael Obersnel