Re: Guid Update Errors
- From: DracoWiz <DracoWiz@xxxxxxxxx>
- Date: Fri, 17 Mar 2006 16:50:27 -0800
I reconstructed the datagrid and subsequent add/edd forms -- but now it
appears to work -- no error displayed, but still no data updated into the
table either.
--
Your imagination is the limit --
"Darren Shaffer" wrote:
For the GUID column(s) that are added to your table to track replication,.
you
should not list or provide a value for these when inserting or updating
records.
The problem is that the SQL statements that are automatically being
generated for
you by virtue of data binding or a data adapter are not aware of
replication. You
may need to provide your own SQL to insert and update rows in a table that
is a
subscription to a merge pub. Just leave out the GUID columns that
replication
requires in your INSERT or UPDATE statements. You are right, they have
default
values already defined.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
"Wendell A. Clark" <dracowiz@xxxxxxxxxxx> wrote in message
news:ONwCGg4RGHA.5808@xxxxxxxxxxxxxxxxxxxxxxx
I have setup a small database on my desktop utilizing SQL 2005 Developer.
I have published it as a merge replication server. When published it added
a GUID (rowguid) to track changes.
I subscribed to the database on my WM 5.0 Pocket PC and then set up the
basic form - DataSet bound grid and the default entry forms.
When I added my first test record it told me that rowguid could not be
null.
I checked the table definition and it is marked with the default as
newid().
I built the PocketGuid class as describd on MSDN and set up my form to
fill the rowguidtextbox with the newguid (guid.tostring()) upon
titletextbox_lostfocus.
I can see the guid in the rowguidtextbox so I know it is not null. Yet,
when I attempt to add a new one again, I get the same error -- rowguid
cannot be null.
Is there something that I am missing --
Or alternately How would I make it work?
--
Wendell A. Clark, BS
Nurses Unlimited, Inc.
432-550-1700 x126
-------------------------------------
CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may
contain confidential and privileged information for the use of the
designated recipients named above. If you are not the intended recipient,
please notify us by reply e-mail. You are hereby notified that you have
received this communication in error and that any review, disclosure,
dissemination, distribution or copying of it or its contents is
prohibited. If you have received this communication in error, please
destroy all copies of this communication and any attachments. Contact the
sender if it continues.
- References:
- Guid Update Errors
- From: Wendell A. Clark
- Re: Guid Update Errors
- From: Darren Shaffer
- Guid Update Errors
- Prev by Date: Re: Any one could give me some advises about which database to use?
- Next by Date: Re: Query tools on SQL Ce
- Previous by thread: Re: Guid Update Errors
- Next by thread: Re: Merge Rep Error - No query processor exists...
- Index(es):
Relevant Pages
|
