Bill,

> I've uploaded the document to uploaded files section of the firebird
> architect group. This covers the current SAS implementation, which I
> want to replace (you can skip that part), along with the new code. I've
> highlighted the parts I wasn't sure about. I also uploaded a spreadsheet
> and SQL file which shows my proposed datafill - that's the hard part.

I have used your data to add SQLstate mapping to Jaybird. Following
fixes (not yet complete, only what I have found):

335544510 - you have HY000 ("general"), should be 40001 ("lock conflict").

335544439 - you have 23000 ("constraint"), should be either HY000 or 37000

335544595 - looks like it should be HY000, not 27000.

Roman