scripted Find issue

[Kris M]

Ive got a db with two tables...

table "information" with a bunch of data entry fields and an autoenter modification timestamp

table "exports" that records when an export script has run.

export fields pk, exporttimestamp, exportedrecords, and summary max (exporttimestamp)  

 

information is related to exports with and X type join on two timestamp fields. (yes i know i dont need this with the go to layout steps)

 

The issue is with the export script where ...

 

go to export table TO.

show all records

set var $lov = summary field (2/2/2013 4:55:11 PM)

go to information table TO for find and export

enter find mode

set field modification timestamp "<" & $lov

shows 02/2/2013 4:55:11 * PM..

Perform find

always returns all records

 

Where does the asterisk come from?

 

I'm on FMPA 12 v1

 

Probably just a Sunday and no sleep brain fart.... 

[bruceR]

You should probably post your file; or your actual script.

 

Among other problems, there is no such command as "go to information table TO for and export"

 

Also; your script makes no sense.

 

You are searching for all records which were modified earlier than now.

 

You are getting the correct results.

 

There are no records that have been modified sometime in the future.

[Kris M]

found my own error when using the fmp 12 perform find function.. still adjusting