Hi,
I'm running a scenario where I try to insert duplicate values into an Access Table defined with a primary Key.
the Driver does throw the correct exception as highlighted below, but I'm unsure as to what the "record 00007C00" implies in the exception message. Can you please clarify?
Error: Failed to insert a new record into table Province123:Failed to insert a duplicate key for conflict with record 00007C00
SQLState: 23000
ErrorCode: 143360
|
|
00007C00 is an internal rowid to locate the data row in physical file.
|
Thanks for the update.
I'm just wondering if it would be possible to reflect the actual rowid or primary key id instead, since the internal rowid in the physical file does not really help a user trying to debug the error. Thanks again.
|
>Failed to insert a duplicate key for conflict with record 00007C00
>does not really help a user trying to debug the error.
You can use
select * from yourtable where _rowid_={"varbinary" '\x00\x00\x7C\x00'};
|
Main
webmaster@hxtt.com