Hey Cobalt,
The Script works ALMOST perfect now
My Unique ID is the field i made by myself (Keyfield) so every record has his own ID/key. I have 2 more questions about my script.
when activating my first script in the Tempfile:
Delete all records [no dialog]
Import Records [restore, no dialog, "database.dbf")
SetField [Exact("Keyfield";"main::keyfield")]
Open ["main.fp5"]
Close[]
I get a message "this field is not midifiable" after OK the script goes on, how can i get rid of that message?
(when i delete "SetField [Exact("Keyfield";"main::keyfield")]" the warning is gone. But this one is quite important huh?)
Another question about your last script with the 'status' field, it works very nice......
BUT! When i import a NEW record it goes OK (it says NEW). When i do the same import again, the new record goes to CHANGED (it must be UNCHANGED). I Only want a CHANGED when something in a record (with the same ID/Key) is changed.
When this is working i'm a happy man