What about to use the search mode of IBO with a tib_query to find the
record, edit it and post it?

Luiz.

----- Original Message -----
From: Aage Johansen <aagjohan@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, July 19, 2001 4:07 PM
Subject: [IBO] Re:Optimize updating of large database


> If there is a high probablilty that the record already exists, you could
> just attempt to update it. If the RowsAffected=0, you will try an insert.
>
> Regards,
> Aage J.
>
>
> Johan Kotze wrote:
> -------------------------------------------
> 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.
> -------------------------------------------
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>