Philip Hayes

Thanks for the feedback guys. What I'm trying to create is a RFID tracking / accountability database. Lets say we have 100 objects. Each one is assigned a RFID. The ODBC connection will insert a RFID that the RFID reader receives into the database. The Filemaker databse will then match the RFID to the corresponding object. If the objects RFID does not come in again on the reader within 15 minutes of the first one, an alert should pop-up. I actually already have an application programmed in Cold Fusion that does just this but would prefer to create it FMP. Any suggestions?

I have two questions for the hard core programmer out there.... 1) I have a RFID reader in which one of my C programmers is building a tool that can read the data from the RFID device and post it into a table in a database. Currently, we plan to do with with SQL server. Is it posssible to do this into FMP 7? If so, how? ODBC? 2) Is it posssible to write code that executes every 30 seconds? If so, how would I do that? Basically I need to flash a warning if a condition exists from the inputed data from the RFID device.

Anybody have any ideas on the best way to make a jeopardy like game using filemaker? I'm having trouble coming up with a reliable solution. Any help will be appreciated! Phil Hayes

Hi guys... I'm a cold fusion programmer and am trying to adjust to the way filemaker does stuff. I'm trying to set the value of a field, using a calculation. I've successfully grabbed a timestamp value from the first and last records of a table by using the Min(FieldName) and Max(FieldName) and making the result a "timestamp". Is there a way to get the timestamp info I need from the next to last "max" record? in otherwords the max record minus 1? If I write the calculation as (Max(FieldName)-1), I get the timestamp minus 1 second. I need to get the actual value of the timestamp of this next to last record. I know i can probaly do it with scripting, but I would prefer to keep it as a synamic calculation. Thanks. Phil Hayes Version: v7.x Platform: Mac OS X Panther