From: Nelson E. I. <nin...@cs...> - 2004-05-03 19:28:34
|
I am learning Pilot-DB, so please be patient with me. I am using DB on my new Tungsten|E. The database and program all reside in the main memory. As a test I have made two databases. One is a copy of my CD database from CATraxx. It has 340 records and the import, using DB-Edit worked GREAT! The second is a more interactive database... specifically a fuel log database where I enter appropriate information such as cost of fuel, amount of fuel, total price, and trip distance since last fill-up, followed by MPG (calculated Miles Per Gallon). In this simple example cost, quantity, and total price are floats, trip distance is an integer and MPG is calculated by dividing trip distance by quantity of fuel. In the script section I entered when declaring the calculated field I put "/ %5 %3 ". The field numbers are those I see in the database design screen. I get an error "?Who knows?" (after entry) or "[broken]" (after a rebuild or recalculate). I've been reading the documents trying to figure out my mistake but have failed so far. Any thoughts? Nelson E. Ingersoll |