re: Replace query question

2002-09-20 Thread Victoria Reznichenko
speters, Thursday, September 19, 2002, 10:55:41 PM, you wrote: samdc> If i use a replace query, and there isn't an error, then either samdc> a new row was inserted, or an existing row was updated. samdc> The primary key in the table i'm replacing to is defined as samdc> mprid int not null auto_i

Replace query question

2002-09-19 Thread speters
If i use a replace query, and there isn't an error, then either a new row was inserted, or an existing row was updated. The primary key in the table i'm replacing to is defined as mprid int not null auto_increment primary key whether an insert or update actually occurs, i want to get the value o