No announcements
Found 264655 threads
-
0 VotesSync Framework does not generate 'Set Identity_Insert ON' for non Int columns
I tried V2.1 SqlSyncProvider, the generated insert sp has such content for a smallint identity pk column.Answered | 4 Replies | 8222 Views | Created by Vindana Madhuwantha MSFT - Tuesday, December 28, 2010 9:41 AM | Last reply by Vindana Madhuwantha MSFT - Wednesday, December 29, 2010 10:37 PM
-
0 Votes
Cannot insert explicit value for identity column in table 'X' when IDENTITY_INSERT is set to OFF?
You may refer the below SO thread, which has described regarding the similar issue and see if it ...Unanswered | 3 Replies | 1171 Views | Created by Giorgi Metskvarishvili - Tuesday, May 29, 2018 9:47 AM | Last reply by Swikruti Bose - Thursday, May 31, 2018 9:34 AM -
0 Votes
SqlSyncProvider - Cannot insert explicit value for identity column in table 'Address' when IDENTITY_INSERT is set to OFF.
My issue is that SyncFX generates invalid tables and stored procedures for change tracking, when these contain auto incremented int keys.Discussion | 3 Replies | 16555 Views | Created by János Janka - Friday, June 12, 2009 5:54 PM | Last reply by János Janka - Saturday, June 27, 2009 7:20 PM -
0 Votes
Sync framework - Identity crisis
[TerminalHeartBeat_insert] @P_1 Int, @P_2 Int, @P_3 DateTime, @P_4 Real, @P_5 Real, @sync_row_count Int ...Answered | 8 Replies | 10328 Views | Created by ravindra bg - Saturday, May 8, 2010 11:31 PM | Last reply by JuneT - Thursday, August 20, 2015 12:23 PM -
0 Votes
Issue SyncFramework 2.1 - Auto Increment (Identity) Columns that are outside the Primary Key
While there is a workaround like you noticed, I would like to ask why there is a need for this column and if so, why should it be an identity column in your schema?Answered | 4 Replies | 10662 Views | Created by Dylan C Phillips - Friday, January 28, 2011 2:00 PM | Last reply by Mahesh Dudgikar - Wednesday, February 16, 2011 8:44 AM -
0 Votes
how to handle Identity columns?
Hi, If the identity column is not PK and is not necessary for your sync purpose, you can skip it.Answered | 1 Replies | 11974 Views | Created by bharathi_m - Tuesday, October 27, 2009 5:03 AM | Last reply by Dong Cao - Tuesday, October 27, 2009 7:00 PM -
3 Votes
EF 4 DetailsView and EntityDataSource: Cannot insert the value NULL into column 'PasswordHash', table 'C1AdventureWorks.Person.Contact'; column does not allow nulls.
According to your description, I think you can get some useful messages in the following link: Setting Default Values for LINQ Bound ...Answered | 3 Replies | 14218 Views | Created by Triplesticks - Monday, March 14, 2011 5:56 PM | Last reply by Ed Price - MSFT - Friday, December 30, 2011 5:05 PM -
0 Votes
a code block that prepare Insert Statement for inserting table ?
My text be inserted to table like below.Answered | 14 Replies | 1270 Views | Created by MSDN.CSharp - Saturday, May 2, 2015 7:46 AM | Last reply by Cor Ligthert - Wednesday, May 13, 2015 8:21 AM -
0 Votes
Cannot insert duplicate key.
Cannot insert duplicate key in object 'dbo.ActivityPointerBase'.Answered | 27 Replies | 19677 Views | Created by Harispk - Wednesday, June 27, 2012 9:25 AM | Last reply by Harispk - Thursday, June 28, 2012 12:57 PM -
0 Votes
Identity Crisis workaround issues
Yeah that's what I did but because of the fact that the identity column was the PK, if on the client I left it set to null then when ...Answered | 6 Replies | 6600 Views | Created by JonUK - Wednesday, September 29, 2010 3:04 PM | Last reply by JuneT - Friday, October 1, 2010 10:36 AM -
2 Votes
Syncing Non-Identical Tables
if the table names are different, try setting the GlobalName property of the SyncTableDescription i.e.Answered | 4 Replies | 7234 Views | Created by Colin Meade - Sunday, April 10, 2011 4:21 PM | Last reply by JuneT - Monday, April 11, 2011 3:07 PM -
0 Votes
Getting 'Invalid column name' exception during provision
CREATE PROCEDURE [patient_bulkinsert] @sync_min_timestamp BigInt, @sync_scope_local_id ...Answered | 3 Replies | 9148 Views | Created by sharon 5656 - Thursday, November 3, 2011 8:57 AM | Last reply by JuneT - Monday, November 7, 2011 8:54 AM -
0 Votes
IDENTITY_INSERT table OFF - Visual Web Developer 2008
I understand that on insert of a record in the database you just set the is_Identity to Yes and Increment by 1 and step by 1 and do not specify this ...Unanswered | 1 Replies | 1617 Views | Created by don.raflik - Saturday, January 12, 2013 9:44 PM | Last reply by Youen Zen - Monday, January 14, 2013 5:21 AM -
0 Votes
set the table rows dynamically depending on a field value
I have placed a web resource into a section on account form... and if i insert "5" into "number" field then the section table should ...Answered | 3 Replies | 1628 Views | Created by Amy.4 - Tuesday, May 13, 2014 12:03 PM | Last reply by Anupam Bishui - Wednesday, May 14, 2014 5:10 PM -
0 Votes
Late bound insert value to option set and lookup field/attribute?
Opportunity2["new_division"] = Opportunity1.Attributes["new_division"].ToString(); Appreciate your help.Answered | 6 Replies | 10368 Views | Created by Newbie CRM - Wednesday, July 27, 2011 2:34 AM | Last reply by CRM elite - Thursday, August 25, 2011 12:25 AM -
0 Votes
How to hide a column in a table
This thread was moved into the Off Topic forum.Answered | 2 Replies | 13271 Views | Created by Hewqewewewe - Wednesday, June 18, 2008 10:29 AM | Last reply by Ed Price - MSFT - Friday, May 11, 2012 5:50 AM -
1 Votes
Column 'xxx' not found in table
In this method I do the following Define NEW datatable Open a new connection with USING Open a command with ...Answered | 1 Replies | 4564 Views | Created by Tejo Joseph - Monday, December 12, 2011 8:17 AM | Last reply by Cor Ligthert - Monday, December 12, 2011 8:22 AM -
0 Votes
create a stored procedure to split the values of column of table on comma separator.
I have to create a stored procedure to split the values of column setA of table named SafeEventB(created in previous step) on comma separator ...Answered | 1 Replies | 970 Views | Created by mekshinu - Friday, May 22, 2015 11:27 AM | Last reply by Anuj Tripathi - Friday, May 22, 2015 1:29 PM -
0 Votes
How to pass a table-valued parameter as SyncParameter?
So what you are saying is the client already contains the rows but for some reason column values in the main table change that may cause the row to be re-downloaded to the ...Answered | 3 Replies | 14201 Views | Created by Joel Steen Timle - Thursday, November 26, 2009 9:11 AM | Last reply by Mahesh Dudgikar - Tuesday, December 8, 2009 6:47 AM -
0 Votes
versionnumber column in crm db tables?
The VersionNumber column is a timestamp in the DB.Answered | 1 Replies | 3209 Views | Created by dotnetteramg123 - Thursday, May 30, 2013 7:50 PM | Last reply by Salim Adamon - Friday, May 31, 2013 4:23 AM - Items 1 to 20 of 264655 Next ›
No announcements
