From: Michael A. L. <mic...@ma...> - 2006-01-20 13:22:11
|
Friday, January 20, 2006, 10:56 Dear all, I have Pilot-DB 1.1.3 on my old Palm m105, working fine for years. I have successful created databases that use script/calculations. I created a database for logging daily events: Field 0: Date (default = current) Field 1: Time (default = current) Field 2: Note In order to have dates and times sorted correctly, I had to change the config of my Palm to display dates as YY/MM/DD. (Or else, it would sort months as 1,10,11,12,2,3,4... ). ANyway, I want to create a filter to view only TODAY'S info. SO I created a Global Scritp with the following function: (eq (int %0)(int (gcd))) That is: if the date in column 1 (%0) equals the current date (gcd)... ...But when I type it in to a new Global Script, Pilot-DB says "Invalid Initialization". It does work, however, if I put it in a Calculated field (returning 0 or 1, for False or True). How must a Global Script initialize? How can I make a filter to view only the information for the current date? Where can I find documentation about Global Scripts? (documentation at SourceForge is from 2002 and doesn't have Global Scripts). Regards, Michael A. Lees mic...@ma... ------------------- ICQ: 2977164 MSN: mic...@ma... www.miranda-im.com |