Home > Archive > MS SQLCE > August 2005 > No exception when INSERT of uninitialized record fails









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author No exception when INSERT of uninitialized record fails
Mike Yeager

2005-08-09, 1:23 pm

Mario Aoun

2005-08-10, 7:24 am

Hi Mike,

In Order to solve such situation, try to create another data adapter for the
operation.

mario

"Mike Yeager" wrote:

> I stumbled across an odd situation in a C# (2003) app. I inserted a new row into a dataset and never modified any of the column values. When I call Update() from the data adapter, it reports that 1 row was updated and does not throw an exception. Whe

n I look at the data however, no row was inserted. In fact, I would have expected an exception since some of the columns do not allow null values and don't have defaults. If I manipulate any of the columns, I get the exception. Is this a bug in SQL CE
2?
>
> Specializing in C#, SQL Server, VFP, Smart Cards & Mobile Devices
>
> Mike Yeager MikeYeager.com LLC
> 35 Clint Rd
> Taos, NM 87571
> myeager@mailblocks.com tel:
> mobile: 505-751-7261
> 505-613-0072
>
>
>
>
> Add me to your address book... Want a signature like this?
>
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com