Robert Adsett 12.Oct.11 12:39 PM a Web browser Approach9.8Windows XP
I'm having a problem hooking up Approach to an SQL table with an identity column (serial field in Approach parlance). SQL server does not allow writing to such a column but approach seems to insist on doing so.
In that case I get an error saying I don't have sufficient permissions and on the approach side nothing appears to be written. If you hit escape and refresh though a new row will be there.
I've tried adding an insert trigger to SQL to remove the field from the write but this appears to be insufficient.
Return to top
SQL Server 2008 Identity Column and... (Robert Adsett 12.Oct.11)
. . 
Print this page
