I have a database of 1 million+ entries and I am looking for the
quickest way of retrieving a record (specified by a unique key
value), change a field in the record (not the key field) and
applying the change to the database. To complicate matters, if the
key does not exist, a new record needs to be added to the database.
I am currently using a TIB_Query component and using TIB_Query.Lookup
to find the record, put the record in edit mode and executing post. I
was thinking along the lines of a stored proc, but how do you
accomplish this in a stored proc.

Any ideas will be much appreciated.

Johan Kotze