Try looking up the REPLACE command. That does exactly what you are
looking to do, but you do need a primary key for it to lookup on.
On Monday, July 7, 2003, at 10:54 AM, LeTortorec, Jean-Louis wrote:
Hello everyone,
Is there a function that first tests if a record exists, and if so
updates
it
Hello everyone,
Is there a function that first tests if a record exists, and if so updates
it, or if it does not exists, it creates that new record?
I know I can do that by checking the list of records, then update the table.
But that requires 2 queries. If I could get that done by one, that wou
