Robert Adsett 12.Oct.11 12:39 PM a Web browser Approach 9.8 Windows 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.