A little OT: Blank date fields in 200LX database



#3

I'm making a 200LX database file for recording medications. One of the fields is "Discontinued", for recording the date which the medication is discontinued.

I'd like to make a subset (F6) that only shows records where that field is blank, i.e. still current.

According to this article, I should be able to use "!*Discontinued" as the SSL expression in order to look for a blank date field:

http://www.palmtoppaper.com/ptphtml/44/44c00013.htm

But when I do that, I just get all records again. The entire expression I'm using is exactly as follows:

!*Discontinued

Am I misunderstanding their explanation? Database tells me that I'm running version 1.1 - not sure if there are any other versions in different ROM revisions. Also, does anybody know where to find the GENERAL.GDB file referenced in that article? I was searching high and low, but couldn't find it.


#4

I found a copy of GENERAL.GDB finally. (http://super.hplx.net/anonftp/pub/gengdb.zip). There are lots of useful tips in there; I recommend downloading it if you have a 200LX.

Anyway, when filtering that database the same way ("!*Date field") it works fine for the existing records. If I add a new record, it will still show up even if the date field has been filled in. I'm suspicious that it's some sort of weird parser behavior that's unexpected but useful in certain circumstances. Apparently I'm falling outside of those circumstances somehow.

I changed the filter to "Discontinued>{12/31/2099}" and that seems to give acceptable results. I wonder if there's a way to have it filter based on the current date...


Possibly Related Threads...
Thread Author Replies Views Last Post
  Prime: how to detect date format giancarlo 1 190 12-02-2013, 11:21 AM
Last Post: Michael de Estrada
  Date/time formats R. Pienne 4 310 11-01-2013, 12:43 PM
Last Post: Marcus von Cube, Germany
  How to set the Date.Time etc on a WP34S Harold A Climer 4 289 10-29-2013, 09:32 PM
Last Post: FORTIN Pascal
  Date/time programs for the HP 35s R. Pienne 0 133 10-03-2013, 02:37 PM
Last Post: R. Pienne
  200LX problem: Insert batteries and get a continuous beep... ideas ? Gene Wright 8 374 06-19-2013, 04:52 PM
Last Post: gene wright
  a new variant of the 200LX? robert rozee 1 159 06-03-2013, 10:33 AM
Last Post: BShoring
  HP41 Blank formulars for program documentation? Wolfgang 3 181 02-15-2013, 11:08 PM
Last Post: Wolfgang
  Date & Time disappear on WP 34S René Franquinet 16 711 12-10-2012, 08:24 AM
Last Post: Walter B
  Need a relational database for 200LX Dave Britten 11 439 08-29-2012, 01:03 AM
Last Post: Pete Wilson
  [41CL] Image Database Monte Dalrymple 9 381 07-04-2012, 01:57 PM
Last Post: Kerem Kapkin (Silicon Valley, CA)

Forum Jump: