>Hi Fox gurus :)
>Me again, after all these years :)
>Question: When I try SET IDENTITY_INSERT
ON|OFF, I don't get a trappable error, but the error is still being raised on the ODBC side and the SET is not set. Has anybody have any experience and especially - luck, in dealing with issuing SET statements from VFP?
>I tried this thing in both VB and VFP, but to no avail.
>
>Thanks in advance,
>
>Robert.
I assume you are using SQL Passthrough for this. I ran into problems doing this sometime back. Try sending the SET IDENTITY_INSERT command and your INSERT command via the same SQLEXEC command.
HTH
Everything we see or seems
Is but a dream within a dream - Edgar Allen Poe