Care Products, Inc.
VFP5: Error 3251
Save to folder
...Well, first of, - sorry for not even showing up here for such a long time :) Go =SO BUSY= that couldn't even check my e-mail for weeks!
Now, - the question! When dealing with SQL Server database, I have to transfer data from local dbf onto the server. Replicating the table structure and other stuff is easy, - just fire a stored procedure that will do the job. But when it comes to transferring data - I get stuck on a simple task of inserting into IDENTITY column. SET IDENTITY_INSERT
ON/OFF works fine from isql interactive window, but when I try to parse it in the code (VFP or VB, doesn't matter), - I get Error 3251 that is not trappable and doesn't interrupt the program execution, and yet - doesn't set the IDENTITY_INSERT flag against the table. Question: Has anybody dealt with issueing SET statements against SQL Server database? How did you go about doing it?
Thanks in advance,
Some things are better be left unknown...NOT!!!